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.
-
Create a table / linked table with a size greater than 255 fields
When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.
30 votes -
PDF Export with PDF-Form-Field-Functions
The Adobe PDF-Format allows to implement form-fields. This fields could be filled in by the receiver of the PDF-File.
In my opinion it would be great to generate an PDF-File with Access with form-fields. If the data from Access could be pre-filled in, this would be great.
The generated PDF could then be sent via Email to a client. The missing data could be filled in direct with Adobe Reader and then printed out.
At the moment the PDF-Export just generate an PDF-File without form-fields.
29 votes -
Incorporar la tecnología de Project Nucleus a las listas vinculadas
Con Project Nucleus las listas se sincronizarían con una BD local con lo se podría trabajar sin conexión y se eliminarían los problemas de las listas demasiado largas. Si esto funcionara también con las listas vinculadas, Sharepoint se convertiría en un estupendo back-end para Access.
29 votes -
Provide conditional formatting features to datasheets and continuous forms
As per Excel, it would be great to highlight and distinguish field data between the records displayed. Currently, if a format is set on a field, in a continuous form, the entire column receives that format, whether or not the data value contained, matches the criteria.
29 votes -
improve appearance and design of Access Forms
modern optical effects like in Windows 10 or modern webpages would heavily improve the value of created Apllications.
Better Mouseover-Effects for Buttons, Fading Effects for Forms....
it would be great!29 votesNeed more info ·AdminMicrosoft Access Product Team (Microsoft Access Product Team, Microsoft) responded
Thank you for this feature request. Can you please be more specific with what requests would enhance the overall Access Forms appearance? What specifically would you like to see regarding Fading effects? What other suggestions do you have?
-
vertical text orientation
The Vertical Text property rotates text 90º but it is not possible to rotate 270º or other. There are many people searching for this feature over the internet for years now, but there has been no solution for this feature built in access until now. There are many workarounds, but very complicated. Hope more people find this usefull
28 votes -
Allow User to Hide Feedback Button in MS Access 2016 Backstage Using XML
My applications, a synthesis of MS Access and MS Excel using automation, are totally self-contained and use customized Ribbons, so Backstage on the Ribbon is a distraction for my users. If I could, I would hide it entirely, but that isn't possible. Until Access 2016 all Backstage elements could be hidden individually using XML, but with the introduction of the Feedback element in Access 2016, this no longer seems possible. It doesn't make much sense for a user of my applications to provide feedback directly to Microsoft, so I'm hoping the inability to hide Backstage Feedback using XML is an…
28 votes -
Develop the SQL User Interface
SQL is something that I find particularly useful when I am running a database. However, the SQL user interface is very poor in my opinion. It should be more something like the Visual Basic interface, where when you start typing in a formula, then it has a dropdown with all your options and when you select the function from the dropdown, it will show you how to build the formula. For me it becomes very time consuming to have to go online to figure out how the function is built. Also it would be great if it can be colour…
28 votes -
ITEMS in Detail Section with Crosstab Queries and specified fixed headings should have option to suppress repeating
Whenever an ITEM such as a heading progress bar is in the Detail section, so if you display the form as Continuous Forms, you will see a progress bar in each displayed record. It will happen whenever a Continuous Form displays more than one record.
The only way to avoid this is to move the progress bar to the form header (or footer) section.
Please refer to the attached design, on the very last page described in microsoft forums.
Either an access development enhancement to enable this would provide more flexibility to create complicated reports.
Thank you…
28 votes -
Seamless Integration of MS Access with Cloud and Mobile phones
I would like to make an access project (database and its associated forms and reports), upload it to a microsoft cloud, and to be able to access it via web and mobile phones. Is it currently possible?
28 votes -
USysNotes Object for documentation
When creating objects such as forms and reports it would useful to be able to have a dialogue form where you can key in notes and a date to keep documentation current. Have a few columns for date, user notes and developer notes. On the ribbon, have a notes icon which will open the notes to the current object for display and edit. Have it link to the ID Field in Msysobject table.
27 votes -
Replace/remove Ribbons out of Access (or better out entire Office).
Replace/remove Ribbons out of Access (or better out entire Office).
Nearly every, even the smallest little and tiny application has an better menu structure than this space taking ugly ribbon thing. Besides, now we must conclude that after 8 years of introduction there is still no decent ribbon builder included within Access it is time to get rid of it. Lets say, it was a nice try, but let's return to something better please.27 votes -
Bring back the shortcut menu interface for creating shortcut menus
Shortcut menus are very usefull and after access 2003 the interface for creating them has removed.You have to bring it back.
27 votes -
Hide Navigation Pane In ACCDE Files
I have never understood why after all the effort put into compiling Forms and Code in Compiled Access databases and then they leave the Navigation Pane exposed so that all Tables are revealed and accessible to end users. Sure you can hide the Navigation pane but anybody can go into Options and reveal that Pane.
This has been a major negative to Access for me for years ....
Dick
27 votes -
Deal with sleep mode properly for tablet environments
When a tablet or PC goes into sleep mode any active form looses its connection to the database backend (I am using SQL Server). This is very annoying in tablet environments where the PC is frequently switched to sleep mode. Make it so that Access can detect a reawaken from sleep and refresh the connection automatically rather than leave an error so that the user doesn't have to log off and reload the screen.
27 votes -
Ability to view the Field list in the VBA Code Module
When you are in the VBA Code Editor, and you want to refer to a field on the form, you have to flip back to the form to find the field name before you can use it.
It would life so much easier if the field names were listable in the code module in the View option as per the Object Command on the Form's Design View.
26 votes -
Please stop Access 2013 from automatically changing the Modified Date on Access files if no changes are made to a file
I have Office Professional 2013.
I have it installed on an Asus Laptop running Windows 8.1.
Also OP 2010 on Windows 7.
I open 99% of my files through "File Explorer" as I have several thousand (files) sorted into numerous sub-folders.
Whenever I open an Access file to check some details and then close it WITHOUT MAKING CHANGES "File Explorer" shows that Access has automatically changed the "Date Modified" to the most recent date and time that I open and then close the file.
This is despite the fact that the last time I may have made a change whether…
25 votes -
Macroes vs VBA in Button Wizard
When using the Button wizard MS Access creates macroes as default. This should be an option if you prefeer macroes or vb as the event code.
25 votes -
VB Code References Dialog Box should be sizable
If we open any VBA module (either a module or the one in code-behind-forms), one of the choices we have is pointing the Jet or Ace engine to the correct Reference Library. This dialog box is very small and should be bigger by default. Ideally it should be sizable and Access should remember the size where we left it. That would be NICE!
24 votes -
Function to completely hide Access Window (tick box)
Currently we are having to use custom modules to disable the main access window although these work their the cleanest way of doing things, would it be possible to add a function in the options menu to hide the Main Access window and only show Popup forms and reports.
24 votes
- Don't see your idea?