Recent content by MarkWaddington

Yeah I realised that after I had posted the message! Doh! Thanks for replying :)

Jeremy, how would I determine when the last user has logged out of the database? I use Access' in-built security. Thanks, Mark Waddington.

Thanks for the replies. I already had the Exit Sub, what it was was that the switchboard item ran a macro, the macro was: open form, go to new record. But because the user was read only they couldn't go to a new record. So a generic error occurred. It's working ok now. Cheers.

I used the following error trapping method: On Error Goto ErrorHandler //CODE HERE ErrorHandler MsgBox Err.Number The error number came back as "0". I find it unsettling you have never had it before! I'm sure there must be an easier way than having to systematically delete...

Is there any way I can suppress the following error when opening forms? "There was an error executing this command." Its error number is "0" and it only happens when a read-only user is logged in and tries to access a form he/she shouldn't be accessing. Any clues as to how...

Have figured it out now - my error handling code was all wrong..

Hi, something has gone wrong with my main form in my database. When I open the form I get a blank error message, if I try to catch the error number, it tells me the error number is "0". I can't see anything wrong with my code, the only way i can stop the message box from appearing is...

There must be a better way than this!? Can't you just examine the first letter of a string and if it isn't a capital convert it to the capital equivalent?

Hey thanks guys. You've given me hope that this is possible! Both methods sound like they would improve things for me, but I don't really understand Dan's method, as errors don't occur when two people open the same record, it's only when they close it! I think i'm going to have a go at a...

Is there any easy way I can prevent users from accessing a record on a form if somebody else already has it open? I.e. a message box popping up saying "Another user is looking at this record right now, come back later."? I have implemented record level locking but it doesn't really do...

Hi, It's done on the backend. I found that if I make a new record, then close it and open it again, that does lock the record, but only if you start making changes to the data. I would like it so a second user would never see a record that is open by another user. Do you know if this is...

Hi, I have a multiuser database set-up using Access 2K. I have split the database so the data resides on a network drive, and the application is on each user's computer. I have tried to implement record-level locking but I cannot get it to work. The main form in my database which will be...

The user is presented with errors because when the form opens it automatically goes to a new record. Read only users cannot do this. I want some kind of statement that does this: If (ReadOnly) Then DoCmd.Close Can anyone help? Thanks

I have a switchboard item called "enter new client" which when clicked, goes to a new client record. When a user logs in who is read only he/she is bombarded with error messages if he/she clicks that switchboard item. Is there any way to suppress these errors? Thanks in advance.

There's probably a better way round this, but what I would do in this situation is find out the error number (by changing MsgBox Err.Description to MsgBox Err.Number - then running the report again). Once you have the error number add a bit of code in the Err_Command34_Click section something...