Originally Posted by
June7
1. yes, form/subform sounds appropriate - unique ID can be generated with autonumber type field but if cannot allow gaps in sequence might need to construct custom IDs with VBA. What does "stare a masses of lines" really mean?
So the excel Worksheet view currently has around 500-700 rows of information with those column headers I outlined earlier, it's incredibly hard for someone to look at and check/verify and also prone to incorrect data input. We've had lines overwritten by accident previously which caused a huge problem thus using the forms/subforms would eliminate most of the issues. An example is Box IDs are in the format of ABC-D123456, ABC-D213456, BAC-D654321 etc along with more numbers can cause issues.
We put Box IDs into Shipment ID Groups so for example we could have 10 Box IDs in 1 Shipment ID, is it possible that our order team could just input/generate the Shipment ID first into a box then with the form add the Box ID records with the dimensions, weights in predefined columns that then feed into a master table (i.e. my Goods Expected)?
2. yes, scan gun can be an input device
I'm assuming with a bit of tweaking, our scan gun could scan in the Box IDs (lets say 200 Box IDs) and move them from one data sheet to another in quick succession? I'd play in VBA to work it out eventually like I did with Excel.
3. yes, export data to Excel or save reports as PDF
4. yes
A solid week with an introductory tutorial book could be beneficial.
Could you recommend a book that I'll purchase?