Search results for query: *

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

Sorry, I meant in the VB code for the "on no data" event.. i.e. click the 3 dots that appear next to that field and click "code".

Easy. Go to the design view of the report, then go to your properties and in the "On No Data" event handler add the following: MsgBox "There is no data for this report." Cancel = -1 Hope this helps. Mark Waddington.

Hi, I have a main form on my database, and in turn I click on a command button and it opens another form with the same Autonumber primary key as the first form. Here's the code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Dim stDocName As String Dim stLinkCriteria...

The page header of your report should have labels which identify the field it refers to. In the details section put the individual text boxes and then base the report on your query (where it eliminates records that are null). Then when you open your report you should have a list of all your...

I have sent you my database - it was made using Access 2000. Thanks a lot for helping me out. Regards, Mark Waddington.