Mystery macro

[bearwacket]

How do I find the reference to this mysterious macro called "."? When I
select a search term in my combo box in the header, this message comes up:

"Survey Database can't find the macro '
..'

The macro (or its macro group) doesn't exit..."

As far as I know, I don't have any macros, though I do have some coding.
I've looked through all the Events for all the items on my search page, and I
can't find anywhere I might have accidentally typed a period.

Once I "Okay" out of that warning message, the search runs just fine.

Any thoughts?

 

[Lord Kelvan]

it is something about a reference is missing or something wrong with a
sql statement i have had this problem appear from several reasons 1
example is a custom tool bar that was referenced then i changed the
name for god knows what reason and it did that error another example
was some sql in vb was tryign to execute a sql statement but since one
of the values it was tryign to execute had a ' in it ie the name
o'riely it failed and gave that error. the problem isnt a macro it is
a run time error with some failure of code. try checking your data
and that all references in your forms are correct

Regards
Kelvan

 

[Marshall Barton]

How do I find the reference to this mysterious macro called "."? When I
select a search term in my combo box in the header, this message comes up:

"Survey Database can't find the macro '
.'

The macro (or its macro group) doesn't exit..."

As far as I know, I don't have any macros, though I do have some coding.
I've looked through all the Events for all the items on my search page, and I
can't find anywhere I might have accidentally typed a period.

That kind of thing is commonly caused be an event
**property** that contains the dot (or maybe starts with a
dot) instead of being blank or containing [Event Procedure]

 

[bearwacket]

Thank you both. I knew which combo box was the cuprit, so I just redid that
one and now it works.

How do I find the reference to this mysterious macro called "."? When I
select a search term in my combo box in the header, this message comes up:

"Survey Database can't find the macro '
.'

The macro (or its macro group) doesn't exit..."

As far as I know, I don't have any macros, though I do have some coding.
I've looked through all the Events for all the items on my search page, and I
can't find anywhere I might have accidentally typed a period.

That kind of thing is commonly caused be an event
**property** that contains the dot (or maybe starts with a
dot) instead of being blank or containing [Event Procedure]

 

[Linq Adams via AccessMonster.com]

Mark is correct, this problem is almost always the result of a something
being only partially deleted from the event property of a control. It almost
always involves "." I suspect because the period by itself is all but
invisible to the humane eye in these boxes. Fortunately you knew which
control was causing the problem. Often these fact is illusive and you can
lose hair trying to track it down.