Re: It won't work after converted from 97 to 2003

"Scott" <NoSpan-Scott.Xe@xxxxxxxxx> wrote in
news:4le4reF1g50aU1@xxxxxxxxxxxxxx:

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" <rquintal@xxxxxxxxxxxxx> wrote in message
news:Xns982C8A7F6170BQuintal@xxxxxxxxxxxxxxxx
"Scott" <NoSpan-Scott.Xe@xxxxxxxxx> wrote in
news:4ldtjsF1ee0pU1@xxxxxxxxxxxxxx:

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

.