Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Msg Box saying that a table is open

Discussion in 'Information Technology' started by AccessFitz, Nov 16, 2005.

  1. AccessFitz

    AccessFitz
    Expand Collapse
    Guest

    I've searched the board for this ? and can't seem to find what I'm looking for.

    I have a command button. Within this command button, I have several queries
    that run. What I would like to do, is button a msgbox command within the
    button restricting a user to click on the button if another user is in a
    table. I want a message box to appear saying "Another User is currently is
    another table." I know how to build the message box, but I'm not sure how to
    write the VB code saying that a table is open by another user?

    Does anyone know?

    Thanks
    AccessFitz
     
  2. Loading...


  3. salut

    salut
    Expand Collapse
    Guest

    Why do you need that?
    If another user is changing something in the table, the table will be locked
    for his usage, you would not be able to change it anyway.


    "AccessFitz" wrote:

    > I've searched the board for this ? and can't seem to find what I'm looking for.
    >
    > I have a command button. Within this command button, I have several queries
    > that run. What I would like to do, is button a msgbox command within the
    > button restricting a user to click on the button if another user is in a
    > table. I want a message box to appear saying "Another User is currently is
    > another table." I know how to build the message box, but I'm not sure how to
    > write the VB code saying that a table is open by another user?
    >
    > Does anyone know?
    >
    > Thanks
    > AccessFitz
     
  4. AccessFitz

    AccessFitz
    Expand Collapse
    Guest

    Salut,

    When you have a make table in your command button. An Error will populate
    saying
    the table is already opened by an exclusive user. I want a build some code
    into the button to know if someone is currently in that table. If the table
    is opened.

    "salut" wrote:

    > Why do you need that?
    > If another user is changing something in the table, the table will be locked
    > for his usage, you would not be able to change it anyway.
    >
    >
    > "AccessFitz" wrote:
    >
    > > I've searched the board for this ? and can't seem to find what I'm looking for.
    > >
    > > I have a command button. Within this command button, I have several queries
    > > that run. What I would like to do, is button a msgbox command within the
    > > button restricting a user to click on the button if another user is in a
    > > table. I want a message box to appear saying "Another User is currently is
    > > another table." I know how to build the message box, but I'm not sure how to
    > > write the VB code saying that a table is open by another user?
    > >
    > > Does anyone know?
    > >
    > > Thanks
    > > AccessFitz
     

Share This Page