Can't find macro '.'

[whatever]

Greetings, I have an Access 2000 db with a intermittent recurring error message on one form.

The message reads: "can't find the macro '.'" I think this may be down to having a space allocated to an event procedure on one of the forms controls, but I cannot find it. My question is two fold:

1. If its due to a space allocated to an event how do I find which control and event it is associated with, or

2. If its not a space what could it be?

The message does not appear to be linked to any one control or event and can occur at any time in relatio0n to any event on any control??


TIA



Kevin

 

[MStCyr]

Have you tried to Compact & Repair?

If the problem persists, create a new blank database and import all of your objects into the new database.

 

[whatever]

MStCyr, thanks for the reply, I should have added in the post that the db does compact and repair and compile to an MDE, the option of copying everything to a new db is a last resort as the db has over a hundred forms, I probably need to write some code that steps through each control and its associated events looking for an associated macro name of " ", any ideas gratefully received.

TIA


Kevin

 

[WayneRyan]

Kevin,

I've had that problem before. I definitely had no macro referenced
on the form, or even in the database.

My feeling is that it is just a "brain dead" form. I ended up just
making a new form. I was never able to find out the cause of the
message.

I posted my initial problem here a couple of years ago ... no resolution.
I guess it's just one of those things.

Wayne

 

[whatever]

Wayne, thanks for the response. Unless some kind soul can help me with code to step through each control and its associated events in an attempt to find the " " or has another approach i think you are right and I will have to create another form.

Cheers


Kevin

 

[WayneRyan]

Kevin,

I really hope that there's some kind soul, BUT ...

I never found a resolution, rebuild the form while you wait.

Welcome to the world of Access.

Wayne