Results 1 to 5 of 5
  1. #1
    notacluewhatimdoing is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    3

    Embedded Macro not there

    Hi, I'm a complete access novice.
    I'm creating form buttons to attach to another form in my database,
    After creating it , it works fine but I want to go into the macro builder
    to add some fore functions to the button as I've seen done in tutorial
    video. However, instead of an embedded macro I get an event procedure


    and it takes me into code builder and doesn't give me a choice of builder
    and I can't code.. Any ideas much appreciated!
    Thanks
    Sam

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,006
    Didn't know that they'd changed the default to Event Procedure in 2010; in 2007 you had to explicitly set it to that! Anyway

    1. Go to Office Button (Big Icon, Top/Left)
    2. Click on Access Options (bottom, right of Dialog Box)
    3. Click on Object Designers
    4. Go to Forms/Reports and Untick Always Use Event Procedures
    5. Click on OK (Bottom, Right)

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    notacluewhatimdoing is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    3
    thanks, but it's already unticked, the thing is the first few buttons I made used the macro so I was fine then all of a sudden it started using event procedures and I can't figure out why???

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,006
    What, exactly, are these errant buttons being used for?

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    notacluewhatimdoing is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    3
    they're being used to link forms creating a user interface for my database (all the separate forms are made I just need to link them). For example I want one button to open up a form and close the main menu (the form on which the button is). I know exactly how to do this it it is a macro but not as an event procedure.
    Thanks Again
    Sam

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

Similar Threads

  1. Embedded Macro
    By sireesha in forum Forms
    Replies: 1
    Last Post: 12-08-2012, 02:28 PM
  2. Embedded Macro Test Strategy
    By bginhb in forum Programming
    Replies: 1
    Last Post: 08-03-2011, 12:59 PM
  3. Embedded macro
    By thart21 in forum Forms
    Replies: 1
    Last Post: 06-28-2011, 12:18 PM
  4. Run a Embedded Macro from VBA Code
    By sabre1 in forum Programming
    Replies: 3
    Last Post: 02-25-2011, 10:26 AM
  5. Run Embedded Macro
    By smikkelsen in forum Forms
    Replies: 0
    Last Post: 07-07-2010, 09:44 PM

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