Hello group, I am a newbie to Access and VBA programming and have been struggling with a few problems I am sure is simple for this group to solve.
My database has two tables: 'Drive Test Results' containing SERIAL_NUMBER, DATE, TIME and RESULT fields among other data; 'Packing Station Scan' containing SERIAL_NUMBER, DATE, TIME, TESTED_AS_PASSED fields. All new data is entered into the 'Packing Station Scan' table via the 'SN Entry Form'.
The form is based on a query that matches the two tables based on the Serial_Number field and pulls the latest record (based on the date and time fields) for that serial_number.
The form is a continuous form working as follows: Upon scanning in the serial_number it finds the latest matching record in the 'Drive Test Results' table and displays the RESULT field (PASS or FAIL), then saves the scanned in serial number into the 'Packing Station Scan' table along with the date and time of the scan.
Here's the problems I am struggling with:
1. Upon scanning and saving the serial number the cursur jumps to the top field in the form rather than the next blank field to start a new record.
2. If no match is found, the scanned serial number is saved to the table but it is not shown on the form and does not warn the user of the failed match as it needs to do.
3. I can not get it to place the PASS or FAIL or NO Match message in the "Packing Station Scan' table.
I have attached a sample of the database if it is helpful.
Any help would be greatly appreciated!
Regards,
Kerry
My database has two tables: 'Drive Test Results' containing SERIAL_NUMBER, DATE, TIME and RESULT fields among other data; 'Packing Station Scan' containing SERIAL_NUMBER, DATE, TIME, TESTED_AS_PASSED fields. All new data is entered into the 'Packing Station Scan' table via the 'SN Entry Form'.
The form is based on a query that matches the two tables based on the Serial_Number field and pulls the latest record (based on the date and time fields) for that serial_number.
The form is a continuous form working as follows: Upon scanning in the serial_number it finds the latest matching record in the 'Drive Test Results' table and displays the RESULT field (PASS or FAIL), then saves the scanned in serial number into the 'Packing Station Scan' table along with the date and time of the scan.
Here's the problems I am struggling with:
1. Upon scanning and saving the serial number the cursur jumps to the top field in the form rather than the next blank field to start a new record.
2. If no match is found, the scanned serial number is saved to the table but it is not shown on the form and does not warn the user of the failed match as it needs to do.
3. I can not get it to place the PASS or FAIL or NO Match message in the "Packing Station Scan' table.
I have attached a sample of the database if it is helpful.
Any help would be greatly appreciated!
Regards,
Kerry
