Not an issue! Just use a passthru query to overcome this.
Don't use input masks for dates. That prevent intelligent users to type quick dates.
@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.
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.
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?
You can find TONS of free Code 128 fonts on the internet.
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
[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
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.
11 votes1 comment · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
You can rename your tables after they are attached. And with 10 lines of VBA one can automate this easily.
@Juha: I think you can you can easily work around this issue by creating a passthru query "select * from myTable"
And I would LOVE if the generated SQL statements could be readable: less unnecessary parenthesis, every JOIN starting on a new line.
indeed, a decent editor for queries in SQL view should be warmly welcomed.