Search results

QueryDefs Hi, Hope it's ok to post on this thread rather than starting a new one.... I was wondering if anyone can help out with a question regarding QueryDef. I've been updating the code in a database developed (not by me) in an older version of Access, so much of the code contains references...

If you have already linked your Main db to tables in another db, then you should regularly use the 'Compact and Repair' facility. This will greatly reduce the size of you Main db. Do this before backing up and you might well fit it onto a floppy... From the 'Tools' menu, choose 'Database...

two ways karolientje, You haven't said how you tried to import. There are two ways to do it, either by code or direct importing. 1.) By code: Using a button in a form for example, you can use the following code: Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, _...

It would certainly be possible to enter dublicate data. To change this, you need to open your table in design view and change the 'index' property for that field to 'Yes' (No Duplicates).

Interesting question Hi, Not sure if this would work, but you could try using a make-table query to store the results of your first search, then use an append query to append the new data for each search. This way, when your user is finished they can view all data from their numerous searches...

Thanks Thanks for the help - It looks like I got it working ok now. Cheers, Errol ;)

Hi, I have a combobox on form (frmSearchRecord) to select a name. I select a name and click the 'search' button which opens a new form (frmMembers) which is filtered to the record(s) with that name. Using the access wizard, one obtains the following code: ---------------- Dim...