Jan 17 2007, 07:43 AM
Not Sure if this belongs here or in the VBA section, but ill give it a whirl here.
I am changing the data in a tabel to sort them out, well past what a query can do, i am working this through in VBA.
I am opeing the Results in a
'Dim rstTest As New ADODB.Recordset
'Set rstTest = New ADODB.Recordset
'rstTest .Open "SELECT tblTest.Test1, rstTest.Test2....... etc
I am going to Edit and sort these into lists of what i want, but i was wondering if it is possible to Open a Table and write the details into it.
And way to say Simply tblNew = rstTest
Without a hefty loop?
Jan 17 2007, 08:09 AM
There's no way to get around opening a recordset.
When you've opened the recordset, basing it on a table, and then edit the data in the recordset, the data in the table is automatically updated.
It's not clear to me what you're hoping to save.
Jan 17 2007, 08:30 AM
Alright well ill find and alternitive thanks for your help...
One last questio, Is there any possible way to just say Table.clear?
Instead of Running a loop through the whole tabel deleting each record?
Jan 17 2007, 08:46 AM
CurrentDb.Execute "Delete * From Table-Name" will do what you want.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here