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.
-
EnableEvents
Currently, if a database is opened through code, it requires gymnastics to avoid running startup stuff. It would be nice for Access to have EnableEvents like Excel does
thank you
3 votes -
System help forms - allow resize
Lots of system help forms (i.E. on Query the search table or the references form in VBA to search DLLs ) are far too small and the user cannot resizre them, why ? Just allow to pull them bigger would help
3 votes -
Code Window in Form Design
Instead of separate window where coding takes place outside of form design, have it as a window positionable beside or below the form design.
1 vote -
add Align Objects Center and Align Objects Middle
These buttons would work they way they do in other Office products.
Also, rename Align Left|Right|Top|Bottom for objects to include the word object. Align Left, for instance, is the tooltip for 2 very different things.
0 votes -
Intellisense/Builder Recognize Table/Query Aliases
It would be nice if Intellisense/Builder would recognize Table/Query Aliases
2 votes -
QAT Filter
There are lots of commands to choose for the QAT and finding what you want can take time. It would be nice to be able to filter the choices
1 vote -
Save/Restore Workspace
Excel has an option to save and restore the workspace, which is very convenient for opening all the files and positioning them where they were before. With Access, of course, this would be objects in the current database instead of files.
2 votes -
BrowseTo add parameter OpenArgs
Why not have an OpenArgs parameter like in docmd.openform ? Would enable to react in forms based on OpenArgs - especially helpful when you want to open a form on several places with different actions.
3 votes -
Reference from Relative Position in a Query
In Queries, it would be nice to be able to reference a value in a record relative to the current one.
For instance, many times it is required to get a difference in a changed value
0 votes -
Export Options
When exporting, it would be nice to be able to choose how data in form/page headers/footers will be treated:
1. as displayed
2. only at top and bottom
3. do not includeespecially for RTF and formats that will end up in Word
1 vote -
SaveAs
I add SaveAs to my QAT -- but it would be nice if it was there by default.
When Save As (for object) from the backstage or whatever it is being these days, does NOT show what you are looking at -- this makes naming difficult.
1 vote -
Close all but the active object
It would be nice to have an option to Close All but the active object ... Close All would be ok too!
3 votes -
Just get the first record for each whatever in a list
In queries, when there are multiple records for criteria, it would be nice if we could specify to just get the first record matching a certain condition but show all records matching criteria for the query.
Example:
list of all last order dates for a customer0 votes -
interate a powerful smtp-mail object with html and attachment support
the docmd.sendobject ist too limited.
html formated Mail-Body is essential and easy sending attached files.
the object should be robust, and retry sending if the mailserver is not available.
If the existing Rich Text Control would support Pictures it would be perfect to use it as a mail Editor.
That would be great!0 votes -
POSSIBILITY TO ADD SEGMENTS LIKE EXCEL IN A FORM
To apply filter easily
data source: values of the segment : sql
child object : subform in continhous mode
field father:child
Sorry for my poor english0 votes -
SQL Server - Linked Tables: Add discription to field names in development mode.
In MS Access its easy to add descriptions to fields in table editor. These descriptions are neither taken over when using ssma nor are they brought back to Access when already existing in sql server.
I've written a vba-script that creates an T_SQL script to create all field descriptions of a table. But even if descriptions exists they are not reshown in the linked table.
0 votesThanks for posting.
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
Stay tuned.
Regards,
The Access Team -
Report bug
Create a report on a simple query with no report sort option specified. In the On Open event of the report, call a macro that does the SetOrderBy to sort the report by a query field (you can also do an event procedure for the On Open event that runs code that does the same thing (DoCmd.SetOrderBy ("field")).
Open the report in preview mode. That will work. right click and switch to layout mode. That works also. Then switch to design mode. All is good. But if you open the report in preview mode and switch directly to design mode,…1 vote -
RDP of MS Access is Excrutiatingly Slow
I've narrowed down the issue, when the "Property Sheet" on the right is shown RDP lag time is in the seconds, hide the "Property Sheet" and it's back to full speed.
Using latest stable Access 365. Please fix.
0 votes -
Alt+ J,K,L,I = movement
Is it possible to make Alt + J,K,L,I perform left, right, up, down movements throughout windows, please. It's so much more convenient when typing, you wouldn't need to use your mouse, or move your hand away from the letters to navigate to a word. In addition Alt + H = Home and Alt + ; = End. Hope this is a valid feature to add to windows, regards...
1 vote -
Provide an easier method to return or pass property values to a dialog form
I understand this would require a re-wickering of Access forms, but this is difficult to accomplish in Access without some serious workarounds. At least have something like a Dialogresult property as in .Net so the user can get simple values from the dialog form when closed.
0 votes
- Don't see your idea?