I am trainning myself to thumb up from the beginning of class instead of the end so that I won't forget. Richard is a hardworking, dedicated, detailed oriented, intellectual teacher. We are blessed. Thank you Richard for sharing your knowledge to the world.
@599CD Жыл бұрын
Thanks! :)
@steppercutiemomma Жыл бұрын
OMG I did it! I cannot tell you how amazingly easy your videos are to follow. I know Excel inside out but just couldn't grasp the concept of Access, then I started watching your videos. I just built my first database and I am so proud of myself - THANK YOU!!!!
@599CD Жыл бұрын
Great to hear!
@souffoue6 ай бұрын
Thank you so much! This is exactly what I need to keep track of invoices and payments for our outside employees. I spent hours today trying to figure it out before I came across your channel.
@user-zo8gf7im6v Жыл бұрын
I started with Access 1.0 on FLOPPY DISK back in the 90's! I've been away from it for many years, but my current job needs those skills. Your video's have been great to get me back into Access. You're easy to follow, provide great tips in every video, and a great teacher! Thank you so much!
@599CD Жыл бұрын
If you started with Access version 1 then you've been using it longer than me. I started with version 2.0 back in 1994, I believe. Before that I was actually trying to build databases for clients using C. That was tough.
@DavidWilliams-wj4sc2 жыл бұрын
Just started watching the Level 1 and 2. Moving a large Anaplan DB to Access. Not that happy about it, but happy I found these videos.
@599CD2 жыл бұрын
Get happy. Access is amazing.
@burnts0x2 жыл бұрын
Thank you. Subforms are so much easier than an explicit query, but I just wasn't getting it until I watched this video... while working through your sample template. Earlier today I tried to engage CLZ to consult on my database. Instead, with just a few hours invested in sorting through it, I think I'm a lot farther along. Thanks. Great instruction - your enthusiasm helps so much!
@599CD2 жыл бұрын
You're very welcome. Glad you enjoyed.
@anandmallikarjunan7775 Жыл бұрын
Hello Sir, Good morning! Revising your video as being forgotten. Thanks for posting your videos. Wish you good luck.
@Oderick99 Жыл бұрын
Really helpful information well delivered. Thank you. I am re learning Access after a 10 year hiatus.
@599CD Жыл бұрын
Welcome back
@user-zw4ke1qv6o Жыл бұрын
Your video's have been a great help to me. You're easy to follow, provide great tips in every video, and a great teacher! Thank you so much!
@599CD Жыл бұрын
You're very welcome!
@xunchafaraidun59979 ай бұрын
You just saved my job and my life several times. THANKS ALOT :)
@599CD9 ай бұрын
You are welcome!
@Khes76 Жыл бұрын
This is superb. I'm working on a few things to make my life easier, and this might be the right track.
@StephenRoberts33309 Жыл бұрын
love the way you explain access, as a newbie.
@599CD Жыл бұрын
Thanks
@ehabelshami26872 жыл бұрын
Excellent and clear explanation. Perfect
@599CD2 жыл бұрын
Thanks
@ZahidKhan-mb6oc2 жыл бұрын
Very useful information, a great addition to the knowledge about sub forms.
@599CD2 жыл бұрын
Thanks
@dolittlediehard1670 Жыл бұрын
I believe the outer form is a customer order form but just contains all of the customer's details. The first subform is an order form with a date and order id and then this subform contains a subform with all the orderlines. The form is three layers deep.
@599CD Жыл бұрын
K
@jamescbynum Жыл бұрын
Great information!!
@wacelhamani4 ай бұрын
Good Job
@billadenilesh53472 ай бұрын
How to filter subform using multiple values selected in listbox
@Cat_sad249 ай бұрын
very interesting video I watch from Pakistan
@599CD7 ай бұрын
Thank you from Florida
@ahmadzafar50513 ай бұрын
I am doing the census of my neighborhood in access. The main form contains the details of the head and the sub-form contains the details of the household. The names of those who have more than seven people in their household are not showing while taking out the print
@599CD3 ай бұрын
599cd.com/ask
@englishclarkfamily5239 Жыл бұрын
I love your videos.
@599CD Жыл бұрын
Thanks
@spiritlynxs8 ай бұрын
I am following your video, however when I view the form after creating it it just fills the entire window. Like wise my form design view does the same, the scroll bars are at the edge of the screen or window. What am I doing wrong? Also I don't get the dots between my grid lines in design view
@599CD8 ай бұрын
599cd.com/grid 599cd.com/overlap
@zacharyeades9423 Жыл бұрын
Hi there! Love these videos and I have found them SOO useful! Thank you! I'm curious if there is a way to take a dollar amount displayed in a master form and subtract a number from a subform and them display the result in the master form. I hope this makes sense. Thanks in advance for the help! -Zach
@rabidfollower2 жыл бұрын
I often set a subform's Tab Stop property to No, so the user will stay on the main form if he keeps pressing Tab. If he presses Tab while on the last text box, he will go back to the first text box on the main form, which I think is what most users expect to happen. If the subform's Tab Stop is Yes (default), the cursor will be stuck inside the subform eventually, and it's hard to tab back out. When Tab Stop is No, and the user can only get into a subform by clicking on it. Also, when you tab onto a command button, it's hard to see the "cursor" and the user may get confused if he expects the cursor to go to the next text box. So I set Tab Stop to No for command buttons too. In fact, I set Tab Stop to Yes only for things the user types on: text boxes, combo boxes, etc.
@599CD2 жыл бұрын
I usually do the same in finished databases. Great minds...
@linkmasterquest7 ай бұрын
One question, how can I change the employee ID to Combo box? I would like to have a combo box instead of clicking on right.
@599CD7 ай бұрын
599cd.com/ask
@krishnakumar81922 жыл бұрын
Great, Thank You 🙏🏻
@599CD2 жыл бұрын
Welcome
@moodkn2 жыл бұрын
Thanks! Very Helpful
@599CD2 жыл бұрын
Glad it helped!
@andresjarrin7520 Жыл бұрын
Hi, thanks for all this videos, are awesome, please one question, why the access search button does not work on that subforms? I google it, a lot, but I can't find an answer, I just want to find a record on any part of a field on the subform. maybe a video where you did that? thanks for your help
@bee-wv2jr8 ай бұрын
true legend
@599CD8 ай бұрын
Appreciate that
@john-lenin10 ай бұрын
Can a subform be designed in the same was as a master form - rather than just looking like a list of records?
@599CD10 ай бұрын
Sure you don't have to use a continuous form for the subform you can use a single form if you want to
@uniQue_XL2 жыл бұрын
Thanks! Is there a way to make the system work online, in which multiple users can work together from differant locations?
@599CD2 жыл бұрын
599cd.com/AccessOnline
@uniQue_XL2 жыл бұрын
@@599CD Thanks!!
@daygeckoarthawaii1360 Жыл бұрын
No matter what method I use to add a datasheet form as a subform, it gets converted to a form view! I can even set it so that form view isn't allowed, but it still is stuck as form view.
@jamesowusu8245 Жыл бұрын
Great presentation. Thank you Please i need your help I created two forms from two different tables. i want to enter only the PatientID from the first form so all the remaining patient details will be filled in the second form. How can i do that? i will be grateful if you can help me.
@599CD Жыл бұрын
599cd.com/Ask
@JoseLopez-wx1xi Жыл бұрын
I came across a weird situation. I followed your instructions exactly and it seems to be working but the issue i am having would be the following. When I click on the Employee form to go to the next record it appears that it is pulling up the multiple records in the mileage form. So if there are four records in the mileage form i have to click next 4 times in the employee form so it goes to the next records. So on your employee form you have 3 records and hit next 3 times and you have gone through all the records. In my scenario I would have to hit next and if there are multiple records in the mileage form its as if it creates a phantom record in the employee form that i have to hit next on. Hope that made sense.
@599CD Жыл бұрын
I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT
@artistryartistry72392 жыл бұрын
Hi Richard, for the Gold membership which offers "One FREE Expert Course Per Month" we have to create a user account on your website? And Do we have to sign up to your site with a credit card, or do you just offer us access to the courses based on the youtube Gold membership?
@599CD2 жыл бұрын
You get one free course per month up to the Expert level, in order. You can sign up on my web site directly or here on KZbin. Either way, you'll get an account on my web site where you can watch your free classes.
@abdulhamidalhaddadi22552 жыл бұрын
Thank you so much
@599CD2 жыл бұрын
Welcome
@nealdorelis57032 жыл бұрын
Can people use the exchange rate automatically connected to another site in access and that the new rate does not affect the old month price conversion???
@599CD2 жыл бұрын
Sure
@alializadeh8195 Жыл бұрын
Thanx
@Tertiaryspotlightmedia5 ай бұрын
Please I’m on a project of creating a database for my department in Tertiary school It will be used to all records of the department ,Students registration, executive’s activities and others however I’m finding difficult in creating relationship so that each student will have a separate details whenever the name is searched ..everything concerning the student will appear Please is any way I can reach you
@599CD5 ай бұрын
599cd.com/ask
@kevinmwandi28192 жыл бұрын
Every time i open a specific form then close it the try to open anothe report that is related to the same table it cause the error "the database could not lock table becaouse it is being used by another user so i have to log out the. Login with the login form....if i open the report then close it before opening the form when i open the form it now becomes blank....how do i solve this
@599CD2 жыл бұрын
Not sure. I'd have to see it.
@nealdorelis57032 жыл бұрын
Nice. It is possible to create two lists and through one to choose information and give its characterists in other list?? For example, un list name continent, the other list countries. When you choose a continent, its must give only the countries affected
@599CD2 жыл бұрын
599cd.com/Cascading
@akokohjoel98542 жыл бұрын
With this method you one can create a transaction history/statement for a customer
@599CD2 жыл бұрын
Yep
@robertharrison62962 жыл бұрын
Can this be done? A subform shows dates that training is completed for 5 training requirements. Can the form show all five requirements before the dates are entered? The database has 3 tables, Employees, Requirements, RequirementDate. The RequirementDate table is a links table with EmployeeID, RequirementID, and Date.
@599CD2 жыл бұрын
Sure... but without knowing more about your database, I really can't tell you how. Post your question at 599cd.com/TH
@dolittlediehard1670 Жыл бұрын
I'm looking a tutorial for a subform within a subform within a form, with each a calculated field that must finally show on the outer form. Imagine you have an order form with order lines with a calculated line total and then the total for all the order lines is on this sub-subform but this total must only show itself on the outer form.
@599CD Жыл бұрын
599cd.com/Ask - need more details, preferably some screen shots
@dolittlediehard1670 Жыл бұрын
@@599CD i really wish I could because this was a task we were supposed to complete. It's kind of been forgotten about, it was a challenge from our tutor. He's not very good at producing answers. If you don't try at least we get nothing from him. It's not a real big deal but i thought it was interesting at the time. I'll dig out the question and post it here tomorrow.
@mail2kishorekunal2 жыл бұрын
Hi Richard - I am working on a form based tool. I am stuck in designing something. Appreciate of you could help me.
@599CD2 жыл бұрын
Can't help you without more details.
@mail2kishorekunal2 жыл бұрын
@@599CD Thank you for your response. I am trying to build a subform that pulls data from diffrent diffrent tables based on a user input. On that form, I would like to add a button to select/delete records. User should not be allowed to edit directly through the subform. Appreciate if you could help me a readily available logic you might have. Please do let know if you would need more information.
@oguzturkyilmaz543 Жыл бұрын
Thanks
@599CD Жыл бұрын
Welcome
@donaldshroyer86335 ай бұрын
Just make some space between fields to accommodate date picker. Sheesh.