Search results
-
E
How to execute SQL in automation
I'm opening a second database (db2). Copying the structure of a db2 table to db3. Populating the table in db3 with a subset of records from db2. I've gotten as far as opening the db2 and copying the table structure. Can't figure out how to run the query using execute rather than...- elwi
- Thread
- Replies: 4
- Forum: Modules & VBA
-
E
OenCurrentDatabase question
Access 2013 I have a database open and a form with a button to accomplish the following: 1. open another database instance 2. import Excel files into db2 3. close the other database instance I'm using the following code: Dim appAccess As Access.Application Set appAccess = New...- elwi
- Thread
- Replies: 5
- Forum: Modules & VBA
-
E
Object invalid or no long set
Access 2013 Code that has been working is suddenly causing the error "Object invalid or no longer set". Line causing the error is marked. Anyone run into this before? I've spent half the day on this getting nowhere fast. Private Sub CreateTable() Dim dbsDb As dao.Database Dim...- elwi
- Thread
- Replies: 9
- Forum: Modules & VBA