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. Integrate MS Access with Power Apps

    I've been looking more into Power Apps, and I think it would be great for you to work with the Power Apps team to provide a web and mobile solution to what Access can do today on the premises of a server. Because there is unfortunately no web version of Access, maybe Power Apps can help solve this problem? Ideally, we should be able to continue moving (and linking) Access data into SQL and then create a Power App on top of the "Access-created" data from SQL; essentially viewing a Power Application that looks exactly like access but online and…

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →

    This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
    Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
    https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0

    We will still continue to make investments in SQL connection either way, but we are also happy to…

  2. improve appearance and design of Access Forms

    modern optical effects like in Windows 10 or modern webpages would heavily improve the value of created Apllications.
    Better Mouseover-Effects for Buttons, Fading Effects for Forms....
    it would be great!

    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 →
  3. 7 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 →
  4. Why not define a Ctrl-". This would fill a field with one date higher than the field above it.

    I do a fair amount of data entry that involves date data into a database table. I can use the Ctrl-' function to add to the field the data in the same field directly above it. This is great. But I have to enter a lot of records with dates, and the new record is for a different date, usually the next date on the calendar. So if there was a function Ctrl-", I would be able to directly add the next day to this record when compared to the record above it. For example if Record 12 has a…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  5. Provide Microsoft Access FORM with an event similar to Excel userform's QUERYCLOSE event, in order to identify "how" the form was closed.

    Provide Microsoft Access FORM with an event similar to Excel userform's QUERYCLOSE event, in order to identify "how" the form was closed.

    1 vote
    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 →
  6. problem in linked table manager to Reconnect tables VIEW-SQL the Key deleted ? version 16.0.13001.20384

    hi

    When I use linked table manager to Reconnect tables VIEW the Key deleted -- in ms access 2019 (365)

    VIEW -SQL
    for example
    dbo_movment (SQL )
    The problem is only in VIEW

    in Another table (SQL ) has no problem

    Previous versions of Access had no problem

    The problem is only in the 2019 access

    The issue is also in the version 64BIT and also In version 32BIT

    How to solve the problem ?

    I use SQL2016
    With whom I also worked with Access 2016
    When I moved to Access 2019
    Table refresh interface changed
    And since then there…

    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 →
  7. Fix Bug - InStr And InStrRev

    InStr or InStrRev function results in error or crashes database if sort order is “General”).
    Work around: Options > General > New database sort order > General - Legacy’, followed by ‘compact database’.
    The behaviour is very odd in that e.g. it may or may not work first time after reboot / logon, but fails subsequently. Compacting and then restarting the database never fixes the issue.
    This problem resulted from recent (Quarter 2 to July 2020) Windows and / or Access 2019 updates.

    1 vote
    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 →
  8. For starters, could you have feedback on the latest edge and not IE 11. I would like for Word or Outlook to have a different colour icon.

    For starters, could you have feedback on the latest edge and not IE 11. I would like for Word or Outlook to have a different coloured icon. They are both on my taskbar and it's annoying when you look down quickly and think you are choosing one when you choose the other. All the other colours make quick selection easy, but 2 blues?

    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 →
  9. 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 →
  10. Import PST to Office 365 an automated tool

    MS Office 365 email service provides various opportunities for businesses to standardize the requirement . Moving PST to Exchange Online can be formidable. EdbMails import PST to Office 365 utility does this job easy . You can migrate a particular folder or outlook data files that you want to migrate from a PST file to Office 365 tenant.

    The solution supports the migration of PST files to Office 365 including emails with attachments, tasks, notes, contacts, and calendars.

    Overview of its features:

    Direct PST file migration to Office 365 tenants
    No limitations on File Size
    Supports Incremental migration. No duplicate…

    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 →
  11. include an example to illustrate declare or setup of Hyperlink field

    When using class mode of VBA, there is no explicit example to declare or use Get/Let procedure

    1 vote
    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 →
  12. Automated Office 365 Migration

    EdbMails simplifies Office 365 Migration by automating the configuration and migration tasks. Effectively transfers the data between two Office 365 tenants. It allows you to migrate all the existing mailboxes, contacts and distribution groups, etc. from one Office 365 tenant to another. Its incremental migration feature avoids duplicates on the target mailbox.

    Key Features & Advantages:


    • It can perform as a single batch move that includes all of your mailboxes, contacts, and distribution group objects, etc.

    • Designed with multithreading which improves migration speed and saves lot of time.

    • Only the newly added items are migrated to your target server on…
    1 vote
    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 →
  13. Allow contact info to be changed. It is tied to location, but we have a different point of contact

    In the contact info box, we cannot change the default name to our local contact. The name that populates is a person that does not work in this facility.

    1 vote
    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. Enable us to lock the tab we're working on within a Tab Control

    Working on controls within a Tab Control can be very frustrating. You can't drag a box around controls, because you end up moving the Tab Control containing them and I'm forever accidentally selecting the Tab Control.

    Can we have some way of locking us on to the selected tab, locking the Tab Control's position and allowing us to drag a box around controls on a Tab Control?

    3 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 →
  15. add "Find and Replace" functionality in Queries "SQL view".

    It will be really helpful to change/correct table names/references quickly.

    Many times I need to change the base table names to a different one in a complex query with formulas that refer to table names. Currently, I need to copy the SQL to notepad, make the changes and paste it back in the SQL view. However, this resets the column ordering in Datasheet view. I think "Find and Replace" is quite basic function to have while working in "SQL View".

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  16. Convert OLM files to PST format

    Convert all the Mac OLM files to Outlook PST format with the help of new OLM to PST converter tool. The tool maintains the data integrity and accuracy and converts the OLM files to PST format without any data loss. The tool is 100% secure and prevents the data loss while converting OLM files to PST format.

    With this, a user can convert all the OLM file data including email, tasks, calendar, notes, contacts, and another customized folder of the same format are also converted precisely without damaging any data.
    For more info:- https://bit.ly/OLMtoPSTtool

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Product Marketing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Datasheet enhancements

    Please increase the size of the footer of the data sheet to make it easier to see and use the record controls. The number of records box should be much bigger to see large record numbers. Also, the search box should be at the top of the datasheet to make it more intuitive to use and be inline with the emphasis Microsoft now gives search in all its applications. I would like to see wrappable columns heading. And the filter button, the add button and a delete and refresh button at the upper right hand part of the datasheet so…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  18. Include Find/Replace dialogue when using Shift F2 to edit code

    I use code for the recordset property of a form and if I need to make changes I cut and paste to notepad but now we have "find & replace" in the SQL Editor. Can this functionality be incuded if editing the recordsource property or perhaps open the sql editor to make this easier.

    Thanks for the great work on the Editor it really helps!

    1 vote
    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 →
  19. BUG - Relationship window: Cannot view all tables

    Office 365, 16.0.12730.20144 32-bit.

    Select many tables at once in Relationship window - enough so that the list of tables spills over to a second set of columns. Scroll down to bottom of scroll bar, and cannot see the tables lower down. If I then resize the Access Window so it is shorter, I can scroll down and see more tables. And then if I make the Window taller again, I can see the bottom tables. But as soon as I touch the vertical scrollbar, focus shifts to the top again, and the bottom tables are again not showing.

    Note…

    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. Use F5 to run a query

    When switching between SQL Management Studio and an Access front end I find myself pressing F5 to run the Access query as I've been working in the other window - would be good if F5 ran the query in Access as it does in SQLMS

    11 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 →
← Previous 1 3 4 5 54 55
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base