Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    133

    Unanswered: newbie: needhelp with custom built menu bar

    I already know the way to create custom menu bar in Access by point to:
    Tool-->Customize--> and then drag custom menu into outside.
    But I wonder if there is a way to put (simple) VBA code into custom menu bar?
    I mean, for example, I already have a blank custom menu bar, and then I put some thing symbol into it, and then write some code for click event of that symbol (ex: docmd.openform "employees"). When I click that symbol on custom menu bar, it will open form employees for me.
    many thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    How ive done this in the past is to write my code as a function which you can call from a macro, and then in the properties of your new button run the macro that calls the function,

    Dave

  3. #3
    Join Date
    May 2004
    Posts
    133
    thank you. I done

Posting Permissions

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