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. Release an Office 2019 Access Runtime

    The Access Team previously stated that "Access is included in all Office 365 plans and Access 2016 Runtime click-to-run is also available for customers".
    This leaves a gap for anyone that has installed a lower version of Office 2019 that does not include Access. The Access 2016 runtime will not install as it is MSI, the Office 365 access runtime will not install as it clashes with Office 2019, which it insists you uninstall.
    We are having to tell our customers to not install Office 2019.
    So please can we have a runtime that plays nicely with Office 2019

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

    The current plan is to make Access RT 2019 available for customers to install from the Office Deployment Tool. This should be available in the second half of 2019.
    The recommendation for Office 2019 perpetual consumers, is (and will remain) to install the free version of O365 Access Runtime from the download page.

  2. Cambiar la altura de la fila de encabezado en un hoja de datos

    La idea es poder manipular la altura de la fila de encabezado de una hoja de datos para poder darle un alto suficiente capaz de mostrar todo el título de la columna, pero sin cambiar su anchura.

    19 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. Display Form Caption when Minimized

    In previous releases of Microsoft Access, a minimized form would display at least a few characters of the form caption before showing the restore, max, close buttons.

    Sample:
    https://1drv.ms/u/s!AhezOlimTLoah_40R2mSOThcj5cFiQ?e=BlON97

    In current builds of Access, the restore, max, close buttons consume all of the width of the minimized window, leaving no room for even a portion of the form caption to be displayed.

    Sample:
    https://1drv.ms/u/s!AhezOlimTLoah_41HY08IxXU44DUrw?e=rpFGd1

    If multiple forms are minimized, the user is no longer able to make an informed choice about which minimized Window to restore.

    Suggestion:
    Please make the width of minimized forms wider so that the caption (which…

    7 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 →
  4. State of the Art Replacement for Active X MS Calendar

    Everything revolves around time and Microsoft Active X Calendar is(was?) the perfect tool to use in a lot of applications we've prepared over the years. This gem works seamlessly even in continuous forms while current datepickers associated with textboxes won't do and subforms won't do and equally seamlessly integrates with VBA code and queries and control sources SQL. It doesn't work in Access 64 bit so it's about time to come up with a state-of-the-art replacement but even simply enabling it for 64 bit would suffice.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. Bug fix requested: ControlTip text does not always show when On Mouse Move event used

    In Access 2016 the ControlTip Text may not show on a control that uses the On Mouse Move event. To see the desired ControlTip it is necessary to reveal the ControlTip of another control first, then bring the mouse back to the desired control that has the On Mouse Move event.

    A better description of the issue, with screenshots, may be found here: https://answers.microsoft.com/en-us/msoffice/forum/msofficeaccess-msowinother-mso2013release/controltip-text-does-not-always-show-when-on-mouse/209f54d1-edfd-4252-9f20-f24029c12d8a?messageId=c1448154-918b-420e-9e2c-5d887734a505

    Suggestion/issue posted here by request.

    4 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. O365 version subform painting bug

    Fix a recent Office 365 version bug where some subforms do not completely paint. Some areas are left blank unless the cursor clicks into the record.

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

    6 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 →
  8. 1 vote
    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 →
  9. Add Pivot Charts and tables back to Access.

    Add Pivot Charts and tables back to Access.
    Pivot Charts and tables are very powerful. there is no other function is able to replace them

    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. Enhance Import Fixed Width Text wizard with ability to indicate that first row contains column headings

    When importing delimited text (e.g. CSV) one can indicate that the first row contains column headings.
    This ability does not exist for fixed width text. It should, to make the feature more useful and consistent.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support LongLong - or BIGINT - natively in Access 365 just like Excel 365.

    BIGINT needs to be turned on in Access 365 and 2016. LongLong (2^64) - 1 is simply another data type available natively in Excel 365. This should be available in 64-bit versions of all Office applications VBA as well as the tables in Access.

    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 →
  12. there are too many choices, narrow it down to 5 basic ideas of total program that will help in a solid venue of knowledge of good success

    have an article to explain one path to set up access so give one idea as to what the final goal will be, and does every data base have access to add and change the overall complexity of the total program like office 365 is so complicated it will take several talented people to run the program.

    1 vote
    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 →
  13. Horizontal Data in For

    We need the ability or a control to represent our data horizontally instead of vertically. Such as the websites they are representing their products horizontally and the customer can scroll. it would be a great thing if we have this ability in ms access.

    10 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. make set_spapprole work in a VBA context

    SQL Server (see https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-setapprole-transact-sql?view=sql-server-2017) has a great security feature to allow an app to assume a security role when connected to the server. This doesn't work from Access VBA. This leaves us having to give permissions to data that users can subvert. Whilst this can be mitigated, if Access could connect using a user account with no permissions, and switch to an app role with the right permissions security would be wonderful. SetAppRole is particular pleasant in that in the context we still know the original user who started the app.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  15. Query is Corrupt bug has crippled five production applications.

    Query is Corrupt bug has crippled five production applications. How are we suppossed to wait nearly a month for a fix. This is insane. How can this be acceptable. Such a serious bug should be addressed immediately.

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

    See support.office.com/en-us/article/access-err..

    For updates, this is fixed for almost all channels now (a fix has been available for most users since 11/18).

  16. Focus and PopUps (The Screen.ActiveForm Nightmare)

    PopUp forms do not get focus, because they are not intended for data.

    I have read that plenty of times and know perfectly that is by design.

    But to use a PopUp form is the only way to go out of MDI boundaries, sometimes it could be practical to open data in a Popup form, and do not know why that should lead to a focus nightmare, in which a lot of events and functions cease to work or change his behaviour.
    It will very nice if we could forget that old assumptions about popups, getting in it the common…

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

    30 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 →
  18. Someone needs to be fired (really)

    The recent Access updates that broke the most simple update queries was bad. However, Microsoft's response was even worse. Rather than Microsoft fixing the very serious problem they created, they said we should change the way we update records in our applications. What moron thought that was an appropriate response? Like many other throughout the world, we have a production system with 400K lines of code and you want us to rewrite every update statement because you do not want to roll out a bug fix? Then, someone thought it was a good idea to wait 30 days to fix…

    5 votes
    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 →
  19. PROBLEM --Linked table manager Access 2019 Allows to refresh only one table and then click OK And so for all the tables

    PROBLEM --Linked table manager Access 2019 Allows to refresh only one table and then click OK And so for all the tables

    Description of actions

    After pressing RELINK

    A window opens where I enter the DSN information

    Clicking OK
    A window opens

    And I had to click more than 100 times After each click

    There is a message Succeeded Next to the table name

    And a new window opens

    And I had to click OK .......

    More than 100 times ....

    Is there a solution to the problem?

    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 →
  20. Access for Mac 64-bit

    Why can you not make ACCESS available on Mac? This is the 21st C not the Dark Ages. I have moved from Windows laptop to a 64-bit Mac and have an annual subscription to Office 365. Why is Access NOT available to me as it was before? I cannot be the only person in the world with this problem. I am not a computer expert, just a fairly competent user. If you can develop Word, Excel, etc etc for Mac why not Access? I really don't understand the problem. My databases are now useless to me, as are those of…

    1 vote
    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 →
← Previous 1 3 4 5 49 50
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base