R
robin b via AccessMonster.com
Hi, another newbie here. I've gotten so much out of this site that it is the
first place I go now for any questions, but this is my first post. I have a
form called starttransaction. This form has a subform called newtransaction.
What it does is it brings up the employee that you query and starts a new
form for that employee to scan a barcode and enter a transaction. It parses
out the work order number, the operation (all based on pieces of the
workorder) like this.
Me!Operation = Mid(Me![WorkOrder], 11, 4)
Me!WorkOrder = Mid(Me![WorkOrder], 5, 6) (#2)
This is all done via a barcode scanner.
Now based on the Me!WorkOrder #2 I would like to bring up a part description
which is held in table DailyTransactions. This is a linked excel spreadsheet
that is run every morning showing what transactions are in the system and
what part it is linked to. I need to fill in the subform field Part with
this data when the workorder number is scanned. I don't even know where to
start! Sorry if this is confusing, but thanks for any help.
first place I go now for any questions, but this is my first post. I have a
form called starttransaction. This form has a subform called newtransaction.
What it does is it brings up the employee that you query and starts a new
form for that employee to scan a barcode and enter a transaction. It parses
out the work order number, the operation (all based on pieces of the
workorder) like this.
Me!Operation = Mid(Me![WorkOrder], 11, 4)
Me!WorkOrder = Mid(Me![WorkOrder], 5, 6) (#2)
This is all done via a barcode scanner.
Now based on the Me!WorkOrder #2 I would like to bring up a part description
which is held in table DailyTransactions. This is a linked excel spreadsheet
that is run every morning showing what transactions are in the system and
what part it is linked to. I need to fill in the subform field Part with
this data when the workorder number is scanned. I don't even know where to
start! Sorry if this is confusing, but thanks for any help.