Action failed on form

[KateB]

A colleague has a database created by someone who has since left the company.

They access it by one form which is opened by a macro. We get the message
Action failed (with only a halt option) which says Macro_name: Ipt_incidents,
Condition: True, Action Name: OpenForm, Arguements:
Ipt_incident,Form,,,,Normal. I've tried going directly to the form but it
won't allow me to open it (all other forms are OK). I assume the macro is
corrupted - is there an easy way to repair it, or should it be deleted?
They're loathe to let me try anything without further advice!

Can anyone help? Many thanks.

 

[Brendan Reynolds]

A colleague has a database created by someone who has since left the
company.

They access it by one form which is opened by a macro. We get the message
Action failed (with only a halt option) which says Macro_name:
Ipt_incidents,
Condition: True, Action Name: OpenForm, Arguements:
Ipt_incident,Form,,,,Normal. I've tried going directly to the form but it
won't allow me to open it (all other forms are OK). I assume the macro is
corrupted - is there an easy way to repair it, or should it be deleted?
They're loathe to let me try anything without further advice!

Can anyone help? Many thanks.

If you can't open the form directly, it sounds more likely that there is a
problem with the form than with the macro. What happens when you try to open
the form directly? Can you open it in design view?

 

[KateB]

It doesn't do anything! The other forms will open with a double click or by
right click at choosing open, but this one does absolutely nothing. I didn't
know if the macro could override opening it directly? Should I try to
disable the macro (if that's possible?)

 

[Brendan Reynolds]

It doesn't do anything! The other forms will open with a double click or
by
right click at choosing open, but this one does absolutely nothing. I
didn't
know if the macro could override opening it directly? Should I try to
disable the macro (if that's possible?)

No, when you are trying to open the form in design view, the macro is not
running, so the problem lies with the form, not with the macro. Perhaps the
form is corrupted. Tony Towes has a great FAQ on how to recover corrupted
forms and other objects at the following URL ...

http://www.granite.ab.ca/access/corruption/corruptobjects.htm

 

[KateB]

OK, thanks for the help. Might need to find a techie to look at it - if only
we had one!! At least I have an idea of where to start now. Again, many
thanks.