okay...that makes sense.
one more question.
when i use Docmd.openquery "qryName"
how do prevent the query from showing the result? i just want the query to execute and not show a preview of the results.
i will work on this...thanks!
if i go this route, how do i specify in the criterial that i just want the current record on the form...that is, i just want to insert into the new table from the old table the current record?
thank you.
i was attempting to use VBA behind a command button as follows:
SQL = "Insert Into newtable (column1, column2,...) Select * From originaltable"
DoCmd.RunSQL SQL
the problem is specifying all of the columns in destination table. it seems that the following syntax is not...
you are absolutely correct. the design is horrible. i did not design it, but at some point i will be moving the data to SQL Server so i will have some opportunity to normalize it.
at this point i have to deal with all of those columns. fortunately the records on the form i am dealing with...
is there an easy way to copy the current record on a form when clicking a command button such that a snapshot of that record is copied to a table for archiving purposes?
the table has about 120 columns so it is cumbersome to write an Insert Into sql statement within VBA code.
what i am...