Hi Everyone,
Background:
I have worked really hard (3 months) on creating an Access form that is going to be used in production. This form captures a data matrix bar code in one text field and splits the information into 20 text boxes (that feed 20 columns in an Access table). There is a lot of validation, coloring etc that I have built into the form that I do not want to lose.
However, my boss's boss has come up with an idea that the form is to be accessed via RDP on a scanner. Apparently this was a requirement from the beginning but my boss conveniently ignored it and now, he has exited the company, leaving me holding the project.
Problem:
To fit all the fields, my only option is to break up the fields into logical components,
Form 1: Coil attributes (Product ID, Heat#, Supplier #, Steel #, Bill of Lading, Quantity Received),
Form 2: Physical properties (weight, yield strength, tensile strength, elongation, gauge, width and 2 types of coating thickness) and
Form 3: Chemical properties (Carbon content, Phosphorous content, Sulphur Content, Manganese content, Silicon content and Aluminium content)
To achieve this and still have only 1 piece of data entry via that text field that accepts the data matrix bar code, will it be enough to copy all the controls to other forms that are called up with a "Next" control? Or is there a way to create tabbed data entry on the current form? Either ways, I need to update the record once all the fields are checked by the data entry operator.
Please help. I need to have this up and running soon and its double the pressure as my Boss is not around any longer to take the flak for his omission. No - there is no scope of asking for more time as there is a big "test" of the system next week.
Regards,
Manoj