library database?

[cherrynich]

I have a line of code where a macro I made is involved, vba says there isn't
any macro by that name. I looked in help and it states that if the macro
isn't recognized it could be a library database. So how do I know if I made
a library database or not????? if not why won't the name recognize????
thanks

 

[Damien McBain]

I have a line of code where a macro I made is involved, vba says
there isn't any macro by that name. I looked in help and it states
that if the macro isn't recognized it could be a library database.
So how do I know if I made a library database or not????? if not why
won't the name recognize???? thanks

What method are you using to run the macro? Is it a macro or a VBA
subroutine?
I prefer not to use macros and if I do (like in my older db's) I convert
them all to VBA using the built in tool (Access2k).

 

[Van T. Dinh]

You have to explain a fair bit more of your set-up. In Access, Macros are 2
different beasts altogether. In Macros, you select Macro actions and then
enter argument as required. In VBA code, you write VBA statements that make
up procedures.

The links between Macros and VBA are:

1. In Macros, you can use the RunCode Macro action to run a function
procedure.
2. In VBA, you can use the RunMacro Method (of the DoCmd Object) to run a
Macro.

Describe your set-up including how you "link" between Macros and VBA codes.

HTH
Van T. Dinh
MVP (Access)

 

[Brian]

I have a line of code where a macro I made is involved, vba says there isn't
any macro by that name. I looked in help and it states that if the macro
isn't recognized it could be a library database. So how do I know if I made
a library database or not????? if not why won't the name recognize????
thanks

You can't create a library database by accident: you would know!

It's not at all clear from your post whether you are talking about macros or
Visual Basic. How about yoou post the offending statement, then it may
become clear?