We'll begin by adding the Ship Date to our
Order List Form.
We'll add an option box to the bottom of the
Order List Form to show Shipped Orders and Unshipped Orders, plus
a sort method.
We'll create a Packing Slip report showing
the items packed. You can print this out to be included with your
shipment. (Yes, I know... the screen shot here shows the report before
it was cleaned up nicely, but you should know how to do that... it's
just some simple formatting).
Next we'll make a button for handling Returns.
This basically cancels the shipment and puts all of the items on the
order BACK into inventory.
We'll write some code to deal with MANUAL
items, which are items you need to ship that aren't in your product
Next we'll make a form to collect the shipment
information, such as the ship date, method, and the tracking number.
Once we have that information, I'll show you how
you can launch a web browser to track a package with one click:
You'll learn how to launch a hyperlink to open
your web browser and look up a package on the UPS, FedEx, and
USPS web sites.
Access 327 - Course Outline
1. Shipped Orders
Add ShipDate to Order List
Show Shipped/Unshipped Orders
Sort by ShipDate
Create a Packing Slip
2. Processing Returns
Processing Cancelled Shipments
Modify OkToShip Function to Handle Adding Inventory
3. Items Not In Product Table
Shipping Orders With Products Not In Database
Notify user of manual item
Add "manual item" to packing slip
Ask user if they want to go into negative inventory
4. Shipping Form
Create ShipHowT for Shipping Methods
Add Shipping Info to OrderT
Create Shipping Form
Modal, Popup Form linked to OrderT
5. Tracking On The Web, Part 1
Figuring Out UPS Tracking Links
How are Hyperlinks Stored in Access Tables
Building a Hyperlink
6. Tracking On The Web, Part 2
Following a Hyperlink in VBA Code
Automatically Launching your Web Browser
US Mail and FedEx Tracking URLs