Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   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  Buy Now

Lessons

Database Files

Links

Resources

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.

Questions?

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 
6 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
6 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.

V/r
Juan
Richard Rost
6 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 
7 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
7 months ago
See this: Custom Sequential Number
Despina Karayanni
7 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 
8 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
8 months ago
Yep. Good catch!
Richard Rost
8 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
Access 24 Lesson 1 glitch Upload Images   Link 
James Gray 
8 months ago
At 42:35 the video stops. No real issue, you are done writing the code but there is still more verbiage from you about how to wrap it all up.  Thanks
Richard Rost
8 months ago
You are correct sir. Thank you. I don't always watch every minute of every video I post, and sometimes they glitch. I'll recompile it and re-upload it. This is why I TRY to keep the videos to around 20 minutes each. Less chance of glitching. I never do though. LOL
Richard Rost
8 months ago
OK. All done. Not sure why, but the new video is now 130 MB as opposed to 170 MB for the old one. Weird. Same length. :)
Add a Reply
Developer 24 Zip File Upload Images   Link 
Michelle Maughan 
9 months ago
Hi Richard
When will the zip file be available?
I live on a rural property with no internet and have to download the file at my office so i can watch it at home.
Cheers
Michelle
Richard Rost
9 months ago
Sorry about that Michelle. I forgot to upload it. Thank you for reminding me. So few of my students actually download them, so it slips my mind, but please do light a fire under my butt if it's not there as soon as you see the "Intro" and "What's Next" lessons posted. That means the Level is finished. I just uploaded it. Should be ready in a few minutes.

I feel bad because I just upgraded to Gigabit Internet. My transfer speeds are outrageous right now. Faster than I've ever had. I just uploaded a 346 MB Zip file in under a minute. I live in the City of Fort Myers now. I used to live in a rural area in Northwest Cape Coral until about a year ago. Satellite internet. Really slow and cut out in the rain.
Michelle Maughan
9 months ago
I'm soooo jealous!
Thanks for the file.
Add a Reply
Reservation Input Upload Images   Link 
Scott Axton 
9 months ago
I'm still working through lower level Dev courses yet but the outline caught my eye.  
Funny enough I'm working on a "room" reservation system.  One of my requirements is that a person can only book one room on a given day.  (You can't be in two places at once. Read More...
Richard Rost
9 months ago
That's a good one! I'll add it to the list for the next class. Didn't think of that. Everyone else: consider that your homework!
Juan C Rivera
9 months ago
I like this thought, can you include an override checkbox?  in case the same person needs several rooms for different events on the same day and time...lest say need two rooms one will be Access Intro  other for Access Expert. or adjoining rooms like hotel.  Mom and dad 1 room, kids get the room next door?  just a thought sounds like a good challenge.

V/r
Juan
Add a Reply
D24 Finished Upload Images   Link 
Richard Rost 
9 months ago
Developer 24 Lessons 2 and 3 are finished. We cover copying a record with it's child records. So for example, copying an order with the details.
Juan C Rivera
9 months ago
Just finished Lesson 3 by using the database developed on D23 you added a combo bot to list items on D24 if I try to do what was done on the database of D-23 I get errors.  I try to compact and restart as you sugested but does not work.  the product combo box is causing the problem.  How can I get it to work with D-23?
Richard Rost
9 months ago
Back up and walk me thru it step by step. I'm not following.
Add a Reply
D24 Lesson 1 Reservations Upload Images   Link 
Richard Rost 
9 months ago
Lesson 1 has been posted for D24. We build a reservation system into the rental database from D23. Conflict resolution is the hard part!
Timothy Smith
9 months ago
Thank you. This is right up my alley. I am looking forward to learning some more.
Add a Reply

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.
 
Subscribe
 

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

10/10/2021Copy Text from Field
10/10/2021Access for Free
10/9/2021Birthdays
10/8/2021Label Resize
10/2/2021Criticisms of Access
10/1/2021Access Developer 32
10/1/2021Groups
9/29/2021DMin
9/28/2021Track Log On
9/26/2021Sliders
 

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
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
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