User Profile

Collapse

Profile Sidebar

Collapse
Drisconsult
Drisconsult
Last Activity: Mar 31 '08, 09:08 AM
Joined: Mar 30 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Drisconsult
    replied to Assigning converted Access macros
    in Access
    Hello All

    I have successfully assigned my VBA converted macros to labels using the following code:
    Code:
    Private Sub LABEL01_Click()
    Call mcrOPEN01
End Sub
    But I am having trouble assigning the VBA converted macro to a command button.

    Regards
    Terence
    See more | Go to post

      Leave a comment:

    • Drisconsult
      replied to Assigning converted Access macros
      in Access
      Many thanks for replying to my query

      I have changed the macro1 to the name of my macro, which is mcrOpen 01 but get an error referring to an ambiguous name detected: mcrOpen 01. What am I doing wrong?

      Regards
      Terence
      See more | Go to post

        Leave a comment:

      • Drisconsult
        started a topic Assigning converted Access macros
        in Access

        Assigning converted Access macros

        Hello All
        I am new to VBA. I have just begun converted all my Access macros to VBA. As I understand it they are converted to Modules. How do I assign the converted module to the command button that originally launched the macro, or do I have to create a new button or label?

        For example, I have 12 command buttons that open forms from a menu, I now wish to convert the macros to VBA and have each form launched using VBA.
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...