No video

Microsoft Access Combo Boxes - Value List and Search Combo Boxes - Find Records

  Рет қаралды 135,854

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 67
@krishnashisdas1606
@krishnashisdas1606 3 жыл бұрын
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
@599CD
@599CD 3 жыл бұрын
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.
@hardysingh198
@hardysingh198 3 жыл бұрын
@@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.
@599CD
@599CD 3 жыл бұрын
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.
@mattk6740
@mattk6740 3 жыл бұрын
@@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.
@fredevans2360
@fredevans2360 4 жыл бұрын
You have clarified much that i have been trying to figure out about comboboxes you have made it so easy to understand
@599CD
@599CD 3 жыл бұрын
Glad to help
@ruthreyes5563
@ruthreyes5563 4 жыл бұрын
Thank you for your teachings. They are very good.
@599CD
@599CD 3 жыл бұрын
My pleasure.
@yams900
@yams900 Жыл бұрын
Another good one ! Couldn’t get it to work at first, turned out the Record Source wasn’t set up correctly
@sirargoth76
@sirargoth76 3 ай бұрын
Love the Star Trek easter egg!
@awortweenock4077
@awortweenock4077 2 жыл бұрын
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
@599CD
@599CD 2 жыл бұрын
If I ever need an intern, I'll let you know. :)
@ashishtayade047
@ashishtayade047 4 ай бұрын
Thank you sir very nice gide & very nice best information combo boxes teaching video.👍
@599CD
@599CD 4 ай бұрын
Glad you liked it
@farhanadli7210
@farhanadli7210 3 жыл бұрын
Many thanks sir. Really informative and very well guidance for a newbie person like me. I'm learn a lot from your videos.
@599CD
@599CD 3 жыл бұрын
Glad to hear that
@599CD
@599CD 4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@rashmimbendakaluru7225
@rashmimbendakaluru7225 3 жыл бұрын
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.
@599CD
@599CD 3 жыл бұрын
599cd.com/NoThirdOption
@alializadeh8195
@alializadeh8195 Жыл бұрын
Thanx
@easyspeak101
@easyspeak101 2 жыл бұрын
@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
@599CD
@599CD 2 жыл бұрын
Yeah, they can use both.
@easyspeak101
@easyspeak101 2 жыл бұрын
@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 ..😂
@easyspeak101
@easyspeak101 2 жыл бұрын
Done .. I mean original design.. 😊
@mohamad5693
@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
@599CD Жыл бұрын
Yeah, that does suck. Maybe one of these days our governments will get their shit together and stop being cockgoblins.
@carolynjaret
@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.
@lucatramontana1138
@lucatramontana1138 2 жыл бұрын
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?
@599CD
@599CD 2 жыл бұрын
Set the locked property to yes.
@priyankamalhotra1339
@priyankamalhotra1339 Жыл бұрын
Can we add combo to the table without the form
@599CD
@599CD Жыл бұрын
Can you? Yes. Should you? No. Use a form.
@HaiderAli-mp1qq
@HaiderAli-mp1qq 4 жыл бұрын
In My Case , third option of finding record is unavailable,,, Why??
@599CD
@599CD 4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@shekuikallon7002
@shekuikallon7002 4 жыл бұрын
How should I pay for beginner level 2.what are they procedures involve
@599CD
@599CD 4 жыл бұрын
Just visit 599cd.com/1dollar and order from there. Easy as pie.
@edwardsapu2032
@edwardsapu2032 3 жыл бұрын
I am having difficulty in creating combo box......
@599CD
@599CD 3 жыл бұрын
Keep trying. You'll get the hang of it.
@Shengu_sh.
@Shengu_sh. 2 жыл бұрын
Thanks ❤ 🇱🇰
@599CD
@599CD 2 жыл бұрын
Welcome
@goodmorningfrommt
@goodmorningfrommt 3 жыл бұрын
Brilliant thank you
@599CD
@599CD 3 жыл бұрын
Glad you enjoyed it
@tutsecret499
@tutsecret499 2 жыл бұрын
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
@599CD
@599CD 2 жыл бұрын
TLDR. One question at a time, please.
@synergybydesign6783
@synergybydesign6783 2 жыл бұрын
RE search combo, 'where is the search code?' It is not under AFTER UPDATE.............WHEREIS IT?
@599CD
@599CD 2 жыл бұрын
I don't understand
@ajaysharmagautam4510
@ajaysharmagautam4510 4 жыл бұрын
Very awesome 👍
@599CD
@599CD 4 жыл бұрын
Thank you 👍
@abdulhamidalhaddadi2255
@abdulhamidalhaddadi2255 3 жыл бұрын
thank you
@599CD
@599CD 3 жыл бұрын
You're welcome
@cardinalpalace
@cardinalpalace 2 жыл бұрын
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.
@599CD
@599CD 2 жыл бұрын
Not sure what the problem is. Without seeing it, I really can't tell.
@vishal3476258
@vishal3476258 4 жыл бұрын
The third option after creating combo box is not available to me
@599CD
@599CD 4 жыл бұрын
If you base your FORM on a QUERY then the 3rd option isn't available. Use a TABLE instead.
@thecave1356
@thecave1356 3 жыл бұрын
i have same name and when i save show both in combo box so how to show only one name
@599CD
@599CD 3 жыл бұрын
No idea what you mean by this.
@soribabayo2278
@soribabayo2278 2 жыл бұрын
I love it
@599CD
@599CD 2 жыл бұрын
Thanks
@janssenmichaelperez6853
@janssenmichaelperez6853 Жыл бұрын
interested to join as gold member, kindly assis me how to join?
@599CD
@599CD Жыл бұрын
599cd.com/THM
@haithamyacobi6889
@haithamyacobi6889 4 жыл бұрын
Thankes
@599CD
@599CD 3 жыл бұрын
You're welcomes. :)
@rajashreenat
@rajashreenat 3 жыл бұрын
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
@599CD
@599CD 3 жыл бұрын
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
@599CD
@599CD 3 жыл бұрын
Forgot I had this one too: 599cd.com/LastNameFirst
Microsoft Access Developer 37. User-Selected List of Fields to Display on a Form
5:26
الذرة أنقذت حياتي🌽😱
00:27
Cool Tool SHORTS Arabic
Рет қаралды 20 МЛН
Harley Quinn's revenge plan!!!#Harley Quinn #joker
00:59
Harley Quinn with the Joker
Рет қаралды 26 МЛН
Microsoft Access: Finding Records with an Unbound Combo Box
10:29
Pharos Technology
Рет қаралды 9 М.
How to Make a Search Form with Combo Boxes in MS Access
18:53
Sean MacKenzie Data Engineering
Рет қаралды 35 М.
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 509 М.
How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access
19:12
Sean MacKenzie Data Engineering
Рет қаралды 14 М.
SEARCH FORM - Searching while Typing in Microsoft Access.
12:46
Edcelle John Gulfan
Рет қаралды 9 М.
Access 2010: Auto populate fields using a combo box in forms.
11:57
Allen Jarrett
Рет қаралды 556 М.
الذرة أنقذت حياتي🌽😱
00:27
Cool Tool SHORTS Arabic
Рет қаралды 20 МЛН