Patrick Honorez
My feedback
-
30 votes
An error occurred while saving the comment -
8 votes
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.
-
11 votes
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 ·
-
46 votes
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 ·
-
100 votes
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 -
2 votes
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 -
32 votes
Patrick Honorez supported this idea ·
-
9 votes
Patrick Honorez supported this idea ·
-
3 votes
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 ·
-
11 votes1 comment · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
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.
-
8 votes
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"
-
10 votes
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.
-
5 votes
Patrick Honorez shared this idea ·
Not an issue! Just use a passthru query to overcome this.