Results 1 to 3 of 3
  1. #1
    gseales is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Wi, USA
    Posts
    2

    Pass parameter and run VBA code in Access db from a outside script


    I want to pass a value from our accounting system, by running a script, to one of my Access databases and run some vba code using that value. Can this be done if db is already open or closed?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    gseales is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Wi, USA
    Posts
    2
    Thank you June7. A link (http://www.mrexcel.com/forum/microso...in-script.html) from inside your suggestion lead me to the answer I needed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How To Pass a String to a Parameter in a Report
    By hammer187 in forum Programming
    Replies: 1
    Last Post: 09-17-2012, 01:44 PM
  2. Read form info, pass to VB script... lost
    By enragedcow in forum Forms
    Replies: 4
    Last Post: 08-28-2012, 01:11 PM
  3. Replies: 2
    Last Post: 02-10-2011, 10:44 AM
  4. Replies: 3
    Last Post: 12-28-2010, 12:42 PM
  5. Pass list as parameter to in operator
    By bliever in forum Queries
    Replies: 5
    Last Post: 11-11-2009, 03:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums