Feedback by UserVoice

Patrick Honorez

← Welcome to Access Suggestion Box!

My feedback

  1. Create a table / linked table with a size greater than 255 fields

    30 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 →
    Patrick Honorez commented  · 

    Not an issue! Just use a passthru query to overcome this.

  2. Fix bug: Date Picker Not Available if Unbound Textbox has Input Mask

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

    Don't use input masks for dates. That prevent intelligent users to type quick dates.

  3. Provide ability to Save/Load query definition to/from .SQL text file

    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…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    @Klaus: not retested, but as far as I remember the Application.saveAsText way saves an unreadable version version (or *nearly* unreadable). That is not satisfying for me.

    Patrick Honorez shared this idea  · 

  4. Allow JET/Ace SQL To support Multiple SQL Statements and comments.

    45 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…)
    13 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    I wouldn't mind NOT to be able to switch back to design view once I manually edited my SQL, if that is the price to pay to keep my readable SQL...readable.

    Patrick Honorez supported this idea  · 

  5. Generate barcodes

    95 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…)
    14 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Need more info  ·  AdminAccess Team (Product Manager, Microsoft) responded

    Hi Piotr, and barcode supporters,

    It would be good to hear more about what you’d expect from a native barcode control -
    what formats are mostly used? what are other requirements for barcode support?

    Thanks,
    Michal [MSFT]

    Patrick Honorez commented  · 

    You can find TONS of free Code 128 fonts on the internet.

    Patrick Honorez commented  · 

    There is no issue at all generating barcode with pure VBA. And you can read barcode using a text box and very few events. I programmed an ERP and the client scanned *millions* of IMEI codes using Access standard controls and pure VBA.
    I published a EAN/IMEI/many other barcode check function here: http://idevlop.blogspot.lu/2013/07/check-digit-et-validation-de-code-ean.html

  6. Fix query engine issue.

    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) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    [Year] is a reserved word.
    And this is a place to submit ideas.
    To debug your messy code I suggest you go to stackoverflow.com

  7. Make SQL and QBE Smarter

    31 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 →
    Patrick Honorez supported this idea  · 

  8. Add a new operator to Group By queries

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

  9. Ability to link refresh linked table to a server (SQL Server or Oracle) I have no access to

    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)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    Today we have to deploy an app that includes a looong "relink" procedure that the clients must endure at every new deployment. Adding a "NoCheck" option to tableDef.Refresh would allow relinking BEFORE deployment, and also FASTER relink.

    Patrick Honorez supported this idea  · 
    Patrick Honorez shared this idea  · 

  10. Attach SQL tables without "dbo_" or give the option to do so

    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) » External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    You can rename your tables after they are attached. And with 10 lines of VBA one can automate this easily.

  11. Table column count to the same than in SQL Server

    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)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez commented  · 

    @Juha: I think you can you can easily work around this issue by creating a passthru query "select * from myTable"

  12. Enable Ctrl-Spacebar to Popup Intellisense in Queries

    10 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 →
    Patrick Honorez commented  · 

    And I would LOVE if the generated SQL statements could be readable: less unnecessary parenthesis, every JOIN starting on a new line.

    Patrick Honorez commented  · 

    indeed, a decent editor for queries in SQL view should be warmly welcomed.

  13. Improve design speed on databases with lots of tables attached

    5 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 →
    Patrick Honorez shared this idea  · 

Feedback and Knowledge Base

(thinking…)