Feedback by UserVoice

Patrick Honorez

My feedback

  1. 30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Patrick Honorez commented  · 

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

  2. 8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Patrick Honorez commented  · 

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

  3. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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. 46 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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. 101 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    15 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]

    An error occurred while saving the comment
    Patrick Honorez commented  · 

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

    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Access (Desktop Application) » Queries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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. 32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    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

    We're glad you're here

    Please sign in to leave feedback

    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    Patrick Honorez commented  · 

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

  13. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    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