Feedback by UserVoice

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Allow current version options for Export to Excel

    When exporting report results there are two options for excel output format (95 and 97). Excel is a very effective output format but these two versions seem to cut the size of text to 256 characters (not so useful when the display limit in current versions of Excel for text in a cell is 1024 (even though content stored can be much greater). Would like to see an option for current Excel format.

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Make Content Fit Within the Visible Area of the Screen

    When I open a table in design mode, the windows opens and the right-hand side often goes beyond what is visible within the screen and will go behind the property explorer. This means every time I want to close the objects I have to move the object, often several times, before I can access the control box. Same goes for queries, forms...

    This is very poor ergonomics and makes accessibility very difficult. You have an available unused area (screen minus ribbon, minus nave pane, minus property sheet) use that and do not go beyond that unless I manually resize it…

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Coloured Tabs in Tabbed Forms

    The only way to make a tabbed form have a colour is to resort to some trick like using a coloured background behind a transparent tab or pasting an image onto it. These cause problems when moving controls around.

    It would be nice for the tab control to have the same functionality as a form where one can set the background colour.

    41 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. SQL Window: Change Font Size

    When writing and reading SQL in the SQL editor window, it would be great to be able to adjust the font size, especially when one has long sections of SQL.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. sub requery

    Better SQL windows for editing
    Easiest wait to see sub query

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Clearer Error Messages

    I have been getting error messages when trying to export a file from Access to file. Sometimes the export worked and sometimes it didnt. Access produced an error but it was not clear where the error was. It was simply that some of the files I was exporting included special characters ie "/" symbol. Surely if Access can recognise the error it give a clearer indication in plain English as to where error was.. in this case the error could have read 'Incorrect format of file to export'. Not everyone is experienced in VBA and we try to learn as…

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. To implement the same functionality like in Excel to get the data from table located in web page.

    Usually there are some data located locally and in some web pages. There are some ways to get web page data to access database throgh VBA, but it's not so convienent and universal.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Office 2016 / ODBC - Problem with drivers in Access files - Please confirm if this is By Design

    Customer has a HRD application connects to Access DB. After installing ODBC 2016 or Office 2016 (which includes ODBC), the awards in Logbook ceases to work and reports only zeros. Customer has a workaround for now:

    Fix: An automatic workaround will be put into HRD.
    Workaround:

    Modify the registry to use the new (old) strings.
    1. Pull up regedit and go to HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources
    2. Note the “Microsoft Access Driver (.mdb, .accdb)”. That was added partially in 2007 and fully in 2010. Some older entries may have the old style string already.
    3. Change them back to the…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for calling out this issue Subhabrata.
    We are investigating this issue.

    @Mark Burns – this is a different issue that we are looking into as well. Please post as a separate suggestion so people can vote on it and we can address.

    Michal [MSFT]

  9. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Form scaling and splitter bars

    Provide for splitter bars as well as form size scaling

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. For security, support passing the database password on the command line

    With a Windows shortcut, one can customize how an Access database is launched. Many options are available including the specification of the workgroup, user name, and password: https://support.office.com/en-us/article/Command-line-switches-for-Access-558cfe1d-3c98-4292-bee8-1f5df9702bf1

    Unfortunately, since the introduction of database passwords in Access 2007, this hasn't been added to the command line options. Without it, the user is prompted to enter the password when the database opens. This prevents letting users run the program without giving them the password and makes this security feature of limited value with ACCDB databases that can't support workgroup security.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    18 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Make Reporting Like Excel

    Add features similar to Excel, fit to pages.

    The current setup where report work on one printer yet do not on another is very hard to work with. A feature that scaled the report to fit would be awesome.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Create a GUI to Manage Shared Images

    There is currently no way to review image in the Gallery. It would be nice to have the mean to review, edit, delete the gallery.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. query results: duplicate field highlighting

    Add conditional formatting for query results such as duplicate field highlighting (like Excel).

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Would like the Return filter drop down under query design to have more options

    Currently under query design you can use the drop down to return All, or top 5, top 5%, etc. What about return distinct or top n or bottom n or top n %... etc. ?

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Treeview style Nav Pane custom groups

    The current Custom Nav Pane Groups are too limiting, we need the ability to add sub groupings (sort of like a treeview) so you can breakdown groups.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. hypertext

    Auto-management for multiples externals hypertexts (by record)
    For multi linked documents (PDF) or multi mail by record

    Previous Next Second, Add, Delete

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. picture

    Auto-management for multiples externals images (by record)

    Previous Next Second, Add, Delete

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base