I cannot decipher my macro error message

[Angela]

I'm using Access 2000 to build a budget database. I don't know what to do
about the error message I'm getting on a form. When I open the form the
message comes up saying, "Microsoft Access can't find the macro
'mcr_RequiredFieldWarning_ProjectName.'

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 macro group was last saved
under." Can anyone help?

 

[Ken Snell \(MVP\)]

Sounds as if you have the text string mcr_RequiredFieldWarning_ProjectName
in one of the Event properties' boxes (Properties window for the form). Open
the form in design view, and open the Properties window; click on the Event
tab and see what is there.

 

[Angela]

Thank you Ken, I tried taking your advice. Unfortunately, it didn't help, but
thanks again for trying.

 

[Ken Snell \(MVP\)]

Somewhere in the form, that text string is being used as the macro for an
event property (if not for the form, then for one of the controls that are
on the form), or is in the VBA code as some type of method, or ....

 

[Angela]

Thank you, thank you, thank you!!!! You are a life saver. I got it!!!

 

[efandango]

Ken,

I get almost the same error message, except the characters are slightly
different.

Here's the message, verbatim (asterix's to just show the message box).

*****************************************************
Microsoft Office Access can't find the Macro ''
..

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.

***************************************

It comes as a result of a macro doing a SetValue on a [scorebox] control on
a form. The macro checks if another control contains "yes" or "No", if it is
yes, then it does a SetValue on the [Scorebox] control, adding a 1 (for
scorebox counting). Now the weird thing is, if I unbind the scorebox from its
underlying table, i don't get the error message. If I leave it bound, i get
the error back... Even though, after I clear the error, the correct data
score is in the record within the table.

I have read your replies to Angela, and have serached everywhere, on every
control on the form, every record source, but i just can't get rid of it. I
have read various answers to the general 'Can't find macro problem' across a
number of forums, and each answer is very different from another. Even
microsoft's answer is wildly different from your suggested cause. Do you have
the lowdown on a definitive answer, or some idea of why this is happening on
my Access?

any help you can give would be appreciated, as this problem is really
driving me Nuts!, i have been on it for nearly two days, and still can't find
the solution.

 

[tina]

if you've searched thoroughly, and can't find the offending character
anywhere in a form or control event, or in the VBA module; then (if you're
using A2000 or newer) did you turn OFF the Name Autocorrect option when you
created this database? if not, that *may* be the culprit. try creating a
new, blank database and immediately turning off the Name Autocorrect option
from Tools | Options | General tab. then compact the database, import all
the objects from your current database, and compact again.

hth

Ken,

I get almost the same error message, except the characters are slightly
different.

Here's the message, verbatim (asterix's to just show the message box).

*****************************************************
Microsoft Office Access can't find the Macro ''
.

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.

***************************************

It comes as a result of a macro doing a SetValue on a [scorebox] control on
a form. The macro checks if another control contains "yes" or "No", if it is
yes, then it does a SetValue on the [Scorebox] control, adding a 1 (for
scorebox counting). Now the weird thing is, if I unbind the scorebox from its
underlying table, i don't get the error message. If I leave it bound, i get
the error back... Even though, after I clear the error, the correct data
score is in the record within the table.

I have read your replies to Angela, and have serached everywhere, on every
control on the form, every record source, but i just can't get rid of it. I
have read various answers to the general 'Can't find macro problem' across a
number of forums, and each answer is very different from another. Even
microsoft's answer is wildly different from your suggested cause. Do you have
the lowdown on a definitive answer, or some idea of why this is happening on
my Access?

any help you can give would be appreciated, as this problem is really
driving me Nuts!, i have been on it for nearly two days, and still can't find
the solution.

Somewhere in the form, that text string is being used as the macro for an
event property (if not for the form, then for one of the controls that are
on the form), or is in the VBA code as some type of method, or ....

 

[efandango]

Thanks Tina,

yes indeed, i have searched thoroughly, I even imported the elements into a
new clean database, but still it gave the problem. I concluded that the form
itself was corrupt, rebuilt it from new, and the problem went away. This
Autocorrect feature, if it's going to cause that level of grief, is it worth
having turned on?, what does it autocorrect?

if you've searched thoroughly, and can't find the offending character
anywhere in a form or control event, or in the VBA module; then (if you're
using A2000 or newer) did you turn OFF the Name Autocorrect option when you
created this database? if not, that *may* be the culprit. try creating a
new, blank database and immediately turning off the Name Autocorrect option
from Tools | Options | General tab. then compact the database, import all
the objects from your current database, and compact again.

hth

Ken,

I get almost the same error message, except the characters are slightly
different.

Here's the message, verbatim (asterix's to just show the message box).

*****************************************************
Microsoft Office Access can't find the Macro ''
.

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.

***************************************

It comes as a result of a macro doing a SetValue on a [scorebox] control on
a form. The macro checks if another control contains "yes" or "No", if it is
yes, then it does a SetValue on the [Scorebox] control, adding a 1 (for
scorebox counting). Now the weird thing is, if I unbind the scorebox from its
underlying table, i don't get the error message. If I leave it bound, i get
the error back... Even though, after I clear the error, the correct data
score is in the record within the table.

I have read your replies to Angela, and have serached everywhere, on every
control on the form, every record source, but i just can't get rid of it. I
have read various answers to the general 'Can't find macro problem' across a
number of forums, and each answer is very different from another. Even
microsoft's answer is wildly different from your suggested cause. Do you have
the lowdown on a definitive answer, or some idea of why this is happening on
my Access?

any help you can give would be appreciated, as this problem is really
driving me Nuts!, i have been on it for nearly two days, and still can't find
the solution.

Somewhere in the form, that text string is being used as the macro for an
event property (if not for the form, then for one of the controls that are
on the form), or is in the VBA code as some type of method, or ....


--

Ken Snell
<MS ACCESS MVP>


Thank you Ken, I tried taking your advice. Unfortunately, it didn't help,
but
thanks again for trying.

:

Sounds as if you have the text string
mcr_RequiredFieldWarning_ProjectName
in one of the Event properties' boxes (Properties window for the form).
Open
the form in design view, and open the Properties window; click on the
Event
tab and see what is there.
--

Ken Snell
<MS ACCESS MVP>



I'm using Access 2000 to build a budget database. I don't know what to
do
about the error message I'm getting on a form. When I open the form the
message comes up saying, "Microsoft Access can't find the macro
'mcr_RequiredFieldWarning_ProjectName.'

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 macro group was last
saved
under." Can anyone help?

 

[tina]

no, it's not worth having it turned on, IMO. unfortunately, in A2000 (and
A2003, AFAIK), it's turned on automatically in every new database that's
created, and the setting is database-specific. so you have to turn it off
manually (or programmatically) in each database that you create. as for what
it was intended to do originally, i don't really know the details; suffice
it to say that any value it may add is far, far outweighed by the grief it
causes.

hth

Thanks Tina,

yes indeed, i have searched thoroughly, I even imported the elements into a
new clean database, but still it gave the problem. I concluded that the form
itself was corrupt, rebuilt it from new, and the problem went away. This
Autocorrect feature, if it's going to cause that level of grief, is it worth
having turned on?, what does it autocorrect?

if you've searched thoroughly, and can't find the offending character
anywhere in a form or control event, or in the VBA module; then (if you're
using A2000 or newer) did you turn OFF the Name Autocorrect option when you
created this database? if not, that *may* be the culprit. try creating a
new, blank database and immediately turning off the Name Autocorrect option
from Tools | Options | General tab. then compact the database, import all
the objects from your current database, and compact again.

hth

Ken,

I get almost the same error message, except the characters are slightly
different.

Here's the message, verbatim (asterix's to just show the message box).

*****************************************************
Microsoft Office Access can't find the Macro '

'
.

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.

***************************************

It comes as a result of a macro doing a SetValue on a [scorebox]

control
on

a form. The macro checks if another control contains "yes" or "No", if

it
is

yes, then it does a SetValue on the [Scorebox] control, adding a 1 (for
scorebox counting). Now the weird thing is, if I unbind the scorebox

from
its

underlying table, i don't get the error message. If I leave it bound,

i
get

the error back... Even though, after I clear the error, the correct data
score is in the record within the table.

I have read your replies to Angela, and have serached everywhere, on every
control on the form, every record source, but i just can't get rid of

it.
I

have read various answers to the general 'Can't find macro problem'

across
a

number of forums, and each answer is very different from another. Even
microsoft's answer is wildly different from your suggested cause. Do

you
have

the lowdown on a definitive answer, or some idea of why this is

happening
on

my Access?

any help you can give would be appreciated, as this problem is really
driving me Nuts!, i have been on it for nearly two days, and still

can't
find

the solution.






:

Somewhere in the form, that text string is being used as the macro

for
an

event property (if not for the form, then for one of the controls

that
are

on the form), or is in the VBA code as some type of method, or ....


--

Ken Snell
<MS ACCESS MVP>


Thank you Ken, I tried taking your advice. Unfortunately, it

didn't
help,

but
thanks again for trying.

:

Sounds as if you have the text string
mcr_RequiredFieldWarning_ProjectName
in one of the Event properties' boxes (Properties window for the form).
Open
the form in design view, and open the Properties window; click on the
Event
tab and see what is there.
--

Ken Snell
<MS ACCESS MVP>



I'm using Access 2000 to build a budget database. I don't know

what
to

do
about the error message I'm getting on a form. When I open the

form
the

message comes up saying, "Microsoft Access can't find the macro
'mcr_RequiredFieldWarning_ProjectName.'

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 macro group

was
last

saved
under." Can anyone help?

 

[Eric_G]

Hi Ken,
I've read throug the thread and am experiencing the same problem. The
report I was running ran smoothly and then something changed and I'm
receiving the same error message so I can't open the report. The macro name
which appears to be "missing" is "macro1". I've looked for this macro name
but doesn't appear anywhere.

 

[Ken Snell \(MVP\)]

Without having more details, the best I can reply is to repeat what I
advised Angela:

Somewhere in the report or in a form that is running the report, that text
string is being used as the macro for an event property (if not for the
form, then for one of the controls that are on the form or report), or is in
the VBA code as some type of method, or ....

What might have "changed"?