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. 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.

    https://answers.microsoft.com/en-us/msoffice/forum/msofficeaccess-msowindows8-mso_2010/crosstab-query-to-display-all-records-according-to/b98b9372-1a83-402d-b54d-87ca5b7a7407?messageId=c8966d76-2bcd-4a49-a1cc-83cdcf71a483

    Either an access development enhancement to enable this would provide more flexibility to create complicated reports.

    Thank you…

    28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    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 →
  5. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    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. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    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 →
  13. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    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 →
  15. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    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 →
  17. 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
    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 →
  18. 22 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 →
  19. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    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 →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base