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. I love PowerQuery for Excel for any ETL-jobs. Same tool for ACCESS?

    For many ETL-Jobs in EXCEL I use PowerQuery. Many jobs, formely done with VBA, can now be solved codeless.

    I would like to use the same techniques in ACCESS, e.g. collect many txt-files from one folder, unpivotize etc...

    Greetings to the community!

    Peter Rühm

    14 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 →

    PowerQuery is a great Excel feature which allows users to discover, combine and refine data across a wide variety of sources.
    Access allows users to connect to a wide array of external data sources in a way that is unique to Access users and scenarios.
    When we think of data management solutions across Office, we think of Excel and Access as somewhat complementary products, but not competing.
    With that, duplicating capabilities from one product to another is not supportive of this perspective.
    We are looking at further enhancing and improving Access’s abilities to connect to external data sources, but not in the form of integrating PowerQuery.

  2. allow VBA to compact an open Database

    With VBA it is only possible to compact a database when it is not opend. It would be helpful to let VBA copmact the currently opended database like you can do with the UI.

    8 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 →
  3. Split windows vertically in VBA

    Now I can only split the window horizontally in VBA. It would be nice to split the window vertically.

    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 →
  4. Get Rid of 2gb file size limit because Access can be an awesome tool for Ad Hoc data analysis

    I can live with the idea that transactional databases >2gb should live on SQL server. But what if I need a tool to investigate data in an 80gb csv file? Yes, I can do this on SQL server, but getting my hands on a server and permissions, etc is a weighty task. Internal data likely already exists in a SQL server (which I can connect to via ODBC), but more and more often I'm dealing with huge flat or csv files from third parties or other public sources.

    Access is an awesome tool for ad hoc analysis work, I'd like…

    63 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 →
  5. Collecting Data via Email

    this feature was removed from office 2013 and I dont understand why as its much easier for users to fill out a form that comes as outlook email.
    Don't see any other feature we can use that are as simple and straight forward as that!

    52 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  1 comment  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  6. STOP Teaching Students BAD Practices

    OK I get it... you supposedly don't need to be a developer to use Access and that's great. But really you should stop training everyone who doesn't know any better that it's ok to do things like place spaces and weird character in object names. It will eventually bite you even within Access as soon as you move to VBA or a SQL Server backend.

    Just because it can be done doesn't mean it should. It's just all around bad practice and eventually everyone who continues on to use Access will learn the hard lesson that is not taught in…

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    No Current Plan  ·  5 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Naming

    Naming rules
    When creating forms and report Access use the standard naming
    Labels as LabelsXX
    Buttons as CommandXXX
    And so ON
    What users do is that they rename this after own preferences

    Labels as lblNameofControl
    Buttons as btn
    MyName

    This naming option should be customizable for each user so they can set their own rules for how the labels or buttons or other controls should get their name in MS Access

    30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
  8. Create a new Requery method which returns to the current record

    When you requery a form after updating another form or another table, Formname.Requery goes to the first record. On a continuous form it is a real nuisance to have to return to the original record. We need a Form.RequeryReturn function to bring us back to the original record. Obviously, isf the record is deleted it should return to the previous record.

    76 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. FIX BUG: runtime error when resizing subreports in a report using VBA

    If you have a report that needs to resize a subform control containing a subreport for each record, you'd like to change the subforms width and height properties in Format event procedure. In preview this leads to a runtime error "not enough system resources".

    Changing the size in Load event procedure works properly. But you can't have indivual sizes for each record.

    I encountered this issue in Access 2010.

    3 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 →

    Thanks for reporting.
    We will add this bug report to our backlog and see that it is prioritized and handled.
    In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

    Thanks,
    Michal [MSFT]

  10. Fix Docmd.Transferspreadsheet

    Microsoft Access and Microsoft Excel you would think would be hand in hand... but the problem has persisted for years that it has always been problematic getting the correct data types between Access and Excel columns when Importing and Exporting to and from Access to Excel and vice versa.

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

    Excel doesn’t support data types which makes it very hard for Access to recognize data types from Excel when importing.
    When using the wizard to import data from Excel, you can determine the column types and save the steps – this could be a workaround to mitigate the issue.

    Access Team.

  11. 2016 SQL Edit bug: If there is a Where and no group by, can not edit without Error 1001

    Can not make any change to the SQL (even adding a space and taking it out) for any SQL with a WHERE clause but no GROUP BY. For example, to put a DISTINCT after the SELECT.

    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 →

    Thanks for reporting.
    We will add this bug report to our backlog and see that it is prioritized and handled.
    In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.

    Thanks,
    Michal [MSFT]

  12. Integration with Cortana for navigation purposes

    Add navigation commands such as “Open”, “First Record”, “Next Record”, “Previous Record” and “Last Record”.
    The “Open” command would be followed by the Form or Report…”Open Sales Order”…”Open Purchase Order”.
    If possible a “Find” command would really rock. “Open Contact Maintenance”, “Find Jane Smith”.

    These commands would be very useful in a mobile environment.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. Search and replace on all database objects.

    Queries, Forms, Reports, Macro, VBA, possibly even tables.

    Today I do this by exporting all database objects to text files, using a utility that I built, and then using a customer text search app that I built to find strings using regex matches. Then I have to go and open the objects and manually make the changes.

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

    Thank you for posting and supporting.

    We realize the ask is to have this as a native functionality in Access but there are great third party tools available to solve this problem, and currently there is no plan to enable this.

    Access Team

  14. Can we have the option when you run a runtime for the first time to remove the security warning

    If the Access Front End is not stored in My Documents, the only way to remove the warning is to poke around in the Registry and put in the path where the Front End is stored. This is dangerous and not user-friendly. Ask the user if he/she accepts the risk and then allow use without the warning.

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Runtime  ·  Flag idea as inappropriate…  ·  Admin →
  15. Future of MS Access

    Hello
    My post is a general post about which way should MS Access take in the future. I have used Access as a professional tool in my company against large and small companies from the early versions of Access. I believe that this is the most common use of Access although Microsoft from the beginning of the product have added this at the Office package as a low-threshold entry to the database worlds. Microsoft has reduced the availability of Access in its Office suites from early beginnings. In view of this, I mean Microsoft should let go of Access as…

    19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. Include Access Desktop in all O365 subscription plans.

    The idea is to demonstrate its power for developing sophisticated applications and to proliferate its use. The average user tends to use Excel instead of Access because it's a lot easier for them to grasp, so perhaps MSFT can create a website for all Professional Access Developers and refer users who desire education and development assistance?

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

    Thanks Frank for the suggestion.
    I’ve passed this feedback including all comments) to relevant folks.
    Since it’s not a suggestion for the product per-se, I’m updating the status so you can get your votes back.
    Use them wisely :-)

  17. Provide a better SQL editor

    Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.

    231 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    23 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Is Anyone Home?

    As a VBA developer who knows the language inside and out, I provided a ton of feedback about 5 years ago on a consensus of what was requested by developers at large. Microsoft does NOT listen. No need to reinvent the wheel here.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Give us a wizard to create ribbonbars like we used to have for the old menubar

    Give us a wizard to create ribbonbars like we used to have for the menubar. Creating complex ribbonbars by storing HTML in the USysRibbons table is very time consuming to create and maintain. Especially hard to debug errors.The old menubar wizards made this task quick and easy.

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

    At the moment there is no plan to develop a tool/wizard for creating ribbons.
    This suggestion should probably be directed to a broader UserVoice site as it relates to all Office products and not just Access.

    Thanks,
    Michal [MSFT]

  20. Provide a way to develop a truly "stand-alone" app

    Hiding the ribbon, navigation pane, and database window, along with denying access to tables, queries and design environment always requires a lot of work. Would be nice to have a MDI form, and menu bar control. The user would only see and have access to the MDI and its menus. Everything else is hidden and unaccessible by the user.

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

Access (Desktop Application)

Categories

Feedback and Knowledge Base