Converting macro's to VBA

[JvM]

Good afternoon,

I've converted some macro's to VBA.

How do I call on these module's?

Thankxxx

 

[fuzzygeek]

Once you converted, you should have a function name.
Example:
Function MyJob()
blah blah blah
End Function
To use this function if it is not returning a resultant value, in code:

Call MyJob()

If it is returning a value use a variable, for example:

Dim results as string (or whatever your result returns)

Results = MyJob()

 

[EPD Hater]

I'm not sure if that was the answer he was looking for. If it was, then great; if not then here you go. You need to attach your subroutines to events such as OnClick, or Before Update. I could be missing some things though. If you are executing your code through forms, then you can see these events in the properties box of a control button or whichever control you are using on your form.

 

[JvM]

To both,

Thank you you very much for the tips.

I didn't know there was a function in acces to change the macro's in a form to VB..

It increases the speed for my application considerably..

Thank you very much....