Results 1 to 9 of 9
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Converting all Macros in 2010

    This shouldn't be hard. I've done it before, but not lately and not in this version. I want to convert them all in one fell swoop and put them all in a single module

    I'm learning a new database from the ground up and it would be helpful to have them all in code and searchable.

    Thanks in advance.

    Paul

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    How can all macros be in one module? Embedded macros would convert to code behind forms and reports. And of course, DataMacros do not convert.

    Don't see any way to convert all in 'one fell swoop'. How could you have done it before in earlier version of Access?
    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
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    I'm only referring to macros not embedded in forms, the ones that are listed in the Macro portion of the Navigation Pane.

  4. #4
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    At this time I am waiting for permission to install Find and Replace. Once I get that, it will solve a number of questions I have.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Still not seeing a 'one fell swoop' feature.
    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.

  6. #6
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    I swear I've done it before, but then I'm getting old.

  7. #7
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I meant to add 'without VBA'.
    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.

  9. #9
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    I've inherited a database developed over 16 years and it's beating me up. This macro thing is the least of my problems. I'll come back for something more important.

    Thanks for you help though. Have a good weekend.

    Paul

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

Similar Threads

  1. Converting Macros to VBA code
    By Lou_Reed in forum Access
    Replies: 67
    Last Post: 07-27-2017, 12:27 PM
  2. Converting Macros To VBA in 2013 Office
    By data808 in forum Access
    Replies: 8
    Last Post: 06-17-2014, 02:37 AM
  3. 2010 Macros
    By detaylor1242 in forum Programming
    Replies: 1
    Last Post: 09-20-2013, 09:06 PM
  4. Access 2010 Macros
    By jdftwrth98 in forum Programming
    Replies: 1
    Last Post: 07-01-2012, 12:11 PM
  5. Really need help with 2010 Macros
    By Tablerone in forum Programming
    Replies: 2
    Last Post: 10-04-2011, 04:27 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