Welcome to SPN

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

Sign Up Now!

Few final adjustments

Discussion in 'Information Technology' started by Goran, Jul 28, 2006.

  1. Goran

    Goran
    Expand Collapse
    Guest

    Hallo,
    I am trying to make some last adjustments, for convenience and security,
    before deploying a secured FE-BE DB on a network. One of the things I would
    like to do is disabling the design view option in the right click on a form.
    What I would also like to do is to ask Access to show another message when
    there in no network connection, like "Sorry the network connection is not
    available at this time etc...". In both cases, I might add, Access does a
    nice job providing the appropriate information; that one do not have the
    permission to view the design of the form and when there is no connection,
    show the path to the unavailable BE DB. I am using Access 2000. Thanks for
    any help in advance!
    Goran
     
  2. Loading...


  3. Jerry Porter

    Jerry Porter
    Expand Collapse
    Guest

    If you implement the application using the Access Runtime, the standard
    right-click menu will be disabled.

    If the network connection is occurring during your code, you should be
    able to use error handling to intercept the error and display a
    different message. If it's a form that's generating the error, you can
    use the Error event of the form.

    Jerry

    Goran wrote:
    > Hallo,
    > I am trying to make some last adjustments, for convenience and security,
    > before deploying a secured FE-BE DB on a network. One of the things I would
    > like to do is disabling the design view option in the right click on a form.
    > What I would also like to do is to ask Access to show another message when
    > there in no network connection, like "Sorry the network connection is not
    > available at this time etc...". In both cases, I might add, Access does a
    > nice job providing the appropriate information; that one do not have the
    > permission to view the design of the form and when there is no connection,
    > show the path to the unavailable BE DB. I am using Access 2000. Thanks for
    > any help in advance!
    > Goran
     
  4. Goran

    Goran
    Expand Collapse
    Guest

    -Each PC has a full licence, about 50.
    -The main form generates the message, on start-up. The only code in the Open
    event is:
    Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
    End Sub
    I am not sure how this is done, can I adapt the code this way?
    Private Sub Form_Open(Cancel As Integer)
    On Error GoTo Err_Form_Open_Click
    DoCmd.Maximize
    Exit_Form_Open_Click:
    Exit Sub
    Err_Form_Open_Click:
    MsgBox Err & " " & Error$
    Resume Exit_Form_Open_Click
    End Sub

    Goran

    "Jerry Porter" wrote:

    > If you implement the application using the Access Runtime, the standard
    > right-click menu will be disabled.
    >
    > If the network connection is occurring during your code, you should be
    > able to use error handling to intercept the error and display a
    > different message. If it's a form that's generating the error, you can
    > use the Error event of the form.
    >
    > Jerry
    >
    > Goran wrote:
    > > Hallo,
    > > I am trying to make some last adjustments, for convenience and security,
    > > before deploying a secured FE-BE DB on a network. One of the things I would
    > > like to do is disabling the design view option in the right click on a form.
    > > What I would also like to do is to ask Access to show another message when
    > > there in no network connection, like "Sorry the network connection is not
    > > available at this time etc...". In both cases, I might add, Access does a
    > > nice job providing the appropriate information; that one do not have the
    > > permission to view the design of the form and when there is no connection,
    > > show the path to the unavailable BE DB. I am using Access 2000. Thanks for
    > > any help in advance!
    > > Goran

    >
    >
     
  5. Jerry Porter

    Jerry Porter
    Expand Collapse
    Guest

    I doubt the error is occurring in your Form_Open event. Verify that the
    error is indeed connected to the form. If you close the form and reopen
    it, do you get the error again?

    If so, it's an error that the form generates as it tries to access
    data. To handle this type of error, you need to use the On Error event
    of the form. Display the properties window for the form, and find the
    On Error event.

    Here's a very simple example that will display a custom message and
    suppress the standard message:

    Private Sub Form_Error(DataErr As Integer, Response As Integer)
    MsgBox "Sorry, unable to connect."
    Response = acDataErrContinue
    End Sub

    Usually, you would test the value of DataErr and display appropriate
    messages depending on the actual error. You can put a break point in
    the code and test the value of DataErr for the errors you experience.

    Jerry
     
  6. Goran

    Goran
    Expand Collapse
    Guest

    - Thank you very much; this is indeed what I was looking for.
    - Concerning the design view, I tested converting the FE to an .mde. Would
    this be an appropriate option?

    Thanks again,
    Goran

    "Jerry Porter" wrote:

    > I doubt the error is occurring in your Form_Open event. Verify that the
    > error is indeed connected to the form. If you close the form and reopen
    > it, do you get the error again?
    >
    > If so, it's an error that the form generates as it tries to access
    > data. To handle this type of error, you need to use the On Error event
    > of the form. Display the properties window for the form, and find the
    > On Error event.
    >
    > Here's a very simple example that will display a custom message and
    > suppress the standard message:
    >
    > Private Sub Form_Error(DataErr As Integer, Response As Integer)
    > MsgBox "Sorry, unable to connect."
    > Response = acDataErrContinue
    > End Sub
    >
    > Usually, you would test the value of DataErr and display appropriate
    > messages depending on the actual error. You can put a break point in
    > the code and test the value of DataErr for the errors you experience.
    >
    > Jerry
    >
    >
     
  7. Jerry Porter

    Jerry Porter
    Expand Collapse
    Guest

    I haven't tried this with and mde, so you'll have to experiment.

    But I just realized there is a very simple way to turn off the context
    menu in a form:
    - Display the properties of the form
    - Select the "Other" tab
    - Change the Shortcut Menu property to "No"

    Jerry

    Goran wrote:
    > - Thank you very much; this is indeed what I was looking for.
    > - Concerning the design view, I tested converting the FE to an .mde. Would
    > this be an appropriate option?
     

Share This Page