Feedback by UserVoice

Alan Cossey

← Welcome to Access Suggestion Box!

My feedback

  1. Drag Tabs to Rearrange

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    Planned  ·  6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    Dragging tabs is fine though.

    Alan Cossey commented  · 

    I need to take back that previous comment. The way the active tab is coloured is poor and very counter-intuitive. That active tab gets coloured while any non-active tab remains the same colour as the active form and there is no border between the active form and a non-active tab. Very confusing, particularly if you have just two forms open. What is actually the active tab, since it may well be darker than the active form, looks like it is greyed out, i.e. not active.

    Hopefully it should be easy to correct this. If it isn't, please provide a way to turn it off.

    Alan Cossey commented  · 

    Done and looking good. See https://support.office.com/en-us/article/what-s-new-in-access-for-office-365-76454345-f85d-47af-ace1-98a456cb3496#audience=office_insiders

  2. improve performance of conditional formating

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey supported this idea  · 

  3. Enable Access (and all VBA apps) to work with the new Microsoft Graph

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application) » Cloud  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    "Link to and import from" would be read-only?

    Alan Cossey shared this idea  · 

  4. Expand the maximum Form width

    96 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    10 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey supported this idea  · 

  5. Give us a new dll - MSJSON.dll

    119 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey supported this idea  · 

  6. Subform in continous form

    143 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    8 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    Remember you can also have subdatasheets to your datasheets as well. You can't have headers and stuff to the datasheet, but you could put the datasheet on a top-level form so you have the datasheet as your subform and then the subdatasheet runs off that.

  7. Enable Access to work with Azure Multi-Factor Authentication

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    So, if an IT department switches on MFA, how do I continue to use Access to connect to the Azure SQL database, please? Have I missed something obvious?

    Alan Cossey shared this idea  · 

  8. Fix Windows 10 1803 Frontend - Backend corruption issues

    136 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    How are you getting on 4 months into this, please?

  9. Make the 'Compact and Repair Database' function automatic on saves

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    And it doesn't always work well. Sometimes something goes wrong and no-one notices until they notice loads of files in the same folder as the original Access database named Database1.accdb, Database2.accdb, Database3.accdb or something similar.

  10. Refresh table on right click

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    BUG: Using the (new) "Refresh Link" option when right-clicking a linked view (from MySQL), it removes any primary key you have set up. I'm on build 11029.20079.

  11. Linked tables do not display password in MySysObjects

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    I would suggest you don't save the password. It is better to run a connection to the back end when you start up your app, e.g. by using OpenDatabase (with an Access back end) or a SQL pass through query (if an ODBC back end). This creates a cache which is then automatically used by linked tables so they will then connect.

  12. Create PDF-File with merge function

    23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    Bullzip is good for this for doing it programmatically.

  13. Add New Controls through Code

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    Is there a situation where just unhiding existing controls is not as useful?

  14. replace status bar with a true progress bar

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    PS Such "roll your own" progress bars are likely to be more flexible and adaptable than anything Microsoft might put into a built-in one.

    Alan Cossey commented  · 

    There are a number of ways to create a progress bar. Searching on "access progress bar" gives access to some of them.

  15. Responsive forms

    112 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    As in over and above the use of the Anchor property?

  16. give the developers the ability to disable the "Tell me what you ..." textbox

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    I would vote for this, but have no votes left.

    Alan Cossey commented  · 

    I agree. Access is different to the other Office programs. When I create a database with no access to the design stuff, e.g. Navigation Pane, design view for forms and reports, etc., I don't want "tell me what you want to do" stuck on my ribbon. It has no relevance to my database. It might as well have an advert for Siberian hamsters there.

    Clippy 2 or what?

  17. commandbar

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    Sorry, there are 6 CommandBars in Access 2016 with no Name other than " ".

    Alan Cossey shared this idea  · 

  18. Allow Wrap Text (like in Excel) for the headings in Datasheet view

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey supported this idea  · 

  19. bring it into conformance with high DPI design standards

    52 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    Planned  ·  5 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    As well as the problem with the borders of windows, Access has other problems with high resolution screens.
    When text size is set in Windows (10?) to more than 100%, the following happen:
    1) The Navigation Pane updates slowly and jerkily when scrolling down it (even on my super whizzy PC).
    2) The horizontal scrollbar at the bottom of a form obliterates the right half of the Search box next to it when the size of the Access window is reduced to a size which causes the horizontal scroll bar to appear.

    Please note that if you want to check this out by altering your Windows text size, you will need to log off and log in again to see the change.

    Alan Cossey commented  · 

    I've already used up my votes, so I can't vote for this as well. I have just bought a high resolution screen and the Navigation Pane text is now tiny with large vertical gaps between each line. It's a mess.

  20. Buy out EverythingAccess.com's vbWatchdog add-in and incorporate it into VBA

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    12 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Alan Cossey commented  · 

    wilo,
    That's all part of vbWatchdog and, no, I have no connection with them apart from using their product(s).

    Alan Cossey shared this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)