Results 1 to 5 of 5
  1. #1
    adacpt is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    12

    Running a module from a button click


    Hello,
    Can anyone help me figure out how to run a module by clicking on a button in a form?

    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Do you want macro or VBA? Why are you having issue? There are wizards to create code. What behavior do you want?
    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
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    FYI, You don't "run" modules. Your run (execute) procedures. Modules are containers that hold procedures subroutines and functions.

  4. #4
    adacpt is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    12
    I've created several modules that create queries that organize information in several different ways that are useful to me. Each of these queries has multiple versions for different project. The query is the same, but the project name is different. So, what I'm trying to do is create a button_click that creates all of these queries (using these modules) for whenever a new project occurs.

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Import the module into another dB. Name this dB something like Library. On a new project, import the module(s) from the library dB to the new dB. Eazy- pizy.

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

Similar Threads

  1. Running a module from a button in a form
    By sardamil in forum Modules
    Replies: 3
    Last Post: 05-01-2012, 10:59 PM
  2. Trying to click a button in vba
    By boywonder in forum Programming
    Replies: 8
    Last Post: 05-02-2011, 04:34 AM
  3. Running a module
    By KevinMCB in forum Modules
    Replies: 2
    Last Post: 03-09-2011, 02:38 PM
  4. +1 on button click
    By 10 Gauge in forum Forms
    Replies: 4
    Last Post: 02-14-2011, 06:51 AM
  5. Running module from Macro
    By Harley Guy in forum Modules
    Replies: 6
    Last Post: 10-27-2010, 11:05 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