Search results

For Acc2000 have a look at the following http://support.microsoft.com/default.aspx?scid=kb;en-us;200551

What version of access are you running?

Access 97 is capable of doing what you require, no problem. The zipfile is aleb's database converted to Acc-97, and uses the composite key method as (s)he describes. I have added my sub to the form's 'before update' event to do the checking. I've given it a quick try, seems to work OK, but you...

As far as the number of records is concerned I am working on a db at present with 32,000 records with no probs regarding speed. You should be extra careful in designing your queries, though, consdering possibilities of more than one user accessing data, volume of traffic on the LAN etc.

Personaly I would use VB to do what you require. You can use the BeforeUpdate event for your Vehicle number field : something along the lines of: Private Sub VehicleNumber_BeforeUpdate(cancel As Integer) If (Not IsNull(DLookup("[VehicleNumber]", "Your_Table_Name", "[VehicleNumber] =" & "'" &...

Thanks for replies. I'll try that!

I would like to use the access enter parameter value dialog to return records where the field is NOT equal to the paramter value. So, for example I would like to return all pupils whose name is not "Smith". Is this possible? I've tried entering directly into the dialog, but get an error...