Results 1 to 3 of 3

Thread: trigger an access macro

  1. #1

    Thread Starter
    Lively Member Crazy_bee's Avatar
    Join Date
    Jul 2001
    Location
    Fitchburg
    Posts
    90

    trigger an access macro

    Is there a way that I could trigger an access macro from a VB app?
    Don't ever Ginop before you Ginip

  2. #2

    Thread Starter
    Lively Member Crazy_bee's Avatar
    Join Date
    Jul 2001
    Location
    Fitchburg
    Posts
    90
    Come on I thought you guys would know this.
    Don't ever Ginop before you Ginip

  3. #3
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Search there have been plenty of things like this come up. You'd have to open an instance of Access from inside VB.

    VB Code:
    1. 'something like this
    2. 'after setting a reference to the Access object
    3. dim appAccess as Application.Access
    4. Set appAccess=New Application.Access
    5.  
    6. appAccess.DoCmd.RunMacro "MacroName"

Posting Permissions

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



Click Here to Expand Forum to Full Width