It won't work after converted from 97 to 2003

[Scott]

I have a simple databased developed on Access 97. Recently I converted it
to 2003 but not work on a parameter query. The program starts with a
opening form. When I press "Esc" key, it will open a form that connects to
a parameter query. The parameter query box appeared. Once I entered the
key words, it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone advise the possible
causes and fixes.

Thanks,

Scott

[Tom van Stiphout]

On Sun, 27 Aug 2006 23:55:45 +0800, "Scott"
<No*************@GMail.comwrote:
Try reversing the two lines.
-Tom.

>I have a simple databased developed on Access 97. Recently I converted it
to 2003 but not work on a parameter query. The program starts with a
opening form. When I press "Esc" key, it will open a form that connects to
a parameter query. The parameter query box appeared. Once I entered the
key words, it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone advise the possible
causes and fixes.

Thanks,

Scott

[Bob Quintal]

"Scott" <No*************@GMail.comwrote in
news:4l************@individual.net:

I have a simple databased developed on Access 97. Recently I
converted it to 2003 but not work on a parameter query. The
program starts with a opening form. When I press "Esc" key,
it will open a form that connects to a parameter query. The
parameter query box appeared. Once I entered the key words,
it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone advise
the possible causes and fixes.

Thanks,

Scott

By foutrh line, I assume you mean DoCmd.OpenForm "frmTechInfo"
try to open frmtechinfo in design mode. find the recordsource
property of that form. It will be your parameter query.
Run the query by double-clicking it.

Does it run, or give you an error message?

Report back here.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Scott]

Tom,

I tried to reverse the two lines. Both form boxes appeared on the same time
but the highlighted line moved to third line and the same issue happened.

Scott

"Tom van Stiphout" <no*************@cox.netwrote in message
news:cj********************************@4ax.com...

On Sun, 27 Aug 2006 23:55:45 +0800, "Scott"
<No*************@GMail.comwrote:
Try reversing the two lines.
-Tom.

>>I have a simple databased developed on Access 97. Recently I converted it
to 2003 but not work on a parameter query. The program starts with a
opening form. When I press "Esc" key, it will open a form that connects
to
a parameter query. The parameter query box appeared. Once I entered the
key words, it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone advise the
possible
causes and fixes.

Thanks,

Scott

[Scott]

Bob,

Your assumption is correct. Once I pressed "Esc" button and the form
opened. As the form is linked with a parameter query, the parameter query
box appeared. I entered the key word and hitted the Enter button. The
error message came on.

Scott

"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn*********************@66.150.105.47...

"Scott" <No*************@GMail.comwrote in
news:4l************@individual.net:

>I have a simple databased developed on Access 97. Recently I
converted it to 2003 but not work on a parameter query. The
program starts with a opening form. When I press "Esc" key,
it will open a form that connects to a parameter query. The
parameter query box appeared. Once I entered the key words,
it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone advise
the possible causes and fixes.

Thanks,

Scott

By foutrh line, I assume you mean DoCmd.OpenForm "frmTechInfo"
try to open frmtechinfo in design mode. find the recordsource
property of that form. It will be your parameter query.
Run the query by double-clicking it.

Does it run, or give you an error message?

Report back here.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Bob Quintal]

"Scott" <No*************@GMail.comwrote in
news:4l************@individual.net:

Bob,

Your assumption is correct. Once I pressed "Esc" button and
the form opened. As the form is linked with a parameter
query, the parameter query box appeared. I entered the key
word and hitted the Enter button. The error message came on.

Ok, you ran the form, which triesd to run hte query. Did you run
the query without the form.

It could be that the query failed to convert, the form which
failed to convert, or the form used code or a macro that failed
to convert.

Run the query without the form.
Also open the form in design view, open the form's code module
and try to compile it.

Scott

"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn*********************@66.150.105.47...

>"Scott" <No*************@GMail.comwrote in
news:4l************@individual.net:

>>I have a simple databased developed on Access 97. Recently
I converted it to 2003 but not work on a parameter query.
The program starts with a opening form. When I press "Esc"
key, it will open a form that connects to a parameter query.
The parameter query box appeared. Once I entered the key
words, it failed and display the following error.

Run-time error '2501':
The OpenForm action was canceled.

When click Debug button, it showed

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = 27 Then

DoCmd.Close acForm, "frmContributor", acSaveYes
DoCmd.OpenForm "frmTechInfo"
Else
Beep
End If

End Sub

The fourth line was highlighted in yellow. Can someone
advise the possible causes and fixes.

Thanks,

Scott

By foutrh line, I assume you mean DoCmd.OpenForm
"frmTechInfo" try to open frmtechinfo in design mode. find
the recordsource property of that form. It will be your
parameter query. Run the query by double-clicking it.

Does it run, or give you an error message?

Report back here.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com