Feedback by UserVoice

Brian Pearson

← Welcome to Access Suggestion Box!

My feedback

  1. I would like to be able to change the name of the data base, but it doesn't appear that I can do that.

    1 vote
    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 →
    Brian Pearson commented  · 

    The database is just a file, and you can change its name using File Explorer. You'll need to ensure that no user has the database open in Access when you do this.

  2. Where are you

    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…)
    0 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  3. Allow the use of tables in update queries without requiring them to be writeable

    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…)
    0 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  4. enable a custom sort order in reports/queries

    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…)
    1 comment  ·  Access (Desktop Application) » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson commented  · 

    Access can certainly handle problems like this.

    Put your 'Progress types' into a separate table (it's not clear but maybe you've already done this). In that table, you'll have at least an ID (ie autonumber) field,.a description field (eg 'Not started') and a Sort order field ('2' in this case).

    In the base table, you'll associate each record with the ID field of the Progress types table. In the report, you'll sort using the [Sort order] field of that table. You can actually use multiple sort fields if you want to. Go to the 'Sorting and grouping' settings of the report to do this.

  5. improve performance of conditional formating

    12 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) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  6. Please provide a tool to create self adjusting boxes in a Report. E.g: Invoice and Quotation type of reports

    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…)
    2 comments  ·  Access (Desktop Application) » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson commented  · 

    Surely a textbox's CanGrow property provides this functionality?

  7. vertical text orientation

    13 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…)
    0 comments  ·  Access (Desktop Application) » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  8. Expose method to get row under cursor

    9 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…)
    0 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  9. Allow easy way to highlight the current selected row on continuous forms.

    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…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  10. Designing Reports - make it easier to draw a horizontal line

    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…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson commented  · 

    After you've drawn the line, if it's not horizontal, just set its Height to zero in the Properties box.

    Bingo; horizontal line.

  11. Include original table in as well as alias in designer view of a query

    11 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 →
    Brian Pearson supported this idea  · 

  12. Query designer: improve column properties

    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…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson supported this idea  · 

  13. Include a tag property on all objects such as tables, fields and queries.

    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…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson commented  · 

    Lightwave

    I have to say that I think the tag property is something different from your suggestion. Tagging would allow any kind of alphanumeric string to be set for these objects, not just a unique numerical key. Also you can change the tag whenever you want.

    Brian Pearson supported this idea  · 

  14. Allow ShowDatePicker to be turned off globally

    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…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Pearson shared this idea  · 

  15. Provide a facility in Access to control and error trap the SQL server login dialog.

    6 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 →
    Brian Pearson supported this idea  · 

Feedback and Knowledge Base

(thinking…)