Recent content by mpetersen

Hello, I get the following error when any user attempts to make any change to a particular form in my db. Run-time error '-2147352567 (800200009)': Update or CancelUpdate without AddNew or Edit. The code throwing the error is: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Date_edited...

Hello, I am working with an adp and have an issue with &'s in one of the fields. I would like to do a global find and replace for ampersands in just this one field within one table to replace the &'s with "and." How do I go about doing this? Thanks

we are in Access 2000 but our mysql database is offsite so maybe that is why the tables/queries don't save to the zip...

I should add that we are working with the image_metadata table.

Perhaps it is too late to seek help for this one but here is a copy of our db which is creating the null record issue. If anyone cares to take a look I'd appreciate any insight. Thanks, mlp

so I should look at this as an opportunity! Very sly. ;)

I should mention I inherited this very antiquated system just last month and NOBODY has any documentation on it. I'm just trying to piece it together.

Thanks for the help, I guess I was feeling discouraged... Situation three describes us. Our power just went out so I can't get to the actual database to get copy the database. Hopefully things will be up and running soon!

thanks, that worked. I stripped out the addressee info that preceded it and worked from there. all set now! Thanks!

i was afraid of that.... thanks though!

We have an issue with our database creating records which have no values. On occasion, when more than one person is working in the database the system generates a null record despite the fact that we have the primary key set to not allow nulls. That is each field is null. Is there an obvious...

I'm working on editing a private subroutine and have run into some trouble. What I would like to do is edit the auto populated date which is written into a .dot file. I thought I had found the location in the code where I needed to edit this but when I make the change I don't get a new result...