how to call modules in a form

[hoda64]

Hello everyone,

I am a student intern and a bit of a novice to Microsoft Access. I have been asked to fix a database that originally had worked fine, however after my workplace switched to Microsoft XP, they changed the security settings so that certain Macro's in that database do not work anymore.

I decided to try to convert the macros into modules via Microsoft Access' automatic converter. However, on the forms of the database, I do not know how to call these functions.

So when I go to the properties of the form, lets say that theres a button which used to be assigned to a macro, I want to now assign it to the converted macro->module. Is that even possible, and if so, how do I go about calling it?

I appreciate any help

 

[DCrake]

Simple Software Solutions

Choose a converted macro and copy the VBA code to the buffer.

Next design the form and go to the properties of the button that used to run the maco

Select the OnClick Property and choose [Event Procedure]
Once inside the VBA editor paste the code that was in the converted macro.

Save the form and retry.

Once you are happy that it works you can delte bothe the macro and the converted code.


CodeMaster:

 

[hoda64]

Ok thank you so much, it works now