Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Summerville, South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Modal and PopUp Properties to True (Access 2000)

    In Access 2002, you can set the properties of a report so that modal is yes and popup is yes. In 2000, this option is not available. Is there any way to VBA this code on the on open event?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Setting Modal and PopUp Properties to True (Access 2000)

    No, but there might be other workarounds if you explain the problem you're trying to solve. For example, if you maximize the report in code when it opens and make sure any forms, etc., are hidden, you'll get the same effect.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Summerville, South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting Modal and PopUp Properties to True (Access 2000)

    I have a form that has its setting to be a modal and popup. The command buttons open both forms and reports. I want to still keep the main form popup and modal form, but have the ability to see the report without closing the main form. Is there code that will hide my main form so the report can be seen?

  4. #4
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting Modal and PopUp Properties to True (Access 2000)

    You could use the "Visible " property:

    Private Sub Report_Open(Cancel As Integer)
    Forms!FrmMyForm.Visible = False
    End Sub

    Private Sub Report_Close(Cancel As Integer)
    Forms!FrmMyForm.Visible = True
    End Sub

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Setting Modal and PopUp Properties to True (Access 2000)

    If you hide a modal/popup form, you can popup something else, including a report. Use Dave's suggestion and don't forget to make the form visible again when the report closes..
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •