Search results for query: *

You can also even query the MSysObjects system table, contains all the names of tables and other objects that currently exist in a database. Hilbertl

Use docmd.TransferSpreadsheet aclink

You'd refer to a control with the following syntax me.controlname.value or me!controlname. H.

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...

Try the DoCmd.SendObject method. hilbertl

You can use the DoCmd.Printout method. It has a numerical parameter for the number of copies of a report/form you'd like to print. hilbertl

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...

Are you trying to populate the invoice field in the table that underlies the query with numbers that increase sequentially?

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

Thank you. H.

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

Turbo, You can also open the file in Word, save it as a text file, and then import it into Access. hilbertl