Search results for query: *

Found the problem Using DateValue() was causing it. Don't aske me why it was there - I inherited the system and have taken the rule not to mess with the code unless I prove it breaks something. What is weird is that DateValue(format(DateField, "mm/dd/yyyy")) returns dd/mm/yyyy - not...

Jim In the after update event in the postcode, set the adress fields using a dLookup back into the same fields in the same table, based on the postcodes being equal. If it finds one existing record with the same postcode it should fill the address fields. You will have to check the street...

I have an Access 97 front end over SQL Server 7 back end. A process adds records to a table, using infomation from a process form and a related items file, using an entered date in the process form as the date to write to all records. It always worked fine up to the end of last year, but now...

A Replicated Access database is reporting synchronisation conflicts that do't appear to exist. The Conflict resolution box appears showning NO tables, but if you click details, it lists two records detailing primary key conflicts in "Site Table". Investigation of the table shows no...

A Replicated Access database is reporting synchronisation conflicts that do't appear to exist. The Conflict resolution box appears showning NO tables, but if you click details, it lists two records detailing primary key conflicts in "Site Table". Investigation of the table shows no...