Recent content by sysgeo

code I think this code only works with full blown outlook

Email from access directly have a button next to an email field with the following code: Private Sub EmailButton_Click() On Error GoTo Err_EmailButton If IsNull(Me.EmailAddress) Then MsgBox "Please enter a valid email address", , "Email Out" Else DoCmd.SendObject , , , (Me.EmailAddress) End...

yes the database is split but the error [described above] happened on the front end part.

just as follow up - rebuilt the form - problem sorted

cheers fella - luckly its not a major form

solved i hope I have shown our database to a delevoper i know. She says the way to fix it is to rebuild the problematic form from scrach. Hopefully this will solve the locking error we keep on expereniceing. And will help anyone in a similar situation. Regards Steve

jumped the gun I removed the command but the error is still there. It seems to lock people out after you've created the subrecords, then go back to the main record to amend / add some data in. We also seem to get a screen about exclusize access to the database when one or more users are using...

just noticed I have just noticed on the subform i have a macro on the 'on exit' to refresh the form is this macro putting the form in a locked state so therefore the database is locked to all other users in a state? Please help

Prices When you're paying the bloated license fee for office 2003, you expect them to at least make sure the bugs in the previous version are fixed before new ones are found . . . I'll take your advice and give it a go!!! Cheers Steve o

2003 But we're using Access 2002 and 2003, surely this bug was fixed in the later versions?

On our database we have a subform in the main form. We are getting the error '"The database has been placed in a state by user..." when this form is opened on two or computers. the database is network shared mode, 2002 format and we are using access 2003. Reading this support page on...

I have a subform related to the main form via an autonumber on the main form. When ever someone enters data in the subform the relationship is set to use this number as the relationship. I want it so that when ever a new record is created, the autonumber is 'ticked' over to the next number so...

Rich, thanks for your comments. Do you know if there is some thing like - form printing allowed yes/no command?

yes - but yeah this idea works but I only want to disable printing [the print function/button] not the whole tooolbar Any one know? can this be done?

yeah I have done this as I explained above. I want diable printing of the form e.g disable the print button on the toolbar.