Run a VBA function from Access button - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Run a VBA function from Access button

genesysrgmgenesysrgm Posts: 1Member
How can I run a function that I wrote in VBA code in a standard module. I would like to run it from a button on the Access forms page. I tried creating a macro to run it but the macro cannot seem to find the code.

Anyone got any ideas.

Thanks for your help

Comments

  • jaime777jaime777 Posts: 17Member
    Hi,

    Create a new form and add a button control. Go to the button properties and select the "Event" tab. Select [Event Procedure] next to "On Click" and click (...) to open the VB module.

    Private Sub Command0_Click()

    'your code goes here..

    End Sub

    Hope this helps!

    -Jaime
    http://www.programmerssolutions.com
Sign In or Register to comment.