Access Developer 24 Lessons

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

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
3 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
3 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
3 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
4 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
4 months ago

See this: Custom Sequential Number

Despina Karayanni
4 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
5 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
5 months ago

Yep. Good catch!

Richard Rost
5 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. :)

Access 24 Lesson 1 glitch Upload Images Link
James Gray
5 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
5 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
5 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. :)

Developer 24 Zip File Upload Images Link
Michelle Maughan
6 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
6 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
6 months ago

I'm soooo jealous!
Thanks for the file.

Reservation Input Upload Images Link
Scott Axton
6 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
6 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
6 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

Show 14 More Replies...

Richard Rost
6 months ago

Challenge accepted. Sounds like a good project, and a learning experience for all.

Scott Axton
6 months ago

Richard & Juan - I like the over ride.  I'm working with over 50 different locations with any where from 1 - 5 "rooms" per location.
That makes it real fun to work through.  Not too terrible though with proper table structure and relationships.
Even more challenging is that each one is available only certain days of the week.  Some are 7 days, some M-W-F, some Tues-Thur-Sat., etc.  I'm glad there is only 7 days in a week!
It's definitely been an interesting project.

Richard Rost
6 months ago

More great ideas. :)

Juan C Rivera
6 months ago

Can you do the product planner into this also I lke the birds eye view of a given start date with end date to see whats available at that given time??????
Am I asking to much?

V/r
Juan

Richard Rost
5 months ago

I'll do my best. I'll probably release a version 1.0 first and then you guys can tell me what more to add to it after.

Michelle Maughan
2 months ago

Hi Richard
Is there a way to move the reservations to the rental history once the end date has passed?
Cheers
Michelle

Scott Axton
2 months ago

Michelle -
One thing Ive learned about Access is any time someone asks "is there a way to do x" they are almost always asking the wrong question. The answer to that one is almost always - Yes.

The better question then becomes "how do I".  You pretty much answered that in the question you asked. LOL

For this time, it would be pretty easy (in my mind any way).  First create a copy of the tables you are wanting to archive the history of  - such as ReservationHistoryT copy the structure only.  Modify the new table change the Id field from Auto Number to Long Integer and add a new Id field that is auto number.

Then it is just a matter of appending ( "moving" ) the data to the history table and then delete it from the original table.

I see you are a Gold Member as well as in the Developer Level so check out the Don't Delete Data Tech Help.
Richard covers this in detail.
Here is the link:   https://599cd.com/blog/display-article.asp?ID=1410

Scott Axton
2 months ago

Just a quick addendum.
You might be better off to just mark records "Completed" or what ever you choose to call it.
Unless you're getting to large size wise or there is so much data it is just slowing things way down to have the historical data in the same table, reporting etc is much easier not creating a history table.

History and current tables can be joined in the future using a UNION Query BUT fields have to match exactly and require a pretty advanced level of SQL knowledge.  (I'm not quite there yet)  This hasn't been covered yet in depth in the courses other than the SQL Seminar - Which is a MUST in my opinion.
Something to consider...  I'm sure others will chime in.

Richard Rost
2 months ago

I love everything Scott just said. :)

Michelle Maughan
2 months ago

H Scott
Thank you and your dead right, stupid question.
I know there is a way, I just don't know how.
I might be in the Developer level but I am certainly not a developer. I just follow along the lessons and sometimes the penny drops. I love Access and Richard's lessons.
I think your right about just marking completed.
I will check out the SQL Seminar, I've got just about all the others.
Thanks again
Michelle

Scott Axton
2 months ago

Michelle -

Not a stupid question at all. I was just trying to get you toward the 'critical thinking' part of working things out.
The extended cut of the Don't Delete video above takes you through the how step by step.

Don't get discouraged just keep on keeping on. The most valuable lessons (and most satisfying) are the ones where you work through the problem and come up with the solution yourself. It is those sessions that you also remember the best.

Best
Scott

Michelle Maughan
2 months ago

Hi Scott
I'm certainly not discouraged. Sometimes I do manage to put the leggo blocks together and it feels great.
Cheers
Michelle

Richard Rost
2 months ago

It's kinda like how I differentiate between a Quote and an Order in my regular lessons. It's literally just a y/n field. The only time I ever bother using an archive table is if the primary table is getting HUGE and you don't want to lose the old data, but you need to shrink your database size. I keep ALL old customer correspondence in an EmailT however it was getting close to the 2 GB limit, even as a single-table database file. So, I broke it up and I archive all of the old stuff. I almost never have to go back more than a couple of years for an old email.

Michelle Maughan
2 months ago

Thanks Richard, I am just going to have an IsPaid yes/no, which will suit my needs just fine.

D24 Finished Upload Images Link
Richard Rost
6 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
6 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
6 months ago

Back up and walk me thru it step by step. I'm not following.

Show 4 More Replies...

Juan C Rivera
6 months ago

Richard,
Hold on I will tuck this project away and restart over - I will learn from my mistakes.
I am thinking the as the stubborn person I am - I will not give up. I am going to start from scratch and master this beast.
I started with the 1 hour long tech vid and continued to use the database through D-24 not starting a new database but build on it. trying to get it to work as we move through the lessons. So if it's ok with you, give me a month or two and at that time I will say got it or help me....I have so much fun doing this good thing it's just for a hobby if my job depended on this I will be unemployed LOL.
V/r
Juan
Live Long and Prosper

Richard Rost
6 months ago

Ok. Do your thing. Let me know if you need help.

Juan C Rivera
5 months ago

Richard, I'm gonna quote you
BOOM
everything works as advertised. I found about 7 things I did wrong. 1st is the keyboard is too small I fat finger a lot.
the rest was spelled in spanglish. You code is solid!

V/r
Juan

Richard Rost
5 months ago

Party on, Wayne.

D24 Lesson 1 Reservations Upload Images Link
Richard Rost
6 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
6 months ago

Thank you. This is right up my alley. I am looking forward to learning some more.

Lessons

Database Files

Links

Resources

Subscribe For Updates!

Questions?