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!
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?.
I get a ton of questions every day, and I don't have time to answer them all here on UA-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
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!
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?
@@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?
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.
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?
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?
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/UA-cam-Submit-Question
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
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?
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/UA-cam-Submit-Question
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.
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.
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.
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 ?
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. 👍✌
@@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.
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?
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
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.
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
@@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.
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
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?
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?
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
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.
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?
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.
Docmd.Beep I have ZERO control over billing on UA-cam. 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.
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.
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
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
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
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
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.
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
@@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
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
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.
@@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!!
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
@@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.
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.
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.
Welcome
Nice one Richard. Not many people on YT can give such clear explanations on this subject like yourself. Much appreciated.
Glad it was helpful! I appreciate the compliment.
Thanks to whoever for inventing this, and thanks to you for teaching it, Richard! Gosh, this is just what I needed.
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!
Thanks Richard, I have learned a great deal from your Videos. Well done, clear voice, no fluff.
Great to hear!
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 !
Thanks
Very useful and comprehensive lesson.. Thanks Richard for your efforts to spread knowledge.
My pleasure!
Thank you Richard for the video. do you have one for error handling?
I've got a TechHelp on error handling coming out soon. I cover it in detail in Developer 2 and 15. 599cd.com/ACD2
Hello Sir, How about two input box to search? in one code?
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?.
Sure, ask them if they want to add it, then add it. :)
Great Video. What if the field is a lookup, where the saved value is not visible?
I get a ton of questions every day, and I don't have time to answer them all here on UA-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
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!
Sure, you can use date fields. Just make sure to enclose date criteria in # signs.
@@599CD Thanks for the quick reply!
Thank you very much Richard, this was really useful. Like your teaching style, no messing around !
Glad you enjoyed it! I do my "messing around" in the Extended Cuts. :)
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?
Impossible to tell without seeing what you've done
@@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?
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.
Sure. That would work.
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.com/Ask
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?
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/UA-cam-Submit-Question
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?
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
599cd.com/Search2
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?
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/UA-cam-Submit-Question
Thanks Richard! Question for you. How would I display a message that no results were found if a search is done and nothing matches?
599cd.com/DCount perhaps? This would involve some coding.
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.
599cd.com/ask
Thanks for this great video! What if the Search doesn't match anything? Is there a video of yours that goes into this?
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.
@@599CD Thanks very much for the quick reply. I appreciate the help!
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.
Remove the quotes if it's a number
Cool n simple video. Best method
Glad you think so!
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 ?
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
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. 👍✌
Welcome
@@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.
When I go to build even my code builder screen doesnt look what you were working on, cant see where to type in code?
.
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?
I don't see why not. Give it a try.
Hi, I am wondering whether its a simple change to the code to have it search for a last name in a separate form?
Shouldn't be that hard
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.
Feel free to submit this: 599cd.com/TechHelp
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?
ComboBox.Column(1)
this is so useful! thank you so much!!
You're welcome
Maybe a silly question - why is it called the "binoculars" button when the image sure looks like a magnifying glass?
That's above my pay grade
Where is the free Customer Template? Can't find it here. Many thanks.
599cd.com/Blank
Please how to exit after search
Okay I'm way late to the game, but you blew my mind with double-clicking the ribbon header to hide/unhide WHAT
Hi Richard, may I ask how did you make the "Main Menu" button? thank you
See 599cd.com/Blank
Thank you so much for all the help.
You're very welcome!
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
i have a question when i enter the customer ID for exg it dont show the other information
Huh?
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.
That's weird. Check: 599cd.com/Trouble
What if we are searching a number? How would that change the code? Thanks.
Don't use quotes
great..!!! I think this explains cmd button well. thank you dear...
You're welcome, lovey. :)
This is really good. Thanks so much Richard.
You're very welcome
Hi great another video steve
Thanks
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.
Well try it again and try it with a different database
I am very interesting to fowling your lessons
Thanks
Can you create a button to delete it after finding a contact?
Sure
Excellent! I very much like your videos - well paced and excellent content. Thank you so much.
You're very welcome!
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
You mean a Continuous Form? 599cd.com/Continuous
@@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.
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
I have my staff type Control F with cursor in the field to search. Works very well.
Yep! That works too.
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?
DoCmd.OpenForm with a WHERE criteria 599cd.com/ACD1
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?
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
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.
Are you getting this: 599cd.com/EPV
Why does my Access 2019 not show the first 2 private sub details as in this video ?.
That's code from the other buttons on my form.
Thanks so much, the tips are really useful
Happy to hear that!
How can I have a report query data based on a drop down list?
599cd.com/FormName - just use a combo box instead of a text box
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?
Check your spelling.
@@599CD I've checked spelling but it still happens. when I use msgbox s the input provided is correct. Any other suggestions?
Never mind! If found the misplaced "space" in my expression. Works well!!! Thanks for a great video.
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.com/ask
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.
Docmd.Beep
I have ZERO control over billing on UA-cam. 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.
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.
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
very works
Very works, indeed!
Thank you very much...
Welcome!
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
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
Good video's
Thanks
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
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.
@@599CD hi can you please help me to complete my database? i will be very thankful to you
Sure. 599cd.com/Consulting
If you do a search from a blank record, it gives this error here also. From a filled field it works great!
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
Ok I got this :
After : Me.FilterOn = True
If Me.Recordset.RecordCount = 0 Then
Me.FilterOn = False
Me.Filter = ""
End If
Yeah, that'll work. :)
Thank you
You're welcome
showing problem in s = inputbox(please enter..)
I need more info to help you.
@@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
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
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?
Did you follow the steps from the video EXACTLY?
@@599CD For the search button part, yes. but I worked on my table.
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.
Super ❤️❤️❤️
Thanks
For some reason this is NOT working for me - frustrating!
Sorry. Try again. Also see 599cd.com/Search2
when i click on "Build Event" and try your coding, my display came out different lol I give up!
Well... that happens. Maybe start here: 599cd.com/IntroVBA
@@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!!
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
Plz make systrm hoepital in access 🥺
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
It did not worked for me.😭
HELP ME PLEASE. 😭😭😭
Try it again. Follow my video exactly from the beginning. It'll work.
The reason, it didn't work because mine is MS Access 2007 😭😭😭
@@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.
🌸🌸🌸
Thanks? :)
A1
Thanks
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.
You shouldn't get that... just an empty form.