Query with Access index table

[Steve_in_Kent]

If i have a copy of a database that i work on, at a given point in time..

the users are using a different copy, and creating records... i then take those records and paste them into the tables of my amended database.

will the database create records at the right place? - ie: the index will be correct? or, will it try to create records over the top of what i have pasted in?

[HansV]

If you paste into the new record, Access will not overwrite existing records, but add the pasted records as new records.

If the primary key of the table is an AutoNumber field, Access will automatically assign new AutoNumber values for the pasted records, so there won't be a conflict. But if you need to paste related records into several tables, you might have a problem because the AutoNumber values may change.

If the primary key of the table is a manually entered value, and if you try to paste records with an existing key, you'll get an error message and the paste will fail.

[Steve_in_Kent]

Thanks hans..

I've done everything i thought, but, i've still managed to screw the tables up.. all sorts of issues with running something written in 2003, using office 2010.

[HansV]

Can you provide more detailed information?

[Steve_in_Kent]

Well sort of :)

One issue that i have, is that there is a form, and it uses drops downs from the 'Add ins' tab, to set

FILTER ON
APPLY FILTER

i'm trying to find the vba equivalent, to put a couple of buttons on the form to do the same.
the filter, is stored in the forms 'filter' property. and i think the drop down add in's just enable it.

[HansV]

The VBA equivalent for a command button named cmdFilter would be

Code: Select all

Private Sub cmdFilter_Click()
    Me.FilterOn = True
End Sub