Access (Desktop Application)
Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
java
Java Driver
please create a driver for java, so that it would be able to create a android frontend to accdb-databases3 votes -
Additional Error Object properties - which procedure, which module, which object, which db
The error object should be expanded to included properties which can reveal the procedure, module, and object that the error is taking place in.
0 votes -
Increase the size of the record display in datasheet view footer
Right now the size is not big enough in many cases depending on the number of records. Since datasheets are usually wide anyway, this can be easily increased.
0 votes -
Allow disable of filter icon on datasheet at the bottom.
On many forms I create, I include filtering fields at the top of the form, a filter and clear filter button and the datasheet below. If the user unclicks the filter on the datasheet, this causes issues as the filtering on the form above is not cleared at the same time because the main form does not know about the "unfiltering" below. If the datasheet view had a property that controlled the "filtered" button option. If disabled, just show the word filtered if it has been but not clickable.
1 vote -
Resolve ODBC / SQL Server issues with NVARCHAR(MAX) and REAL
Several SQL Server / ODBC data types poorly supported. I have just found that NVARCHAR(MAX) is the recommended SQL Server memo field type but Access is inconsistent in handling this - text larger than 4000 characters fails to update.
1 vote -
Better Backwards Compatibility
I have three version of MS Access - 2013, 2010 and 2007. I need this so if I develop a DB with library references (in particular the MS Excel library) and it has to work in an earlier version of Access (so if I developed it in 2013 but it has to work in 2010) I have to open it in 2010 and make sure the references are not missing before giving it to a user. I have tried multiple times to write code that will try and remove the missing reference and add a valid one but why? These…
18 votes -
Enhance Vertical Text to turn 90, 180, 270 degrees
Idea here is, that you should be able to turn text a) not only top to bottom but also b) flipped and c) bottom to top
18 votes -
Make it possible to stop Access Desktop from being an Automation Server so that security is improved
Currently, if a user has Access running, much of what is meant to be secured can be accessed from another program, e.g. Excel, via Automation. This is not good.
19 votes -
Provide a better link to Outlook especially for adding appointments
I have always wanted to be able to add appointments to Outlook via the link to the PST file using an append query.
9 votes -
Add a new operator to Group By queries
Let's call it something like "Concat". It would concatenate values in a field instead of summing them.
Take this query:
SELECT Product, Concat(Color) FROM ProductColors GROUP BY Product. The result might be something like this:Flag Red, White, Blue
Tractor Green, Red9 votes -
Table column count to the same than in SQL Server
It makes it much simpler to create applications if 254 column restriction is not applied like in Access. Unfortunately in Engineering system I can't avoid using more than 254 columns. Computer speed is not anymore a problem so why to have that limit.
8 votes -
Add capability to call stored procedures with DAO
Please add the capability to call stored procedures in a remote ODBC database with DAO, like it existed in the past with ODBC-Direct-Workspaces.
Pass-Through-Queries are only a kludge because parameters have to be concatenated into the sql string.21 votes -
MsgBox Custom Choices
With MsgBox, we can process vbYes, vbNo and other built-in choices ... it would be nice to be able to have 3 custom choices ... ie: vbCustom1 and vbCustom1Caption, vbCustom2 and vbCustom2Caption, vbCustom3 and vbCustom3Caption,
14 votes -
DSN less connection wizard
Please design a wizard for dns-less coonections to SQL databases. Make it easier to use Access as frontend devolpment for different situations.
Other RAD tools have this already.11 votes -
Enable Ctrl-Spacebar to Popup Intellisense in Queries
When designing queries, it would be nice if Ctrl-Spacebar could be used (as in VBA) to pop up intellisense when typing expressions, criteria, AppendTo, ...
10 votes -
Ability to Show Property Sheet and Field List at the Same Time
This is not new ... just missed! We used to be able to show the Property Sheet and Field List at the same time ... I miss this a lot!
12 votes -
When switching back to design view from the IDE, select the last selected design object.
When multiple forms are open and you go into the VBA IDE and then switch back to the GIU view, the object that was selected is no longer selected or the object that thew the VBA error is no longer selected. Furthermore, you can't just select the object from the tabs. You first have to select another object before you can select the one you want.
1 vote -
Easier way to backup data
Please add a standard way to backup your tables to an external database ( file or SQL) on time or in the case of a certian event.
9 votes -
Make it possible to properly hide the Navigation Pane
Currently this can be made visible programmatically from an external program via Automation.
10 votes -
MouseOver Highlighting on controls and continuous forms
Should be able to have a property for controls that can highlight when mouse passes over other than a button. Similar to Windows 10 Start menu or other Windows menus. This should also be allowed for a single row on a continuous form. Perhaps this could be a property in conditional formatting.
6 votes
- Don't see your idea?