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...

Removing the parentheses did the trick (along with the byref). Thanks all for your help.

I tried that, make sense to pass as a reference, but still getting a Type Mismatch error. Is there anything different to be done in the syntax of the call?

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...

That was it, works great now. Thanks.

Re: Macro or Function set to the BeforeUpdate... Thanks, that did the trick.

Macro or Function set to the BeforeUpdate... I am getting the following error: "The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing [db] from saving the data in the field." We have an autonumber in the table the updates as soon as any data is...

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...

Never mind. Brain freeze, obviously. The better way If IsNull(Me.[EndDate]) = True Then works fine. Trying to evaluate a Null value was not the way to go.

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 =...

Bingo, that was it. Good eye on that one. I'm surprised Access didn't catch the syntax error, but I'm glad you saw it. Everything is working just it is supposed to. Thanks for your help!

No, the database is there and I am able to open it. So it does exist.

Thanks for the reply, I hope you can see something I'm missing. Private Sub CreateArchiveDB() Dim dbnew As DAO.Database Dim strfile As String Dim dbPath As String Dim ArcPath As String Dim ArchiveDB As String dbPath = GetBackEndPath() ArcPath = dbPath & "\Archive"...

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...

Okay, finally resolved this. The issue was the subform filter. How it got set I do not know, but it was set to a specific record id. When the main form was filtered the subform filter was activated and didn't match the main form filter, so wouldn't show anything. Lesson: If you filter on the...

No code is used to set the filter. It is done using the built-in filter tool. For example, I right-click on the 'Name' field, select 'text filters', select 'Equals', and enter the name being filtered.

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...