Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
Courses - Microsoft Access 327
Description: Advanced Access Recordsets
Running Time: 77 minutes
Pre-Requisites: Access 326 very strongly recommended
Previous Lesson: Access 326
Next Lesson: Access 328
Main Topics: Packing Slips, Cancelled Shipments, Shipping Form, Track a Package on the Web
Versions: This course is valid for Access 2000 through 2003. If you are using Access 2007 or 2010, you will still benefit from this course. You will find that the concepts are the same, but there are cosmetic differences between the versions.


Order before 4/28/2019 to get a FREE upgrade to our Access 2010 version!
Click here for details


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 table.


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



Student Interaction: Microsoft Access 327

Richard on 1/1/2008:  Shipped orders, Processing returns, Items not in product table, Shipping form, Tracking on the Web
Len Jolly on 1/2/2012: Hi Richard
I have just finished 327, really enjoyed it. However there are a couple of points I need help on. If I return an order and refund payment. The unwanted order still sits there. How can I delete it? Also how can I ship an order that has not been paid for? remembering that way back we setup credit terms for customers. Regards

Reply from Richard Rost:

The point is that you don't want to delete old orders. Mark them inactive (or change them back to quotes if you want) but keep the data JUST IN CASE. Shipping an order that isn't paid for is just a matter of changing the logic in your VBA.

Richard Lanoue on 9/15/2014: Yes I would like to see partials...

Matthew Pattison on 11/4/2014: I would like to see partials too


Spiros Poulis on 5/6/2016: I would like to see partials too Thanks


You may want to read these articles from the 599CD News:


Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP