Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MarkWaddington

    Blank Error Message

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

    Multiple users - help please!

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

    Suppressing a certain error message

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

    Suppressing a certain error message

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

    Suppressing a certain error message

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

    Blank Error Message

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

    Blank Error Message

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

    input mask regarding capital letters

    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?
  9. MarkWaddington

    Multiple users - help please!

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

    Multiple users - help please!

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

    Record locking - i'm REALLY confused!

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

    Record locking - i'm REALLY confused!

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

    Read only problem

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

    Read only problem

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

    Form Dialog Based on Query - Msg if No Match

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

    Form Dialog Based on Query - Msg if No Match

    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".
  17. MarkWaddington

    Form Dialog Based on Query - Msg if No Match

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

    Opening a form within a form

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

    how to display a text field as point form in report.

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

    Class Object disappeared! Please help

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

Part and Inventory Search

Back
Top