i don't know why this channel is not a big one.... but nobody taught me access like this before i hope i got a teacher like u
@599CD3 жыл бұрын
Yeah, I don't know why it's not a big one either? LOL. I guess because I focus mainly on Access and I have been for the past few years. I've released very few Word and Excel videos. The crowd for Access users is pretty small, but that's my focus (and my love) and always will be. I do have new videos for Word and Excel coming out in 2021, so maybe that will add to my "mass appeal." Thanks for the compliments.
@hardysingh1983 жыл бұрын
@@599CD crowd focus more on excel because they think excel is easier than access, but people don't know that we can actually build softwares with access, but can't do anything on excel.
@599CD3 жыл бұрын
Yeah, I can post a Word or Excel video and get 10x the views, but Access is my passion (and 90% of my business) and it's what I do best that not a lot of other people make videos for well. Personally, I'll use Excel for a small data storage job. But after the sheet gets to, say, 500 rows, it's time to move to Access.
@mattk67403 жыл бұрын
@@599CD Question: is there a way to add color to the Combo Box (such as from a palette). Am only finding color option for Combo Box X Control. Thanks.
@fredevans23604 жыл бұрын
You have clarified much that i have been trying to figure out about comboboxes you have made it so easy to understand
@599CD3 жыл бұрын
Glad to help
@ruthreyes55634 жыл бұрын
Thank you for your teachings. They are very good.
@599CD3 жыл бұрын
My pleasure.
@yams900 Жыл бұрын
Another good one ! Couldn’t get it to work at first, turned out the Record Source wasn’t set up correctly
@sirargoth763 ай бұрын
Love the Star Trek easter egg!
@awortweenock40772 жыл бұрын
You've made me love Microsoft access. Thank you very much. I would love to intern with you on Microsoft access and I also want to practice and learn more
@599CD2 жыл бұрын
If I ever need an intern, I'll let you know. :)
@ashishtayade0474 ай бұрын
Thank you sir very nice gide & very nice best information combo boxes teaching video.👍
@599CD4 ай бұрын
Glad you liked it
@farhanadli72103 жыл бұрын
Many thanks sir. Really informative and very well guidance for a newbie person like me. I'm learn a lot from your videos.
@599CD3 жыл бұрын
Glad to hear that
@599CD4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@rashmimbendakaluru72253 жыл бұрын
thank sir, many videos of yours is very helpful as it is having clear simple steps to understand and follow. having a problem sir, 3rd option is unavailable after drawing combo box, how to make it visible, please guide us sir. thank you in advance.
@599CD3 жыл бұрын
599cd.com/NoThirdOption
@alializadeh8195 Жыл бұрын
Thanx
@easyspeak1012 жыл бұрын
@RichardRost... I read access shows the user.. the Form is bound to underlying table in this case .. and yet in the last part of the video the row source is seen to carry out a query SELECT written in the " row source" in the property table with the help of a macro, setting the ID (i think)...with help of combo box to display the selected row from the table, which is the reason learners inc me, find it difficult to fathom as its works and operates very similar to a query attached to the form... which obstructs clarity.. to lesser mortals at least.. Great video tho..Thx
@599CD2 жыл бұрын
Yeah, they can use both.
@easyspeak1012 жыл бұрын
@RichardRost Thanks i now know that bit.. i just wondered why it seemed to be done in a misdirecting fashion.. Takes a clever person to figure out.. all its machinations... Anyway Thx.. vid at least stops my pc growling warnings at me ..😂
@easyspeak1012 жыл бұрын
Done .. I mean original design.. 😊
@mohamad5693 Жыл бұрын
You are very good in teaching access I enjoy and very intrested to your complet videos But unfortunatly I can't order and buy your videos becuse of the sanctions on IRAN🇮🇷 It's very disapointing😔
@599CD Жыл бұрын
Yeah, that does suck. Maybe one of these days our governments will get their shit together and stop being cockgoblins.
@carolynjaret Жыл бұрын
I recently asked about how to get a form to store the data that is selected from a list box. The answer you gave me does not appear to be working. Is there anyplace i can read about this because it is not working for me and I need to be able to store multiple names as beneficiaries in a table and it just isn't working.
@lucatramontana11382 жыл бұрын
Thanks for your good explanation and tutorial. I have a question on using a combobox in a form: can you suggest how to prevent the user from deleting the text in the combobox by pressing the delete key?
@599CD2 жыл бұрын
Set the locked property to yes.
@priyankamalhotra1339 Жыл бұрын
Can we add combo to the table without the form
@599CD Жыл бұрын
Can you? Yes. Should you? No. Use a form.
@HaiderAli-mp1qq4 жыл бұрын
In My Case , third option of finding record is unavailable,,, Why??
@599CD4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@shekuikallon70024 жыл бұрын
How should I pay for beginner level 2.what are they procedures involve
@599CD4 жыл бұрын
Just visit 599cd.com/1dollar and order from there. Easy as pie.
@edwardsapu20323 жыл бұрын
I am having difficulty in creating combo box......
@599CD3 жыл бұрын
Keep trying. You'll get the hang of it.
@Shengu_sh.2 жыл бұрын
Thanks ❤ 🇱🇰
@599CD2 жыл бұрын
Welcome
@goodmorningfrommt3 жыл бұрын
Brilliant thank you
@599CD3 жыл бұрын
Glad you enjoyed it
@tutsecret4992 жыл бұрын
how I make automatic dropdown list to see the contents to choose when I tab sitting on the field. I know for combobox example: private...on got focus. Me.subcontrolname.dropdown end.. or create function, but I need to know for value list already existed in the DB, example: ethnicity 1-White, 2-Black, 3-Hispanic, up to 12. So how I make this list to drop down, I dont know by heart which number belongs to which ethnicity. I memorize from 1 to 3, after that I need to see the contents. Another thing, I don't know why the value list stops at # 1, although the field is still empty, it will confuse making people think that 1 was chosen. How I can set up this value list stop in blank area on the top before 1 to 12items, I did not create all these value list set ups, there were already there, and it's making my hands clicking too much on the arrow to drop the box. I don't know why it was created many comboboxes and list boxes, value list? in the database, instead of creating only comboboxes. What's the difference between got on focus and afterupdate
@599CD2 жыл бұрын
TLDR. One question at a time, please.
@synergybydesign67832 жыл бұрын
RE search combo, 'where is the search code?' It is not under AFTER UPDATE.............WHEREIS IT?
@599CD2 жыл бұрын
I don't understand
@ajaysharmagautam45104 жыл бұрын
Very awesome 👍
@599CD4 жыл бұрын
Thank you 👍
@abdulhamidalhaddadi22553 жыл бұрын
thank you
@599CD3 жыл бұрын
You're welcome
@cardinalpalace2 жыл бұрын
Hi there, I have created a search combo box just as you've shown; when I search for a specific person on first attempt, the record shows properly. When I try to search and click on another person from the combo box, the record does not update. I also get an error message when I try to close the form that says: Update or CancelUpdate without AddNew or Edit. When I crate the combo box, I make sure to choose a key, as well as the name fields I need, but I keep getting this error.
@599CD2 жыл бұрын
Not sure what the problem is. Without seeing it, I really can't tell.
@vishal34762584 жыл бұрын
The third option after creating combo box is not available to me
@599CD4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@thecave13563 жыл бұрын
i have same name and when i save show both in combo box so how to show only one name
@599CD3 жыл бұрын
No idea what you mean by this.
@soribabayo22782 жыл бұрын
I love it
@599CD2 жыл бұрын
Thanks
@janssenmichaelperez6853 Жыл бұрын
interested to join as gold member, kindly assis me how to join?
@599CD Жыл бұрын
599cd.com/THM
@haithamyacobi68894 жыл бұрын
Thankes
@599CD3 жыл бұрын
You're welcomes. :)
@rajashreenat3 жыл бұрын
Richard, can you please show how to look up a name in the combo box by typing it in. My combo box has 200 referring doctors and scrolling thru them is a pain. Also I can only type first letter of the first name and get options. But drs are known by last name and typing the first letter of last name does not yield the result. Can u help
@599CD3 жыл бұрын
This is just a matter of how you format the names in the combo box. If you set them up as LastName, FirstName then you can start typing in the first few characters of their last name and go right to the correct one. Use string concatenation, set up a custom field, and then base your combo box on that field. 599cd.com/Concatenation
@599CD3 жыл бұрын
Forgot I had this one too: 599cd.com/LastNameFirst