Results 1 to 4 of 4
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Changing a Macro into VBA

    I am using MS Access 2010 I am programming the VBA aspect of the MS Access software. This database that I have


    has several embedded macros that I would like to convert to VBA.

    I have not been able to do that. I am unable to bring up the

    Convert Form's Macro to VBA.

    The button is not easily found. I just cannot seem to locate this.

    Where is it and how do I convert an Embedded Macro to VBA.

    Any help appreciated. Thanks in advance.

    Respectfully,


    Lou Reed

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    usually all commands in vba are docmd.XXXX
    docmd.openquery
    docmd.transferspreadsheet
    ...

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I am using the following link as my instruction guide. The link is: http://www.iaccessworld.com/how-to-c...ro-to-vb-code/.

    When it gets to

    Step 2 Under the form design view, click on the "Convert Form's Macro to Visual Basic".


    I am not finding the radio button to do that. I am lost here.

    Where is this button?


    Respectfully,

    Lou Reed

  4. #4
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Okay, I got it. No need to answerer this question. I have my answer.

    I do have one additional question and that is : is the embedded macro code lost forever.

    Any help appreciated.

    Thanks in advance.


    Respectfully,


    Lou Reed

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

Similar Threads

  1. Replies: 1
    Last Post: 01-21-2015, 02:02 PM
  2. Replies: 1
    Last Post: 01-13-2015, 01:33 PM
  3. Replies: 2
    Last Post: 05-05-2012, 02:34 AM
  4. Replies: 3
    Last Post: 01-04-2012, 05:16 PM
  5. Replies: 0
    Last Post: 01-12-2011, 12:43 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