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.
-
Implement a way to disable office clipboard
Hi,
While working with Access, I constantly do ctrl+c,ctrl+v to copy/paste from/to office and other applications. When the Office clipboard is full, the keys stop working until you manually "Clear all" the Office Clipboard. It gets full very very often. Please allow a way to completely disable office clipboard for office and / or individual applications inside office, or a feature to implement a 'rolling' clipboard stack pile where older elements are automatically erased, so clipboard never got full. Please. A lot of people complains about this on lots of websites as I saw.1 vote -
Replace VBA with VBA.net.
Replace VBA with VBA.net. You exist because of your customer. Develop solutions to your customers' needs, not your agenda. CUSTOMERS' NEEDS = VBA.NET! I don't understand why your company does not grasp this necessity. Good grief!!
36 votes -
multi core
Multi Threading for MS Access. As we all know ms Access is a single threaded application. If you all remember the fun of seeing, "this program is not responding" during a particularly heavy query or task. Multi threading would add huge value to the speed efficiency and capabilities of this application. I realize it would make visual studio WPF not as much of a stand out but lets be honest Access needs to get some real loving (not silly things like a search bar).
61 votes -
Let Access automatically detect the Outlook Version installed on a User's PC and have that Outlook Versions Library automatically installed.
If Access can automatically identify the current version of Outlook installed on the users PC and automatically have that Outlook Versions Library installed will save a lot of time and confusion for the Developer. The Developer will not have to physically intervein with the Library settings and he can distribute the Access application to a mixed environment that has mixed versions of Outlook.
1 vote -
Create a template for a username & password book
Create a template to record usernames, passwords etc. I use an address book, but it would be nice to have a pre-completed template on here
1 voteThanks for suggesting. At this point we aren’t focusing on new templates.
Access Engineering
-
VBA Updates
'~~~~~~~~~~~~~~~~
VBA Native line numbering
'~~~~~~~~~~~~~~~~
Adding line numbers is something that is a pet peeve. Line numbers should be Native and error trappable by default without having to add them manually.'~~~~~~~~~~~~~~~~~~~~
VBA Accessible Call Stack
'~~~~~~~~~~~~~~~~~~~~
A way to read from the call stack, function/sub names in order accessed, times accessed...etc'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
VBA Custom Toolbars to allow custom Macro/Function Calls
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If I could add my ow custom functions as a toolbar button and have my toolbar exportable and importable for others to use. As opposed to a full Add-In.'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
VBA button and/or right click to open…23 votesPlease use the Office Developers user voice site to suggest VBA improvement ideas
https://officespdev.uservoice.com/Thanks,
Access Engineering -
Enrich VBA, take it out of maintenance mode
So VBA was put into maintenance mode, Microsoft moved programmers to .NET. That was years ago. Office Desktop apps are still selling with VBA and yet VBA has not been enhanced - the two environments do not compete and I have not seen .NET intrinsically replace VBA and packaged as Office's internal programming language. There are so many ways that VBA can be enhanced. Linq can be added so that we are not typing mutiple quotes in unverified statements isolated in a string. String Interpolation. Managing large chunks of text in strings etc.. etc...
47 votesSuggestions related to VBA editor should be posted in the Office Developers User voice site here – https://officespdev.uservoice.com/
-
bug - New 2018 Black and grey themes
Changing to the new black theme and then closing out of access completely - re open access and change theme to colorful and the navigation search bar remains black, changing to grey and back to colorful also does not change the search bar back to white.
The black theme is a nice idea and aligns itself with windows themes and visual studio however the implementation leaves a lot to be desired. Disabled ribbon button labels are too dark and don't have enough contrast to be visible. Open a query editor window and try to read the labels in the bottom…
1 voteThanks for providing feedback on the recent added support of Dark and Black themes in Access.
Ribbon colors have consistent behavior across Office apps and we do not have a plan to change that.
Switching between themes without restarting Access may result in somewhat funky behavior and is unfortunate. However, we believe that ’s not a very frequent operation.Regards,
Access Engineering. -
Ribbon Creation Tool
You pushed upon the Office community the Ribbon back in 2007, when are you going to finally give us a GUI tool to develop ribbons properly? Right now, the ribbon is a half-baked concept with no tool to develop with.
162 votesAt the moment there is no plan to develop a tool for creating ribbons.
This suggestion should probably be directed to a broader UserVoice site as it relates to all Office products and not just Access.Thanks,
Michal [MSFT] -
Enable multiple versions of Access to co-exist on the same machine.
Enable multiple versions of Access to co-exist, side by side, on the same machine without ill effects.
Just like there can be multiple versions of Visual Studio, SQL Server, etc. Currently, to work in different versions of Access we need to maintain a separate machine (physical or virtual) for each version of Access.82 votesHi Alphonse,
It is not clear what is the problem you are encountering. Going through the comments other Access users left here, didn’t help figure it out as well.
To the best of my knowledge there shouldn’t be an issue with running multiple versions of Access on the same machine, so I’m closing this request.
If you feel strongly about it and can provide more information, please create a new request.Thanks,
Michal [MSFT] -
Fix Long standing known bugs!
Instead of looking for new features, why not fix what doesn't work properly. There are a number of well documented bugs (15+ years old in some cases?!) it would be nice if they were addressed.
20 votesDolly (et al), the risks involved in fixing bugs (and introducing new ones or breaking existing solutions) is a major consideration for us when prioritizing the bugs we are attempting to fix.
With that in mind, we are looking also into some of the older bugs and assessing the risk, investment and impact.It would be great and much more in line with the UserVoice site objective, to specify which bugs you are looking for us to solve, which are the major pain point for you.
I suggest you list them as separate items in this site and let others vote on them.In order to free up your votes, I’m ‘closing’ this item as “no Current Plan”.
Thanks
-
OSX Support
Would be great to see this application on Apple's operating system.
24 votesThis is a duplicate of another suggestion here: https://access.uservoice.com/forums/319956-access-desktop/suggestions/12499587-access-for-apple-pc-s
Updating the status to No Current Plan so you can re-use your votes.
Michal [MSFT]
-
Local Help
Enable Local Help Files as it used to be. The web help is slow, often leads to incorrect correct.
28 votes -
Deprecate all versions of Access
I would like to suggest to Microsoft an idea that came to me in a dream last night. My dream was a little bit like:
I was sitting in a bench at some park, there was no black people around, Donald Trump probably won the reelection. I was reading the news, "Elon Musk dies on his way to the sun"... For some reason I'm not surprised. All of the sudden I realize I was supposed to go to work because its sunday! I rush to McDonalds... on my way I see a massive screen showing the new capabilities of Access…6 votes -
fix the new charts in 2016 (eg Waterfall chart) so that they can be modified with VBA.
I have been unable to use the new waterfall chart in an application developed in Access. I can create it up but it doesn't allow changes of data or any property by VBA as other charts do. Why would MS create a really useful chart and then not fully implement it? There may be more up to date information on this, but a discussion from a year ago (June 2017) says the VBA hadn't been implemented then and apparently there has been no change. (Or am I missing something?)
https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msofficecustom-mso_2016/are-the-six-new-chart-types-in-excel-2016/3e8f9bf1-76a7-4a1a-91cd-9ed27165c17c1 voteThanks for trying out Access new charts!
However, seems like there is some kind of confusion here as Access doesn’t support a waterfall chart (yet). Also, the answers forum link discusses an Excel waterfall chart.
Perhaps your suggestion is in the wrong UserVoice site?Regards,
Access Engineering -
I am a former DBASE programmer. I find that language to be very powerful and yet the language in ACCESS does not support it.
I could create a PRG file that would perform much as an application ...
I am gradually learning the intracicies of ACCESS objects and how to build embedded queries inside of queries. I am also able to build some pretty exotic filters at this point. The Do While Loops coupled with nested If statements in DBASE enabled me to perform some pretty complex real world processing, that I find more n more complicated to replicate using ACCESS. It would be the BEST OF THE BEST if there was a bit of the same syntax as the Ashton Martin - DBASE.…1 voteThanks for posting this suggestion.
At this point we have no plans to integrate/support DBASE syntax in Access.
Thanks,
Michal [MSFT] -
STOP Teaching Students BAD Practices
OK I get it... you supposedly don't need to be a developer to use Access and that's great. But really you should stop training everyone who doesn't know any better that it's ok to do things like place spaces and weird character in object names. It will eventually bite you even within Access as soon as you move to VBA or a SQL Server backend.
Just because it can be done doesn't mean it should. It's just all around bad practice and eventually everyone who continues on to use Access will learn the hard lesson that is not taught in…
14 votes -
Create a new Requery method which returns to the current record
When you requery a form after updating another form or another table, Formname.Requery goes to the first record. On a continuous form it is a real nuisance to have to return to the original record. We need a Form.RequeryReturn function to bring us back to the original record. Obviously, isf the record is deleted it should return to the previous record.
76 votesThank you for suggesting.
As noted in the comments section there are workarounds to allow you to return to the current method after re querying.
Thanks,
Access Team -
Integration with Cortana for navigation purposes
Add navigation commands such as “Open”, “First Record”, “Next Record”, “Previous Record” and “Last Record”.
The “Open” command would be followed by the Form or Report…”Open Sales Order”…”Open Purchase Order”.
If possible a “Find” command would really rock. “Open Contact Maintenance”, “Find Jane Smith”.These commands would be very useful in a mobile environment.
1 voteThank you for suggesting.
There is no current plan to support Cortana integration in Access.
-
Search and replace on all database objects.
Queries, Forms, Reports, Macro, VBA, possibly even tables.
Today I do this by exporting all database objects to text files, using a utility that I built, and then using a customer text search app that I built to find strings using regex matches. Then I have to go and open the objects and manually make the changes.
68 votesThank you for posting and supporting.
We realize the ask is to have this as a native functionality in Access but there are great third party tools available to solve this problem, and currently there is no plan to enable this.
Access Team
- Don't see your idea?