Thanks very much for your help. I think I was previously using CurrentDB incorrectly and gave up on it too soon. Because with your encouragement to try it again and fixing the query string, I now have it working:
Set dbs = CurrentDb
QueryStr = " INSERT INTO dbo_Suppliers ([Part...
I think I have a problem that must have a simple solution but I can't find any online examples to help me.
Scenario:
I am using Access as the front end to an Azure SQL database. The tables are therefore an External Data Source connected via ODBC. I have a form which has an On Dbl Click Event...
Hi. I'm Andy from Cambridge. I'm a long-time hacker of VBA for Excel and Access which I use for various business analysis purposes. It's good to find this forum to help solve my (usually simple) confusions.