Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    23

    VBA code for macros

    Dear all,



    I have the following problem. I created VBA code for running a macro within access. But the problem now is that I can only execute the macro when I open Visual Basic Editor. But i want the macro to show up in my macro objects.

    Anybody a clue on how I can achieve this?

    Dear regards, Marc

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Macro objects only show Macros, not VBA code. VBA is stored under Modules.
    VBA code can be run from Macros, or can be called from other VBA, Macros, or events (like button click).
    Note that you can run a VBA Function from Macros using the RunCode action.

    What is your exact code?
    What is it exactly that you are trying to do?

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

Similar Threads

  1. Replies: 9
    Last Post: 01-11-2012, 01:29 PM
  2. Macros
    By Capri Pruitt in forum Access
    Replies: 1
    Last Post: 09-13-2010, 10:36 PM
  3. vba vs macros
    By RedGoneWILD in forum Access
    Replies: 4
    Last Post: 08-06-2010, 12:48 AM
  4. VBA or Macros
    By mastromb in forum Forms
    Replies: 6
    Last Post: 01-03-2010, 04:46 PM
  5. Macros
    By kfhai in forum Access
    Replies: 0
    Last Post: 04-17-2009, 08:28 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