This relates to the DB I'm creating for tracking Library shipments.
Please let me know if I'm barking up the wrong tree.
I have a form in which the user is entering data. The Items Process
Table is used for just this step and will be cleared afterwards. After
they finish entering the data, four steps need to be completed before
the process is done, maybe in the form of Buttons that can be clicked to
carry out the required function. I'd also like to have the Buttons
appear only if the previous steps have been completed.
1. Open the Shipment form to enter Date Shipped, Tracking Number, and
Shipping Receipt Number. The Received date and Returned date will need
to be entered after those occur.
2. Run a Report on the Items just entered with a Box Number that
concatenates the Date Shipped field from the Date shipped table and the
Collection field in the current Form/Table. There should also be options
to Print and Save to a Word file.
3. Export the Report to Excel.
4. A Button that will run an Append query that will Append the Items
from the Process table to the Items table. This would also have to
delete all the Items from the Process table.
I want to do it this way so that the user can start entering data for
filling the current box and be able to stop and return later to finish.
If the user is entering the data into the Table that already holds Items
already processed, then the process gets even more confusing.
is any of this possible or am I just in a massive DB dream?
I surely appreciate any previous assistance and will hold any
forthcoming help in equal regard.
John
Tidak ada komentar:
Posting Komentar