View Single Post
  #4 (permalink)  
Old October 2nd, 2003, 08:06 PM
jammykam jammykam is offline
Registered User
 
Join Date: Oct 2003
Location: , Surrey, United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your replies. I can code in VBScript and have picked up a little VB/VBA in the past few weeks, but mainly stuff thats largely similar.

Greg, the bar code reader simple picks up the number as if you were typing it yourself and then goes to the next input box. So in essence it is just a string.

I'm gonna give this code a go. This was my initial feeling and looks like it should work. I was just hoping there was a smarter way of doing it. I was just a little worried about speed of running this routine because when these numbers are scanned in they are piled in batches. Sometimes there are 10,000 units per job (these are mobile phones for import/export by the way) and the databse will start getting very big after a while. Suppose could split it down further by having a different database for each different type of phone.

Anyone know how many records it takes to mess up the performance of Access (assuming following table structure) or des that depend on the speed, memory etc of the computer you are running it on.

tbl_Serial
-----------
Serial_ID
Serial_No
Job_ID

tbl_Jobs
-----------
Job_ID
Job_Ref#
Customer_Name
Date


Thanks for you help.

Kam