WOW! You are the BEST teacher I have seen for MS Access!! Thank you so much for providing all that knowledge, clearly and for free.
@599CD Жыл бұрын
Welcome
@tastydohnut4 жыл бұрын
Nice one Richard. Not many people on YT can give such clear explanations on this subject like yourself. Much appreciated.
@599CD4 жыл бұрын
Glad it was helpful! I appreciate the compliment.
@emilythechef6 ай бұрын
Thanks to whoever for inventing this, and thanks to you for teaching it, Richard! Gosh, this is just what I needed.
@emilythechef6 ай бұрын
I've been using a database I designed from the ground up for almost 15 years, and now someone else will be helping me do my job, and they need to use the database too, but it was made for me, and me alone. So I'm tasked with making it user-friendly (and not-destroyable) by someone who has never used Access before. I wish I had made this search/filter button 15 years ago, I love it!
@winstonchilds8703 жыл бұрын
Thanks Richard, I have learned a great deal from your Videos. Well done, clear voice, no fluff.
@599CD3 жыл бұрын
Great to hear!
@Jojosmith3422 жыл бұрын
Richard is such a great inspiration. I love your lessons. I am sure you have helped a lot of people! Big thank you. May God always bless you !
@599CD2 жыл бұрын
Thanks
@ZahidKhan-mb6oc4 жыл бұрын
Very useful and comprehensive lesson.. Thanks Richard for your efforts to spread knowledge.
@599CD4 жыл бұрын
My pleasure!
@vladimirlaurent34042 жыл бұрын
Thank you Richard for the video. do you have one for error handling?
@599CD2 жыл бұрын
I've got a TechHelp on error handling coming out soon. I cover it in detail in Developer 2 and 15. 599cd.com/ACD2
@cdscoys47753 жыл бұрын
Thanks very much. This works well.. until someone typed in a value which was not present in the list... Any ideas on an elegant way to deal with that?.
@599CD3 жыл бұрын
Sure, ask them if they want to add it, then add it. :)
@enikobakonyi18432 жыл бұрын
Thank you for all your free videos, they are so useful! I was wondering if I could make a search button working just the same as in this video, but not located on the customer form, but on the main menu? So a search button on the menu form that prompts you to enter (partial or all the) last name, then first name and pull up the customer form as the search result.
@599CD2 жыл бұрын
Sure. That would work.
@dnbtexas2 жыл бұрын
Thanks for this great video! What if the Search doesn't match anything? Is there a video of yours that goes into this?
@599CD2 жыл бұрын
You could try a DLookup first to see if any records exist. 599cd.com/DLookup. Or you could just look at the ID on the form and see if it's Null. 599cd.com/Null.
@dnbtexas2 жыл бұрын
@@599CD Thanks very much for the quick reply. I appreciate the help!
@MarkoftheSwamp4 жыл бұрын
Thank you very much Richard, this was really useful. Like your teaching style, no messing around !
@599CD4 жыл бұрын
Glad you enjoyed it! I do my "messing around" in the Extended Cuts. :)
@ansiepretorius59482 жыл бұрын
Hi Richard, I love to watch your videos. They are so helpful. I do have a question though. I created search buttons on my form and it worked perfectly. I then had to add this form to another as a subform and now it does not work. Do I have to make changes to the VBA code to enable it again?
@599CD2 жыл бұрын
Impossible to tell without seeing what you've done
@ansiepretorius59482 жыл бұрын
@@599CD Hi Richard, I created two forms using your VBA method to search in various fields and it worked fine on both forms when using seperately. (ResidentF with Resident information and UnitF with property info). When using the UnitF as main form showing the ResidentF as subform, the search fields does not work) VBA code on Resident Subform : Private Sub SearchSurnameBtn_Click() Dim S As String S = InputBox("Please enter Surname", "Surname", Surname) If S = "" Then Exit Sub Me.Filter = "Surname LIKE ""*" & S & "*""" Me.FilterOn = True End Sub How can I forward you a Screenshot of the combined form?
@billfritz63092 жыл бұрын
Great Video. What if the field is a lookup, where the saved value is not visible?
@599CD2 жыл бұрын
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
@rlumaban Жыл бұрын
This is a great tutorial. When the search button results is null value and you click on the search button again, I get an Error 94: " Invalid Use of Null". Is there a code you can write to prevent the error?
@599CD Жыл бұрын
599cd.com/Ask
@LebonChiza3 жыл бұрын
Cool n simple video. Best method
@599CD3 жыл бұрын
Glad you think so!
@NissanButuan5 ай бұрын
Hello Sir, How about two input box to search? in one code?
@ansiepretorius59482 жыл бұрын
Hi Richard. Thank you for these videos. It really makes our lives better. Is it possible to create a similar search button to search for a number? When I try to use your code on a number field, I get the error message: Data type mismatch in criteria expression.
@599CD2 жыл бұрын
Remove the quotes if it's a number
@publiclips2 жыл бұрын
Cool video, but I need to do what it says at the beginning, I need a Search Button, this does not filter anything, just goes to the record. Some video where you do that? Tnx
@599CD2 жыл бұрын
599cd.com/Search2
@mokanis25112 жыл бұрын
Hi Mr. Richard, once again thank you for the VBA code, it helped me a lot to be able to build a filter into my continuous form without using the filter option in the toolbar something I was looking for for a while. Thank you sir for the sharing of your knowledge. 👍✌
@599CD2 жыл бұрын
Welcome
@murpmich59 Жыл бұрын
@@599CD Another good tool for your tool box is the OpenAI Chat. I notice Richard mention it in one of his vids. I pasted the search code in and told OpenAI to refine the code to pop-up a warning OK box and to turn off filter , and reset to record #1 if no matching records were found. Worked perfect.
@rexlyons32802 жыл бұрын
Hi Richard! Thank you very much for the videos. Any idea why I would get ma debug error with this? It’s a 4 digit ID number. The first me.filter line of code is highlighted yellow when following you tutorial. Is it because it’s a number?
@599CD2 жыл бұрын
Sorry, but based on the information you've given me, I really don't have enough data to help you. Feel free to submit your question with more details (including screen shots) here: 599cd.com/KZbin-Submit-Question
@mcmike61902 жыл бұрын
Darn it, why didn't I find your videos when I was using Access at work! Fantastic series, I am joining. Richard, can you use the search buttons with date fields? Or would it be easier to have the date fields as text fields for easier search? Can't use a date picker though? Thanks!
@599CD2 жыл бұрын
Sure, you can use date fields. Just make sure to enclose date criteria in # signs.
@mcmike61902 жыл бұрын
@@599CD Thanks for the quick reply!
@maryamandaraff92244 жыл бұрын
Thank you, Will this button work if it's a bigger field, such as searching for one word in a field that has a description?
@599CD4 жыл бұрын
I don't see why not. Give it a try.
@Purplexis7 ай бұрын
I am having an issue if my string reports back no data it does not just exit the form, it creates an error. Any idea what I am doing wrong?
@erinburns-flett15093 жыл бұрын
Excellent! I very much like your videos - well paced and excellent content. Thank you so much.
@599CD3 жыл бұрын
You're very welcome!
@SteveJones-c8d Жыл бұрын
Maybe a silly question - why is it called the "binoculars" button when the image sure looks like a magnifying glass?
@599CD Жыл бұрын
That's above my pay grade
@scubaguy1989 Жыл бұрын
When I go to build even my code builder screen doesnt look what you were working on, cant see where to type in code? .
@thusharasampath41973 жыл бұрын
great..!!! I think this explains cmd button well. thank you dear...
@599CD3 жыл бұрын
You're welcome, lovey. :)
@stephaniewhitley16132 жыл бұрын
Thanks Mr. Richard -- I have been searching for quite awhile about how to do this. One question: I'm using the filter option, but I only need my users to search on two fields, both of which are combo boxes. Is it possible to somehow in VBA change "input box" to "combo box" with all the choices they would need? Hope this makes sense and thanks in advance.
@599CD2 жыл бұрын
599cd.com/ask
@anondodasgupta52753 жыл бұрын
Great videos. These have helped me a lot. I tried using the search button using VBA code. But, encountered a problem. I have stored the client name via a combo box. I have a separate table for client name and am referring to that to store values in another table using a combo box. The search button recognizes the ClientNameID as that is the one which is stored. How to overcome this?
@599CD2 жыл бұрын
ComboBox.Column(1)
@marcodijkhof23944 жыл бұрын
Dear Richard, thank you for the video's. I learn a lot. Is it also possible when youre having more names that you display one below the other instead of moving to the next field with the arrow
@599CD4 жыл бұрын
You mean a Continuous Form? 599cd.com/Continuous
@marcodijkhof23944 жыл бұрын
@@599CD no, not quite. I have a database of supplier item numbers sold by wholesalers. every wholesaler has linked its own article number to a supplier number. now I want to create a search bar where I enter a supplier number or the linked wholesale number and that it shows all matches one below the other in a list.
@599CD4 жыл бұрын
Yeah, you could either use a continuous form in a subform OR a listbox. All depends on how you want to go about it. A subform might be easier since you can build a query and show your results that way. I cover stuff like this in my Search Seminar: 599cd.com/SearchSem
@royp20293 жыл бұрын
In this Video when you go into Build Event the top 2 sub sections are filled in ! when I go into Build event the screen is blank apart from the option to enter the event, is this normal ?
@599CD3 жыл бұрын
I can't picture what you're talking about. It's a shame you can't post screen shots here. Feel free to submit your question at 599cd.com/TH
@keithbernard9722 жыл бұрын
I am using Access to track the tickets I work on from day to day. I'd like to use the find option to location the exact spelling of an office I cover. Is there a way to use the find tool to search through the locations list?
@599CD2 жыл бұрын
Sorry, but based on the information you've given me, I really don't have enough data to help you. Feel free to submit your question with more details (including screen shots) here: 599cd.com/KZbin-Submit-Question
@kylebobguitar2 жыл бұрын
Thanks Richard! Question for you. How would I display a message that no results were found if a search is done and nothing matches?
@599CD2 жыл бұрын
599cd.com/DCount perhaps? This would involve some coding.
@sebastianhaze3979 Жыл бұрын
I did the code & everything works perfect except when I enter data that is not in the search it takes me to the debug screen.
@599CD Жыл бұрын
Well try it again and try it with a different database
@ptaluc2 жыл бұрын
Where is the free Customer Template? Can't find it here. Many thanks.
@599CD2 жыл бұрын
599cd.com/Blank
@opty1015 Жыл бұрын
i have a question when i enter the customer ID for exg it dont show the other information
@599CD Жыл бұрын
Huh?
@yusuffsesay73313 жыл бұрын
This is really good. Thanks so much Richard.
@599CD3 жыл бұрын
You're very welcome
@MaskMajor Жыл бұрын
this is so useful! thank you so much!!
@599CD Жыл бұрын
You're welcome
@FreeHappiness4 жыл бұрын
Hi Richard I am not able to search on form based on query with Unicode character and I wasn't able to find a solution anywhere.
@599CD4 жыл бұрын
Feel free to submit this: 599cd.com/TechHelp
@m.albayati59253 жыл бұрын
Thank you so much for all the help.
@599CD3 жыл бұрын
You're very welcome!
@candicesmyth93042 жыл бұрын
Hi, I am wondering whether its a simple change to the code to have it search for a last name in a separate form?
@599CD2 жыл бұрын
Shouldn't be that hard
@markdale41523 жыл бұрын
Hi Video is great. created my first search box. It worked for about 2 hours then all of a sudden it stopped work. You click on the search button and nothing happens at all?? Nothing has changed in the form, but it just stops working and no matter how many times I remove the button and redo it, i cant get it to work again?? Can't even get past the first part with the msgbox test.
@599CD3 жыл бұрын
That's weird. Check: 599cd.com/Trouble
@joemilan1301 Жыл бұрын
PLEASE SIR, MAY I HAVE GET SAMPLE MS ACCESS VBA CODES FOR CREATING TWO CBO WITH SEARCH TEXT WHERE ONE CBO IS FOR MULTIPLE TABLES SELECTING AND OTHER CBO IS MULTIPLE COLUMNS OR FIELD FOR AUTO SEARCH WITH SEARCH BOX BY HELPING THE SEARCHING TERM FOR QUERY TO DISPLAYS OTHER FIELD TEXT BOXES. THANK YOU
@abiribatech Жыл бұрын
Please how to exit after search
@MaitreEtherion3 жыл бұрын
Very interesting! Thanks :) Quick question (maybe not XD ) If I don't want to apply a filter, but reach the record like the search button did, what function I need?
@599CD3 жыл бұрын
DoCmd.OpenForm with a WHERE criteria 599cd.com/ACD1
@angiefaerie6 ай бұрын
Okay I'm way late to the game, but you blew my mind with double-clicking the ribbon header to hide/unhide WHAT
@jonahthrane812 Жыл бұрын
if the search returns no results, i dont get a blank form, i get a blank page, all fields are gone, what can i do so if the search gives no results it prompts me to try and search again?
@599CD Жыл бұрын
599cd.com/ask
@williamnovarese512 жыл бұрын
I was able to get this to search but not without opening and closing the Query. It prompts me for input for each field when I open the query. Access 7.
@599CD2 жыл бұрын
Are you getting this: 599cd.com/EPV
@elbrujomaya2 жыл бұрын
Can you create a button to delete it after finding a contact?
@599CD2 жыл бұрын
Sure
@johnmcgreevy56972 жыл бұрын
What if we are searching a number? How would that change the code? Thanks.
@599CD2 жыл бұрын
Don't use quotes
@rajashreenat3 жыл бұрын
I have my staff type Control F with cursor in the field to search. Works very well.
@599CD3 жыл бұрын
Yep! That works too.
@soniadeguzman-duran27143 жыл бұрын
Hi Richard, may I ask how did you make the "Main Menu" button? thank you
@599CD3 жыл бұрын
See 599cd.com/Blank
@ryanmartin6973 жыл бұрын
Thanks so much, the tips are really useful
@599CD3 жыл бұрын
Happy to hear that!
@DS-ed1tk Жыл бұрын
When I enter a name that does not exist, it returns an empty result. After that, if I don't clear the filter and directly press the search button, it gives an error Run-time error 94 Invalid use of null.
@599CD Жыл бұрын
Well you can always check for those conditions before you perform the search in the button code this is just a simple video to outline the basics it's not comprehensive
@stephenbeswick21632 жыл бұрын
Hi great another video steve
@599CD2 жыл бұрын
Thanks
@AlMumayaz4 жыл бұрын
I have a question about the possibility of extracting the names of buttons within a form, if I choose a specific form, is there an ability to extract all the names of the buttons within the form?
@599CD4 жыл бұрын
Sure. You have to parse the form's Controls collection with a For Each loop. I cover For Each loops in my Access Developer 15 class, but not parsing the Forms collection, specifically. I use it for parsing selected items in a multi-select listbox, but the concept is similar. 599cd.com/?1188
@yousefalhendi26384 жыл бұрын
I am very interesting to fowling your lessons
@599CD4 жыл бұрын
Thanks
@quickneasy62093 жыл бұрын
Good day. Doing something Similar. When i click on the button i get asked for the parameter of the field I am trying to filer. Any Suggestions?
@599CD3 жыл бұрын
Check your spelling.
@jimcarr22153 жыл бұрын
@@599CD I've checked spelling but it still happens. when I use msgbox s the input provided is correct. Any other suggestions?
@jimcarr22153 жыл бұрын
Never mind! If found the misplaced "space" in my expression. Works well!!! Thanks for a great video.
@ziping72 жыл бұрын
When my search doesn't match anything my form is completely hiding and I have to click Toggle Filter to bring it back, how to avoid this. Also great job with videos
@ziping72 жыл бұрын
Ok I got this : After : Me.FilterOn = True If Me.Recordset.RecordCount = 0 Then Me.FilterOn = False Me.Filter = "" End If
@599CD2 жыл бұрын
Yeah, that'll work. :)
@metalpuzzle26253 жыл бұрын
Why does my Access 2019 not show the first 2 private sub details as in this video ?.
@599CD3 жыл бұрын
That's code from the other buttons on my form.
@allenduke41133 жыл бұрын
How can I have a report query data based on a drop down list?
@599CD3 жыл бұрын
599cd.com/FormName - just use a combo box instead of a text box
@Nassallm4 жыл бұрын
showing problem in s = inputbox(please enter..)
@599CD4 жыл бұрын
I need more info to help you.
@susannvb4 жыл бұрын
@@599CD Thank you for the videos! I have definitely learned a lot. Like the previous commenter, I'm also having a problem with the input box code line. It worked when I opened the form directly from the form, but when I navigated to the form from my main menu, I received a "Run-time Error '94' - Invalid use of Null. Here is the code I input. Other than my own field name, I duplicated what I thought I saw in the video. S = InputBox("Please enter last name", "Last Name", EELastName) If S = "" Then Exit Sub
@599CD4 жыл бұрын
What line generates the error? Are you getting it BEFORE or AFTER the InputBox pops up? If it's before, your EELastName is probably causing the problem. Wrap it in an NZ function. 599cd.com/NZ
@NancyTroutman4 жыл бұрын
What would the code be if I wanted the computer to beep if the record was not found? By the way, I tried to Join, but the first field which had my email address & paypal is greyed out. It says "to complete this transaction, a payment method must be added. It won't let me add it. Add credit card & Add Paypal are not greyed out, but I already have PayPal & I am not willing to give out credit card info on the web.
@599CD4 жыл бұрын
Docmd.Beep I have ZERO control over billing on KZbin. You'll have to contact their customer support. Personally, I use CashApp for web-based credit card transactions. You can load it up with money and turn it OFF when you're not using it.
@GurpreetSingh-nw5xo4 жыл бұрын
hi Richard when i am trying to make a search button but it is showing me an error like invalid use of null i am confused can you please give me solution for this. i have all the records as same as you for customer form . please help me i have a poject to submit this week. thank you
@599CD4 жыл бұрын
If you followed my example step-by-step and all of your spelling is correct, and all of your data types are the same, it should work. Without seeing your database it's impossible for me to know what you did wrong.
@GurpreetSingh-nw5xo4 жыл бұрын
@@599CD hi can you please help me to complete my database? i will be very thankful to you
@599CD4 жыл бұрын
Sure. 599cd.com/Consulting
@Zwen633 жыл бұрын
If you do a search from a blank record, it gives this error here also. From a filled field it works great!
@anjalim18303 жыл бұрын
After coding when I go back to the form view and click the search button I get an error. It says "Invalid use of Null". Can you help please?
@599CD3 жыл бұрын
Did you follow the steps from the video EXACTLY?
@anjalim18303 жыл бұрын
@@599CD For the search button part, yes. but I worked on my table.
@joecarpenter10083 жыл бұрын
I get the same error - what I was able to figure out is the error comes from the form loading a blank (new) record, if the form opens to an existing record the search button works as in the video.
@qlunar66214 жыл бұрын
I want to add a scan button to a form that serves as a tool for archiving student data, I want a code for the scan button, Where when I click on it, it scans documents and photos directly from access form and it automatically creates folders classified according to the student's ID, his name and department Can you help me or recommand me how to solve this problem.. Many thanks
@599CD4 жыл бұрын
Well, performing the scanning (from an actual scanner) is something you're going to have to do manually. I don't think Access can control the scanner. However, once the documents are files on your system, you can definitely use Access to select them, manage them, copy them to a special folder, rename them, etc. I cover this in my Imaging Seminar (for images, but works just fine for any document/file). 599cd.com/Imaging. I'm also going to be adding this very soon to my ABCD database. 599cd.com/ABCD
@tchorzu2 жыл бұрын
very works
@599CD2 жыл бұрын
Very works, indeed!
@maudemax1 Жыл бұрын
For some reason this is NOT working for me - frustrating!
@599CD Жыл бұрын
Sorry. Try again. Also see 599cd.com/Search2
@mustakimfaiaz3 жыл бұрын
Thank you very much...
@599CD3 жыл бұрын
Welcome!
@1808arents3 жыл бұрын
Good video's
@599CD3 жыл бұрын
Thanks
@nabinkhati53653 жыл бұрын
Thank you
@599CD3 жыл бұрын
You're welcome
@Flyboy_4 жыл бұрын
when i click on "Build Event" and try your coding, my display came out different lol I give up!
@599CD4 жыл бұрын
Well... that happens. Maybe start here: 599cd.com/IntroVBA
@Flyboy_4 жыл бұрын
@@599CD thanks for the recommendation!! I'm trying to come up with a system for my small music school here and your videos have been very helpful! I'm considering joining your membership to learn more abt access and all. I'm signed up for a month free trial with microsoft access so i sort of have a deadline hahahaha I guess my question is: How much do you think i need to learn abt VBA before my trial ends to determine if access is really the system for me? =(( Thanks in advance!!
@599CD4 жыл бұрын
VBA is the advanced end of Access. Make sure you understand all of the non-programming concepts first! Start with my free Beginner 1 course and move up from there: 599cd.com/ACB1
@THECHANDUG4 жыл бұрын
Super ❤️❤️❤️
@599CD4 жыл бұрын
Thanks
@stephenespinosa36673 жыл бұрын
It did not worked for me.😭
@stephenespinosa36673 жыл бұрын
HELP ME PLEASE. 😭😭😭
@599CD3 жыл бұрын
Try it again. Follow my video exactly from the beginning. It'll work.
@stephenespinosa36673 жыл бұрын
The reason, it didn't work because mine is MS Access 2007 😭😭😭
@danielaimperial98213 жыл бұрын
@@stephenespinosa3667 it works even if it's Access 2007. There will be a difference between the 2010 version and above but it works well starting from 2007 version.
@ilhansalah80853 жыл бұрын
Plz make systrm hoepital in access 🥺
@599CD3 жыл бұрын
Do you mean a database to run all of the aspects of a hospital? Oh... seems like a piece of cake. I'll get right on that. LOL
@sajalmalik61333 жыл бұрын
🌸🌸🌸
@599CD3 жыл бұрын
Thanks? :)
@qadeerkhan27652 жыл бұрын
A1
@599CD2 жыл бұрын
Thanks
@husseinmallah17192 жыл бұрын
Your instructions helped a lot; I am trying to do a small app for Members and their payments for a Veterans Non-Profit Org. I tried the Search, but I got an error "94" Invalid use of Null. This is the code I used Private Sub SearchbyLastName_Click() Dim S As String S = InputBox("Please Enter Last Name", "Last Name", LastName) If S = "" Then Exit Sub Me.Filter = "LastName LIKE ""*" & S & "*""" Me.FilterOn = True End Sub This error comes up after I do a search that is not available.