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

Lessons

Database Files

Resources

Full Course Description Page
Topic Outline
Handbook PDF - Coming Soon
Video ZIP File (346 MB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

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

V/r
Juan

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.

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!

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. :)

Show Older Comments...
View in Table Format

Lessons

Database Files

Links

Resources

Subscribe For Updates!

Questions?