Continuely Scanning Barcode Data into Access

[Deborah Najm]

Hi,

I have a database with ESN Numbers. I have query that prompts for the ESN,
when you scan in the ESN Number, it will update the record with the current
date.

However after the record updates, the window closes and you have to click on
the query again to open up the prompter.

At the end of the update, I would like the window with the prompt for the
scan to open again.

I think I need a macro that calls the query in a looping fashion, but I
don't know how to do this.

Any help would be appreciated.

Deb

 

[Guest]

close.
I would create a small form. this will stay open untill
you close it. if all you have is an ESN then it would only
have 1 text box.(simple form) i would put your query to
run in the text box's after update event. and add code to
clear the text box after the query ran and to set focus on
the text box. i would remove the prompt from the query and
replace it with this:
[Form]![yourform]![textbox1]
this way what ever is zapped into the text box will be the
querys criteria. this way you would be able to input ESN's
as fast as you could zap them.
sub inputESN()
docmd.openquery "yourquery",accviewnormal
me.textbox1 = null
me.textbox1.setfocus
end sub
good luck.

 

[Deb Najm]

You've got me there, but I think I am making a mistake somewhere.

When I enter the ESN in the form -- the query prompts me for the value of:
[Form]![Scan ESN]![textbox1]

I've tried using both the '!' and '.' to define the form variable....what am
I missing??

Thank you for your help.

close.
I would create a small form. this will stay open untill
you close it. if all you have is an ESN then it would only
have 1 text box.(simple form) i would put your query to
run in the text box's after update event. and add code to
clear the text box after the query ran and to set focus on
the text box. i would remove the prompt from the query and
replace it with this:
[Form]![yourform]![textbox1]
this way what ever is zapped into the text box will be the
querys criteria. this way you would be able to input ESN's
as fast as you could zap them.
sub inputESN()
docmd.openquery "yourquery",accviewnormal
me.textbox1 = null
me.textbox1.setfocus
end sub
good luck.

-----Original Message-----
Hi,

I have a database with ESN Numbers. I have query that prompts for the ESN,
when you scan in the ESN Number, it will update the record with the current
date.

However after the record updates, the window closes and you have to click on
the query again to open up the prompter.

At the end of the update, I would like the window with the prompt for the
scan to open again.

I think I need a macro that calls the query in a looping fashion, but I
don't know how to do this.

Any help would be appreciated.

Deb


.