Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2

    Unanswered: Tracking down a custom commandbar

    Greetings!

    One of our users has complained that he can no longer send E-mails directly from a bespoke Access application. I've tracked down the button that is apparently failing for him, and it's on a custom command bar. Is there any way that I can find the bar in question and then find out what the command is supposed to do?

    The file is an Access 2000 .adp that connects to a SQL Server 2000 database.

    It has a professional-looking icon and a screen tip text ("Send to Mail Recipient (as Attachment)"), but I'd like to have a closer look at it if possible.

    TIA!
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183

    Tracking down a custom commandbar

    Take a look at the following Blog Posts on creating Custom Menus/Toolbars:

    Custom Menus and Toolbars
    Custom Menus and Toolbars-2

    You can learn how to create custom Menus/Toolbars and attach Macros/VBA Routines to menu/toolbar options.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Thanks for the reply!

    I've created menu bars before, but I can easily see the code that does it (it's in an Excel add-in that adds a menu and some custom functionality to spreadsheets). What I can't see in this database is the code that creates the menu bar. I've checked all the code and class modules, and there's nothing that looks remotely responsible.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Problem solved, if not how I thought it would be.

    Turned out that the user's PC has lost its default E-mail program. Once I talked him through setting that up again, it was fine!
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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