Search results

I have created an archiving process that removes specific records from a database and puts them into a new database. All is working nicely, but the source backend needs to be compacted at the end of the process. I know I can do it easily manually, but I wanted to make it as automatic as...

I have a database with a procedure that creates a new database and sends information from the source database to the new one. Everything is working fine, except I need to perform an process on both the source and destination database (a renumbering process). Since I have two databases to...

I am getting the following error: "The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing [dbName] from saving the data in the field." I am trying to increment the value of a field on a form when a new record is created. I know having an...

This is making me crazy. I have an if...then statement that is not working. I have field on my form called EndDate. If no date is in the field then I need to pop a msgbox reminding the user to enter a date. currently it looks like this: If Me![EndDate] = Null Then Response =...

I am creating an archive method for a database that has grown too large. I have queries that generate the data I need to archive, and I have created code that creates a new database that I want to export the archive data to. I then use DoCmd.TransferDatabase to send the results of the queries...

We have a database we converted to 2007 from 2003. The main form contains two subforms. One subform is working fine, the other not so much. When the database is filtered, the second subform appears to lose the master child link. Existing data in the subform does not appear, and we cannot...

I am working with a main form and a subform that is set to continuous. The underlying table for the subform contains an integer field that is populated when a record is created and is used to sort the records in the subform. So the first record will have a 1 in the field, the next one a 2, and...