Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to by pass CLOSE event? (97)

    How to by pass CLOSE event?
    My report deletes a toolbar whenever the report is closed however, I have an option to re-query the report date in order to

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to by pass CLOSE event? (97)

    Why deleting a toolbar ?
    In the On Close event of the report you can use :
    DoCmd.ShowToolbar "YourToolBarName", acToolbarNo
    In the On Open event of the report use :
    DoCmd.ShowToolbar "YourToolBarName", acToolbarYes
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to by pass CLOSE event? (97)

    Well as of my post I didn

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to by pass CLOSE event? (97)

    Hehe

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to by pass CLOSE event? (97)

    It's even possible without using code:

    Forms and reports have a Toolbar property. By clicking in this property and selecting the name of a custom toolbar, you "bind" the toolbar to the form/report. This means that the toolbar will be displayed automatically when the form/report is opened and hidden when the form/report is closed. The standard Access toolbar for forms/reports will be *not* be shown.

  6. #6
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to by pass CLOSE event? (97)

    Muchos gracias, excellente seniorata (THE SIMPSONS) [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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