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 
Matt 
2/10/2019
10:40
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 
8/9/2018
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    
8/31/2017
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 
6/26/2017
how to get nummer Hours 21.25 to 21:15
in the Form LaborF


Reply from Alex Hedley:

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


Reply from Alex Hedley:

Sounds like a Cartesian product to me. Read More...
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.
 
Subscribe
 

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
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
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