Error accessing a form 1

[istone]

Hi,
I am trying to open a form from a switchboard and I get this error message:

"MSACCESS exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created."

I restart the computer and it's fixed. but it keeps happening. Does anyone know the solution?

I have Microsoft Office 2000

thanks

 

[Ed2020]

Can you open the form in Design view?

If so I've had a similar problem with a form in one of my systems. It appeared to be caused by a corrupt control on the form - replacing the control in question sorted it out.

Of course if you have a lot of controls on the form it may take a while to identify the culprit!

Ed Metcalfe.



Please do not feed the trolls.....

 

[istone]

thanks, I just find out that the person next to me is able to open the form without the error message, his microsoft version is 2003 and mine is 2000. Is that have anything to do with it?

 

[Ed2020]

My situation was the other way around - would open in Access 2000 but not in 2003.

Can you open the form in Design view on your PC?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

One thing you could try is exporting the form by running this from the Immediate Window:

saveastext acForm ,"formname",,"filename"

Delete the original then re-importing it by running this from the Immediate Window:

loadfromtext acForm ,"formname",,"filename"

**Do this on a copy of the database**

Ed Metcalfe.

Please do not feed the trolls.....

 

[istone]

I imported the whole database and Problem solved. thank you