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.
-
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 -
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 -
Document the LoadFromText and SaveAsText methods
There are two undocumented methods, SaveAsText and LoadFromText, which were originally used for the old SCC integration. Since Access 2013, the source code integration has been removed and we now rely on third party tools (e.g. OASIS-SVN or Ivercy being example). It is my understanding those still rely on the undocumented methods. This request is to ask that Access team document those methods and thus make it supported so that those tools can continue to count on it being available and provide a solution for source code without taking any resources from Microsoft.
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 -
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…
26 votes -
Create a stand alone file independently version of Access or Runtime and 32 or 64 bit architecture
Due to the currently conflicts between versions, I think it would be necessary to create a stand alone file that can be run independently of the version of Access or Runtime and 32 or 64 bit architecture, that the user has installed!!
26 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 -
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…
24 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.
24 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 -
64 bit version of mscomctl.ocx.
I support an application with over 90K registered users for a international logistics company (the guys with the brown trucks). We can not support the 64 bit version of Office Access because there is no 64 bit version of this library. Converting the Tree Views to use .Net would be cost prohibitive.
24 votes -
Fix rendering of VBA UserForms with Parent controls (eg. Frames) in Access 2003+ file formats
The Access 2000 mdb format supports VBA UserForms with normal and parent controls, but all database formats beyond Access 2003 (ACCDB) only render UserForms that do not include Parent controls.
Being able to reuse UserForms across VBA hosts is a very useful way of reusing code and User Interfaces, but a runtime error (Error 75) occurs when trying to render a UserForm in an ACCDB database format, when there is a Parent control (such as a Frame or MultiPage control) present.
Parent controls enable rich functionality and more intuitive UI, but Access fails to render the forms, with an error…
24 votes -
import from excel
Better control of datatypes when importing from Excel or linking to a worksheet.
Currently the import decides for you using the first few rows, so often you have truncated memo fields when the first few rows are less than 255 char or errors when the first few rows are numeric but later rows are alpha numeric.
When importing into an existing table the import should honor the datatypes in the table.
23 votes -
All the 32 bit dll and ocx should work in 64 bit os and office
We are working with 32-bit add-ins for access. But it is not possible to work in 64 bit system which I am using.
23 votes -
Create PDF-File with merge function
Create more than one PDF-File from the Report and merge the PDF-File to one PDF-File
23 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.
23 votes -
22 votes
-
with accde: create forms and controls at runtime. even reports.
how wonderful it would be to have programmatic access to create forms and Controls at runtime (compiled version)
Even The ability to create and change reports.22 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?
22 votes
- Don't see your idea?