vincent
02-08-2008, 11:51 AM
So,
I created a SQL query in access that Insert a row in a table.
In my vba code, I want to run this query and get the primary key for the new row added.
I tried:
DoCmd.OpenQuery "QueryExportOrdersTable"
But I want to know how can I get the key?
Thanks
I created a SQL query in access that Insert a row in a table.
In my vba code, I want to run this query and get the primary key for the new row added.
I tried:
DoCmd.OpenQuery "QueryExportOrdersTable"
But I want to know how can I get the key?
Thanks