mleezon
Last Activity: Apr 9 '12, 12:53 PM
Joined: Apr 4 '12
Location:
-
How about the possibility that before an import procedure that appeneds data into the table in question I would like to make a backup of a table? I don't think that making multiple copies of tables for backup purposes would apply to your normalization document. It is simply that, a back up in case I should need it if the import goes wrong. Most likley I would not, but when I do it is there backed up. -
Here is corrected code that works:
Thanks...Code:strFilename = "'T:\folder\TblBackups.mdb'" strTableName = "[TBLCommissionTransactions" & Format(Now(), "yyyymmdd-hhmm" & "]") strSQL = "SELECT TBLCommissionTransactions.* INTO " & strTableName & " IN " & _ strFilename & " FROM TBLCommissionTransactions;"
Leave a comment:
-
I must have disturbed the database gods.
As I never discussed or asked a question about or even showed anything regarding the structure of my data tables I do not think that the page you referred me to "Database Normalization and Table Structures" applies. I am simply looking for a way to back up certain tables within a database from VBA. And yes, I am self taught with databases and am always willing to learn when someone is...Leave a comment:
-
I think your reply does not apply to the original question.Leave a comment:
-
VBA Code "Query input must contain at least one table or query"
I want to take all the fields in TBLCommissionTr ansactions in current DB and make a new table in T:\folder\TblBa ckups.mdb and append today’s date and time to the new table name. This is purely for archival purposes.
Sorry, not really well versed in VBA. I have the following code which I modified from search online. When I run it I get the message "Query input must contain at least one table or query" which I am...
No activity results to display
Leave a comment: