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!

  • Congratulations gkittelson 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. Nidhal

    [B]There was an error executing the command.[/B]

    Are you checking the properties of the actual forms to see if they are set to lock the table when it opens. This would be on the data tab of the form I believe. I checked each form and they are set not to lock under the data tab of the form properties. I'll let you know when I have created a...
  2. Nidhal

    [B]There was an error executing the command.[/B]

    I went to TOOLS > OPTIONS > ADVANCED TAB under the default record locking options I tried selecting each option (No lock, All records, edited record) with Open databases using record-level locking checked and when running the database with users in it I still get the same error. I've seen...
  3. Nidhal

    [B]There was an error executing the command.[/B]

    I now receive this error msg after commenting On Error GoTo HandleButtonClick_Err No debug button just an OK button. Looks like we are getting somewhere =) The expression On Click you entered as the event property setting produced the following error. Could not lock table 'Contacts'...
  4. Nidhal

    [B]There was an error executing the command.[/B]

    Private Function HandleButtonClick(intBtn As Integer) ' This function is called when a button is clicked. ' intBtn indicates which button was clicked. ' Constants for the commands that can be executed. Const conCmdGotoSwitchboard = 1 Const conCmdOpenFormAdd = 2 Const...
  5. Nidhal

    [B]There was an error executing the command.[/B]

    The dialog box only pops up when you try to navigate through the switchboard to other forms while another user is using a form to enter data. The dialog does not have a debug button. The dialog shows the error msg that has an OK button. After the message is acknowledged it returns to the...
  6. Nidhal

    [B]There was an error executing the command.[/B]

    If anyone can help me it would be most appreciated. I've had the this error for a month now and have tried just about everything...
  7. Nidhal

    [B]There was an error executing the command.[/B]

    Not using recordsource property. I removed the form from loading at start up by going to Tools > Startup > Display Form/Page and tested the DB. Still the same error. I am merely using the code to display the switchboard form. It is generated code. I did not modify it.
  8. Nidhal

    [B]There was an error executing the command.[/B]

    That's all I have. Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' " Me.FilterOn = True End Sub
  9. Nidhal

    [B]There was an error executing the command.[/B]

    Yes, the permision to access the network folder is set to Everyone with full read-write access.
  10. Nidhal

    [B]There was an error executing the command.[/B]

    Is this where I should post this question? I have a database that is being used by multiple users. Each user has an MDE file on their PC and the data is stored/referenced in a separate mdb on a network shared drive. When someone is using the program concurrently and a second user tries to open...
  11. Nidhal

    "There was an error executing the command."

    I have a database that is being used by multiple users. Each user has an MDE file on their PC and the data is stored/referenced in a separate mdb on a network shared drive. When someone is using the program concurrently and a second user tries to open forms, etc. I always receive the following...

Part and Inventory Search

Back
Top