Make function in form class module visible to AutoKeys macro

G

Guest

Using Office 2003 and Windows XP;

I have an AutoKeys macro that fires on a certain code combination. However,
this macro cannot see the function to call if it is placed in one of the
class modules associated with a form. Even if I use a "Public" function.

Question: Is there a way to make my function DIRECTLY visible and callable
by the AutoKeys macro if it resides in a form's class module? If so, how?

Thanks much for your assistance.
 
G

Guest

Better to create the function in a module, and then call it from both, the
form and the macro.

For your question, you can call a function in a form
Try,

Form_FormName.SubName
 
G

Guest

Thanks, but it doesn't work, probably because the form is not open; I guess
for your method to work, the form must be open?

Is there a way for it to find the function even if the form is closed? - or
open the form then run the function?
 
G

Guest

It should run the sub or function that defined in a form even if the form is
closed.

Check the names of the objects.

FormName and Sub/Function name
 
G

Guest

Sorry, but it still doesn't work; it says it can't find my form; I have
triple checked and copied the name exactly. My function name looks like this:

Form_frmEditData.AdminOpen()

I'm using a function in the form module: Public Function AdminOpen()

I tried it with and without the parentheses. Any ideas?
 
G

Guest

You right, the macro doesn't recognise it.
What you can do is to create a function in a mudule that call the function
in the form, and then call that function from the macro (I don't like it, to
complex).

Why don't you move the function from the form to a module, that way you can
call it from the form and macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoKeys In Module View Access 2000 3
Custom Programming Aid 9
Is an autokeys macro safe to use in a runtime app? 1
Autokeys macro doesn't work in code window 1
Set form's properties from a Public Function in a utilities module 9
Class module 6
Codes for Screen active form 2
Difference between Form's Class Module and Class Module 4

Top