Adding a Hard Return or carriage return in an update query?

L

Lakota2k

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
 
M

MGFoster

Lakota2k said:
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-----
 
L

Lakota2k

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 said:
Lakota2k said:
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-----
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Like this:

UPDATE MONITOR
SET [New Serial No] =
[Scan New Monitor Serial Here] & Chr$(13) & Chr$(10)
WHERE SerialNo=[Scan Serial Number Here] & Chr$(13) & Chr$(10)

--
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/AwUBSM70QoechKqOuFEgEQKy1ACg7MBhuC9iEKmS8zBVuBbHB+4i21MAn2AH
dBdf88ighmU05qSzZY4fjhp1
=FbiS
-----END PGP SIGNATURE-----

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 said:
Lakota2k said:
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-----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top