Calling Module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wrote a module that I now want to call and execute from a form.

If I use DoCmd.OpenModule, how do i then run it and close it. Feeling a
little silly asking such a basic question, but how do I do this?
 
Sash

A module is a container. If you wrote a procedure, you can call that
procedure by name, providing any parameters required by your procedure.

If your procedure does not return a value (i.e., a subroutine), you can just
call it.

If your procedure returns a value (i.e., a function), you would provide a
variable to receive its value.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
Okay. In my module I have several subroutines, functions that bascially
create an array, analyze the data and updates a table accordingly. I wanted
to call this from a form and have it process the data. When I call the
moduule it process and writes the data to my table as expected. However, I
get and error "Microsoft Access can't fine the macro 'CheckData'

Any ideas?
 
Do you have something named "CheckData"?

Have you set a breakpoint in your code/functions and stepped through to see
when this triggers?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top