Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Tips   Templates   Forums   Help   Order   Contact   Logon  
Access Work Order Seminar
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4/23/2010 2:51:00 PM

Microsoft Access Work Order Seminar
Build a Database to Run Your Service Business
12.5 Hours

Although the title of this course says "Work Order Seminar," it's much more than that. You will learn everything you need to build a database to run a service-oriented business using Microsoft Access.

This seminar has several main goals. You will:

1. Track customers with multiple locations
2. Generate work orders with unlimited categories
3. Schedule employees and subcontractors, avoiding conflicts
4. Track job costs, including materials and labor
5. Invoice your customers, and calculate sales tax
6. Design a comprehensive Search Form to find records
7. Create printable reports for your business

Click here for more information

dbl clk Link 
you don't need to check because your picking a Value when you dbl clk the list box so can't eliminate the IF statement in the dblclk event?

Reply from Alex Hedley:

If memory serves its because you can double click a list box without actually having a selected/highlighted value so this is in place to make sure a value is passed to the necessary part. Read More...
Add a Reply
GED Test Link 
Brian Merrick 
I am creating a student database to track their GED test. There are 4 test and i need a form with student name and a list box to display the subject they took and date it was taken.  I created a student table and a subject table. Ged math, Ged science and Ged writing and social studies.  I also created the form with the student name a list box. Read More...
Add a Reply
Search for Quotation Marks Link 
Vincent Dyas    
Hi Richard
In the UK we often use the " symbol to mean inches. so a 2 inch pipe can be named 2" pipe for example.

When using your code reproduced below , Access returns an error when looking for something that has " as part of its name. Read More...
Add a Reply
Hours to hh mm Link 
Rene v 
how to get nummer Hours 21.25 to 21:15
in the Form LaborF

Reply from Alex Hedley:

What Format are you trying?
Add a Reply
Purchase Order Link 
Shallena A 
It wont create the query correctly, everything shows up double or triple

Reply from Alex Hedley:

Sounds like a Cartesian product to me.
Add a Reply

Show Older Posts


Post Your Comments
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

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

6/30/2020Access Seminars
6/29/2020Access Create Duplicate Record
6/28/2020Access Times as a Duration
6/25/2020Access D14 Lessons 2, 3 Ready
6/20/2020Access Developer 14
6/17/2020Access Time 12 hour NO am/pm
6/16/2020Access Handbook News
6/16/2020Access Developer 7 Handbook
6/7/2020Working on Access Dev 14
6/6/2020Access Beginner Level 1

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
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 The Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Page Tag: whatsnew  PermaLink