Feedback by UserVoice

Patrick Honorez

My feedback

  1. 30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 95 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    14 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →

    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. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez supported this idea  · 
  8. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez supported this idea  · 
  9. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Patrick Honorez commented  · 

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

  11. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    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. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Honorez shared this idea  · 

Feedback and Knowledge Base