Re: Combining 84 tables with one query...help!

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ken,

Just what the Microsoft doctor ordered!

I got the combo box working no problem (I did, however, choose to show
both first and last names, there are quite a few duplicates of first
and last names...for instance, we have two - yes, two - members named
John Rosenberg. Interesting, eh?).

Anyways, when I went to configure the "on click" script, i get the
following error:

"Microsoft Access can't find the macro 'If Not IsNull(Me.'
The macro (or its macro group) doesn't exist, or the macro is new but
hasn't been saved. Note that when you enter the
macrogroupname.macroname syntax in an argument, you must specify the
name the macro's group was last saved under."


I don't understand this error....should I be making the code you posted
into a macro and then having the "on click" just execute that macro?

Thanks,
Rick Heil

.

Relevant Pages

  • Re: Trying to create a search for a library database
    ... I did put the exclamation poing after Me......no references are missing. ... Microsoft Access can't find the macro 'Me!MyBookList.' ... The macro (or its macro group) doesn't exist, or the macro is new and hasn't ...
    (microsoft.public.access.queries)
  • Re: Hide Main Report Page Footer on Subreport pages
    ... I chose the On Print Event Procedure on the Main Report because I was not ... The macro (or its macro group) doesn't exist, or the macro is new but hasn't ... My problem is I have a Page Footer on my Main Report and I only want it to ...
    (microsoft.public.access.reports)
  • Re: Problems with action queries in a macro group
    ... A macro group is a group of macros :-) This is not applicable to the task you are trying to perform. ... Creating a macro group which includes a number of individually named macros, is a great way to manage macros where you only want to run one of the macros within the group at any given time. ... You want a single macro with a number of actions in that macro, i.e. all the actions you want to perform at any given time within the same macro. ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)
  • Re: Copy a network file and paste locally using a Macro
    ... The syntax would be: ... Steve Schapel, Microsoft Access MVP ... I would like to be able to do this directly within the macro. ...
    (microsoft.public.access.macros)
  • Re: Command button for time & date
    ... That's what we mean when we talk about the "event procedure" of the button. ... "Microsoft Office Access can't find the macro "Me." ... you must specify the name the macro's macro group was last ...
    (microsoft.public.access.forms)