5 hours ago: Our file storage provider is running maintenance today. If any videos don't load, wait a minute, refresh the page, and try again. Sorry for any inconvenience.  Dismiss
Computer Learning Zone CLZ Access Excel Word Windows

If we can't think for ourselves, if we're unwilling to question authority, then we're just putty in the hands of those in power.

-Carl Sagan
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Seminars > Work Order > Lessons
Back to Work Order Lessons    Comments List
Purchase Order Upload Images   Link   Email  
Shallena Ayers 
7 years ago
Hi Richard,  In my database i am building with  you I receive a Purchase Order from my customer... The purchase order has a list of services they need done (lets say there are 4 services... 2 tower and 2 ground type services). I enter each service into my Jobsite Total form (where you made the materials form). so i dropdown box and add each requested service with the associated price and add it to my work order. I mark each service as either a Ground Type Service or a Tower type Service. Then... i hit my Schedule Subs button which takes me to the Schedule Form that you created... and I assign a subcontractor to do the tower work and a subcontractor to do the ground work. (the same sub may do both parts of the job).  I need to be able to issue a work order to 2 different subs for the same work order... one subcontractor will do the tower work and one will do the ground work. I then need to pay each of them for their part of the work.  I have been making a serious mess of this database trying to figure out the best way to do this. My flow right now is to enter the jobsite services that have been requested... schedule the subs for each part of the job... then click a button to print a Work Order to give to each of my subs.... that contains only their part of the work and the pricing they will be paid.  I have been going back and forth with sections where you create an invoice and schedule workers and use RecordSets... I am hoping you can give me some advice on the best/easiest way to accomplish what I want to do.  If there is a video that will show me how to do what i want I am happy to purchase it... i am at the point where everything i am doing is just messing up what i have already done.... i keep telling myself STOP TOUCHING IT!  But I dont listen.  If you could point me in the right direction i would be so happy and grateful!  Thank you in advance, Shallena

Reply from Alex Hedley:

Sounds like you have most of it already set up.
Create a Query that gets the assigned services based on the assigned user and base a report on that, you can then print it out.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Work Order Lessons.


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: 7/14/2024 11:03:25 AM. PLT: 1s