This can be done in two steps. First you'd append the relevant records to your archive table and second, delete the appended records from your main table.
A few questions though- how many records are we talking about in each group- both the archive table and the main table?
Also, what criteria...
I've had this issue before. In the Code window, select Tools then References. Select the DAO/ADO reference and then note the path/file name that appears on the bottom part of the menu. Go to the computer that works, retrieve the same file from it and copy it to the computer that isn't working...
Sorry. The code wasn't as long as I thought. And I used a Do...until Loop not a For...Next. I just tested it so you should be fine. Let me know if you have any issues.
Dim dbs As Database
Set dbs = CurrentDb
Dim nwtbls As Recordset
Dim ctr As Double
Dim strInput As String
Dim start As Double...
Do you not have access to the table... why don't you update it directly? In any case, you will need to use VB to do this kind of updating for sure.
I had to build a module last month that does pretty much what you need, but its quite lengthy. If you care to send me send me your email address I...
The problem is not that you're sending the data to a specific file, rather it's with the name of the Access object you're trying to export. Right now the code will export an object in your database called "sheet1", which probably contains all your data. Create a query that contains the...
All you need to do is change the query name while keeping the same file name. A second worksheet will automatically be created in the same workbook.
hth,
Hilbert
Jenny,
You can use the form object
Take a look at this example:
Dim test As Form
Set test = Forms!Forms![frmMain]![frmRecID]![frmRecTransEntry]
test.Requery
Hilbert
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.