Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
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.


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




The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/15/2024 2:46:29 AM. PLT: 0s