Good afternoon,
I work at a factory where we produce printing plates. My boss wants me to figure out a way to make it easier for our proofreader to fill out invoices. After asking my roommate and going through quite a few other possibilites, I have decided that the best option would be to make an Access Database and use VBA code to fill out a form depending upon a specific reference number.
The problem I am having now is that I can't figure out what code is needed to properly insert the reference number. My database is going to be somewhat like this:
Ref # - Company Name - Contact Name - Plate Size - Plate Material
The Ref # will serve as the Primary Key, and each key represents a different company, contact, plate size, and plate material.
If anyone can help me out, I would be very grateful.
Thanks,
Kevin
I work at a factory where we produce printing plates. My boss wants me to figure out a way to make it easier for our proofreader to fill out invoices. After asking my roommate and going through quite a few other possibilites, I have decided that the best option would be to make an Access Database and use VBA code to fill out a form depending upon a specific reference number.
The problem I am having now is that I can't figure out what code is needed to properly insert the reference number. My database is going to be somewhat like this:
Ref # - Company Name - Contact Name - Plate Size - Plate Material
The Ref # will serve as the Primary Key, and each key represents a different company, contact, plate size, and plate material.
If anyone can help me out, I would be very grateful.
Thanks,
Kevin