hnunez4399
Programmer
Hello, I have a form that is based on a query. it is not giving enough time to look up the data when scanned in via scanner.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
form not updating 1
- Thread starter hnunez4399
- Start date
- Status
-
1
- #2
- Thread starter
- #3
hnunez4399
Programmer
When the form opens it goes right to the field called "UPC" at that point you scan the barcode and it enters it. its supposed to go to the next new record but it errors out.
if I manually copy past or key it in there is no problem.
if I manually copy past or key it in there is no problem.
- Thread starter
- #5
hnunez4399
Programmer
Rollie, here is what I have set up when the form opens as far as events. I think maybe something in these is wrong. I am new to this and macros.
events set up on the actual form properties
on open runs a macro to open the form
on activate runs macro go to record new
on got focus runs macro go to control "upc"
events set up on field "UPC" in this form
on change runs macro send keys i put in here ^ ^
on key press runs macro to go to record new.
Please let me know if something here might be wrong.
When I do the copy past from the keyboard it takes it
but when I scan when scanner it errors out on me
The upc field is 12 characters and that is how many characters is in the barcode.
Please let me know if I have to make any changes.
This form is based on a query
events set up on the actual form properties
on open runs a macro to open the form
on activate runs macro go to record new
on got focus runs macro go to control "upc"
events set up on field "UPC" in this form
on change runs macro send keys i put in here ^ ^
on key press runs macro to go to record new.
Please let me know if something here might be wrong.
When I do the copy past from the keyboard it takes it
but when I scan when scanner it errors out on me
The upc field is 12 characters and that is how many characters is in the barcode.
Please let me know if I have to make any changes.
This form is based on a query
- Thread starter
- #7
hnunez4399
Programmer
no the scanner works fine. If I take out the last two macros the data comes in fine through the scanner. when I add the last two macros it trys to go to the new record before it finishes doing the look up. There has to be something I change to tell it to wait until the 12 characters are in and then tab down for a new record.
It puts in the first record it finds in the look up which is wrong.
Can you help
It puts in the first record it finds in the look up which is wrong.
Can you help
- Thread starter
- #8
hnunez4399
Programmer
Rollie after doing more trouble shooting this is what I found out. The minute I press a key it defaults the first record that is in the look up table and goes to a new record. I think because when I do a copy paste in to the field in consinders it 1 change and goes to a new record.
when I key it in or use the scanner the minute the first charater comes in it just tabs down. I think its because I have the event of on change set up and that might be why... what you think i need to change
when I key it in or use the scanner the minute the first charater comes in it just tabs down. I think its because I have the event of on change set up and that might be why... what you think i need to change
- Thread starter
- #10
hnunez4399
Programmer
Rollie I just sent it.
Let me know what you see as the problem I also put another question on the email
Let me know what you see as the problem I also put another question on the email
- Status
