Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   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
PackingSlipButton

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.
 

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

LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 9/23/2023 12:49:11 AM.