Welcome to SPN

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

Sign Up Now!

access mdb vs mde

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

Tags:
  1. gonzosez

    gonzosez
    Expand Collapse
    Guest

    I have an application that I turn into a mde.
    The problem is that if there is no data on a report I use the following
    function.

    Private Sub Report_NoData(Cancel As Integer)
    MsgBox "There is no data for the criteria you selected."
    Cancel = True
    End Sub

    works great for the mdb file but blows up when a mde file.
    Any ideas?
     
  2. Loading...


  3. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    The code should not make a difference whether it's run in a mdb or mde.

    Could you please provide more specifics with regard to 'blows up'.


    --
    Joan Wild
    Microsoft Access MVP

    gonzosez wrote:
    > I have an application that I turn into a mde.
    > The problem is that if there is no data on a report I use the
    > following function.
    >
    > Private Sub Report_NoData(Cancel As Integer)
    > MsgBox "There is no data for the criteria you selected."
    > Cancel = True
    > End Sub
    >
    > works great for the mdb file but blows up when a mde file.
    > Any ideas?
     
  4. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    You need to trap the error (2501 I think) and ignore it.

    "gonzosez" <adf> wrote in message
    news:eU5N9T$iGHA.836@TK2MSFTNGP02.phx.gbl...
    >I have an application that I turn into a mde.
    > The problem is that if there is no data on a report I use the following
    > function.
    >
    > Private Sub Report_NoData(Cancel As Integer)
    > MsgBox "There is no data for the criteria you selected."
    > Cancel = True
    > End Sub
    >
    > works great for the mdb file but blows up when a mde file.
    > Any ideas?
    >
     

Share This Page