K
kerry.kulakowski
Hi Folks,
I am pretty stale on Access (used several years ago but not
intensively) and need some help.
I have been given a project to convert a very rudimentary manual
process using Excel into a somewhat more efficient database program.
The process involves obtaining a series of files containing disk drive
test results. These files are loaded into a table called "Drive Test
Results" and there can be several records of drive test results for the
same drives serial number.
The disk drives that are tested as good are physically moved to a
different work station for packaging. At this work station the person
reads the serial number barcode via scanner into a serial_number field
in a table called "Packing Station Scan". I am trying to set up the
database so that when the person scans the serial number into the
"Packing Station Scan" table, the program will check the serial_number
against the "Drive Test Results" serial_number for a match. If there
is a match, the scanned serial number is saved to the "Packing Station
Scan" table and an "Approved" message is shown on the screen.
If there is NO match, the screen will post a "Rejected" message to the
user. In this case the serial number is then saved to a different table
called "Exceptions".
I have a module set up to load the "Drive Test Results" table. I'm
thinking I would like to set up a Form that allows the serial number to
be scanned in and a sub form to show the matching information from the
"Drive Test Results" table. I tried to follow the 'Create an
Autolookup Query (MDB)' thinking that would be the way to go but it
does not work.
Can anyone help me set the program to approve duplicates and notify the
user of non-duplicates? Any help would be greatly appreciated.
I am pretty stale on Access (used several years ago but not
intensively) and need some help.
I have been given a project to convert a very rudimentary manual
process using Excel into a somewhat more efficient database program.
The process involves obtaining a series of files containing disk drive
test results. These files are loaded into a table called "Drive Test
Results" and there can be several records of drive test results for the
same drives serial number.
The disk drives that are tested as good are physically moved to a
different work station for packaging. At this work station the person
reads the serial number barcode via scanner into a serial_number field
in a table called "Packing Station Scan". I am trying to set up the
database so that when the person scans the serial number into the
"Packing Station Scan" table, the program will check the serial_number
against the "Drive Test Results" serial_number for a match. If there
is a match, the scanned serial number is saved to the "Packing Station
Scan" table and an "Approved" message is shown on the screen.
If there is NO match, the screen will post a "Rejected" message to the
user. In this case the serial number is then saved to a different table
called "Exceptions".
I have a module set up to load the "Drive Test Results" table. I'm
thinking I would like to set up a Form that allows the serial number to
be scanned in and a sub form to show the matching information from the
"Drive Test Results" table. I tried to follow the 'Create an
Autolookup Query (MDB)' thinking that would be the way to go but it
does not work.
Can anyone help me set the program to approve duplicates and notify the
user of non-duplicates? Any help would be greatly appreciated.