Cannot open form

[MikeSheppard1973]

I'm a self-taught user who is trying to create a data entry form for about 10-15 users. I have a data entry form created that I was using yesterday (called "frmResponses"). The form is unbound (I run an append query when a 'Save' button is clicked to add a record to the table that collects my data).

I tried opening the form this morning and now nothing happens. The mouse pointer changes to an hourglass for about one second, then reverts to an arrow without the form opening. When I try to open the form in Design view, the same thing happens.

I have a button on another form (frmMainMenu) that opens the frmResponses form. When I click this button, I get the following error:

Run-time error '2001':

You canceled the previous operation.

When I debug this error, it points to my line of code:

DoCmd.OpenForm "frmResponses"

I don't see any issue with this line of code (it has worked for weeks). The 'Help' from MS Access is blank and I cannot find any information on microsoft.com.

There has to be something wrong with my form but I don't know what and I don't know if I can do anything with it. I am getting my file restored to a previously saved state (I'll just have to re-do what I did yesterday). I'm hoping someone knows what's going on and can lend some advice.

Thanks.

[DonRayner]

I'm a self-taught user who is trying to create a data entry form for about 10-15 users. I have a data entry form created that I was using yesterday (called "frmResponses"). The form is unbound (I run an append query when a 'Save' button is clicked to add a record to the table that collects my data).

I tried opening the form this morning and now nothing happens. The mouse pointer changes to an hourglass for about one second, then reverts to an arrow without the form opening. When I try to open the form in Design view, the same thing happens.

I have a button on another form (frmMainMenu) that opens the frmResponses form. When I click this button, I get the following error:

Run-time error '2001':

You canceled the previous operation.

When I debug this error, it points to my line of code:

DoCmd.OpenForm "frmResponses"

I don't see any issue with this line of code (it has worked for weeks). The 'Help' from MS Access is blank and I cannot find any information on microsoft.com.

There has to be something wrong with my form but I don't know what and I don't know if I can do anything with it. I am getting my file restored to a previously saved state (I'll just have to re-do what I did yesterday). I'm hoping someone knows what's going on and can lend some advice.

Thanks.

If the db is in development then it could be a bad compile on the form. You could try decompiling the database or creating a new one and importing all of your forms\tables\modules\queries...etc into it.

Don

[MikeSheppard1973]

If the db is in development then it could be a bad compile on the form. You could try decompiling the database or creating a new one and importing all of your forms\tables\modules\queries...etc into it.

Don

How do I decompile a database?

[DonRayner]

How do I decompile a database?

This works for 2002, can't vouch for any other versions of access

Go to a comman promt and enter the following. Replace Path with the path to your database and DatabaseName with the name of your db. Make sure to make a backup first.

msaccess.exe "Path\DatabaseName.mdb" /decompile

[MikeSheppard1973]

Thanks for your help!

[DonRayner]

Thanks for your help!

Glad I could help...