Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    154

    Question Unanswered: Custom Button on Custom Toolbar

    This may sound like a nutty request (maybe I am thinking too vb.net) but does anyone out there know if it is possible to put a custom button on a toolbar that runs code? I am thinking that I could make a macro and put the code on the toolbar, but the problem that I am envisioning is how to capture the name of the currently opened report while doing so. I have code modules in place that allow for making a supplied report name into a PDF, and then emailing it. I was thinking that if I could make a generic email form, with To, From, CCs Subject, Message, etc on it that if I could put a bar for it that pulls the name of any currently opened report on it and emails it that that would be much more useful than dumping these fields on every pop-up form that I have in the application to open up reports. Maybe I am thinking too grand, outside the capabilities of Access. Basically, what I would like is to put a button on the toolbar which, when pushed, grabs the name of the currently opened report and sends it to a form which allows the entry of info for emailing, and then buttons for said emailing. I could be wrong, but I don't believe that access allows for code to be put behind toolbar items. Btw, I use a different custom toolbar for reports then for forms, so that is how I would restrict the use of this function to just reports. I thank you in advance for your time and your replies.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You can create custom context menus, if that's what you mean.

    You might have to fall back on evil global variables to store the report name for later use.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I think someone posted some neat code to put a menu bar on a form which let you make it specific to that form and you could code events off of the items selected. I found the menu bar to work a little easier than the tool bar but I'm sure it can work for the tool bar.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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