Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Developer > D24 > D24 Lessons < D23 Lessons | D25 Lessons >
Access Developer 24 Lessons

Welcome to Access Developer 24 Total running time is 1 hour and 54 minutes.

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now


Database Files



Subscribe For Updates!

Students: if you want to be notified when new lessons for this class are posted, make sure you click on the SUBSCRIBE button below! You'll get an email every time a comment is posted, which I will do when I post more lessons.


Please feel free to post your questions or comments below. If you have a questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!


Copy Records Upload Images   Link  
Carl Bush 
9 months ago
Hi Oh Great one I have bought and watched Access developer 24 and as always awesome. The situation I have is I want to copy the quote to make it into a contract, at present I have QuoteT and QuotedetailsT I'm thinking I also need ContractT and ContractdetailsT.  Can I create a form for contracts and copy everything from the quote form to the contract form. The reason for this is I want to keep the original quote to refer back to, but once it becomes a contract it may be subject to change then when the job is complete I need to produce an invoice. Read More...
Juan C Rivera
9 months ago
Hi Carl, this is explained and shown how to manage in the Developer courses.  It was a case of printing an invoice but later had to update the address, and still keep the original quote for record keeping.  look in the Develop 20 and up Richard goes into greate detail as to why you may need to keep the original record.  Short answer Yes but you will need to follow the class and understand the method to his madness.

Richard Rost
9 months ago
Hi Carl. I answered your email, but I'll post what I wrote here for everyone else's benefit too: D24 is exactly what you need. You want to copy an quote and make it an invoice. That lesson shows you how to make a copy of an invoice. All you need to do following that is have a field in your OrderT that indicates whether or not it's a QUOTE or an INVOICE. That's the only difference. A Yes/No field. You don't need to separate sets of tables. If you even want to link one to the other you can. Just put an OriginalQuoteID field in the OrderT. I cover differentiating between a Quote and an Invoice in the same table in Access Expert 10, but honestly if you can understand the material in Developer 24, you probably don't need it.
Add a Reply
Sequential Numbering Upload Images   Link  
Despina Karayanni 
10 months ago
Hello Richard,
Thank you for the very instructive lesson. I have a problem. My actual invoices (i.e., the copied orders need to have sequential numbering. For example, if I issue quotations 1,2,3,4,5,6 and in future time, I close some of some of these sale proposals, lets say for the quotations 1, 3 and 6, these orders/invoices have to be numbered sequentially (forming also a separate invoice list). Can you give me a quick solution, of where to look in your courses?  Best, Despina.
Richard Rost
10 months ago
See this: Custom Sequential Number
Despina Karayanni
10 months ago
Well, I used another subform, within the orderF, with a new sequential numbering. Thank you very much!
Add a Reply
Copy Shipped Paid Upload Images   Link  
Juan C Rivera 
11 months ago
copy works real good in the lesson database only is also copys the is shipped and is paid.  So im thinking last item to do is when moved to the copy isshipped = false and ispaid = false
Richard Rost
11 months ago
Yep. Good catch!
Richard Rost
11 months ago
That is exactly what I would do. This is an easy fix. I didn't carry copying the details forward into the D25 database, so you're on your own. :)
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
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:

1/18/2022Access B2 Upgrade
1/17/2022Access Beginner 2 Links
1/17/2022Access Beginner 2
1/17/2022New Record on Top
1/13/2022Missing References
1/13/2022Access Beginner 1 Links
1/11/2022Access Fast Tips
1/11/2022System Defaults
1/10/2022Multi Select List Box

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
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access developer 24 lessons reservations copy record with children copy order with details  PermaLink