Search results

  1. A

    How to reference open SQL database

    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...
  2. A

    How to reference open SQL database

    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...
  3. A

    New member intro

    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.
Top Bottom