Ok Here is the question..
I am running an update querry that is being called from a button in a form.
The query askes the user 2 questions?

Please enter the old serial number

then
Please enter a new serial number

Here is the catch:
I am asking these questions that will be answered by using a symbol scanner
and barcodes.
The scanner is attached to a tablet pc so adding an automatic hard return or
carriage return after the client has scanned the barcode would allow them to
keep scanning without having to stop scanning and use a pen tool to hit the
enter key.
The code looks like this:

UPDATE MONITOR SET MONITOR.[New Serial No] = [Scan New Monitor Serial Here]
WHERE (((MONITOR.SerialNo)=[Scan Serial Number Here]));

Is it possible to add a return after each question?
Thanks

Chris

MGFoster:

Thanks for the answer but it leads me to one more question..

Where in the heck do I put that code?

I tried in a few locations but im not getting very far with it.

Any additional assistance would be greatly appreciated..

Chris


"MGFoster" wrote:

> Lakota2k wrote:
> > Ok Here is the question..
> > I am running an update querry that is being called from a button in a form.
> > The query askes the user 2 questions?
> >
> > Please enter the old serial number
> >
> > then
> > Please enter a new serial number
> >
> > Here is the catch:
> > I am asking these questions that will be answered by using a symbol scanner
> > and barcodes.
> > The scanner is attached to a tablet pc so adding an automatic hard return or
> > carriage return after the client has scanned the barcode would allow them to
> > keep scanning without having to stop scanning and use a pen tool to hit the
> > enter key.
> > The code looks like this:
> >
> > UPDATE MONITOR SET MONITOR.[New Serial No] = [Scan New Monitor Serial Here]
> > WHERE (((MONITOR.SerialNo)=[Scan Serial Number Here]));
> >
> > Is it possible to add a return after each question?
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Yes. But the new line can be 2 characters (MS systems) or 1 character
> (*nix systems, etc.). For MS systems use the characters Chr$(13) &
> Chr$(10) (that's CR & LF). For the *nix, etc. systems use the Chr$(13)
> character.
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
> ** Respond only to this newsgroup. I DO NOT respond to emails **
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBSMtUTIechKqOuFEgEQK/qwCfTeYsKWWgLtwSf5WtJUKrSs007poAoMHq
> APqHnIVzvtoM2mu7ALDb7nlZ
> =D6vv
> -----END PGP SIGNATURE-----
>