Microsoft Access Search Form - MS Access Search For Record by TextBox

No video

Microsoft Access Search Form - MS Access Search For Record by TextBox

Рет қаралды 337,492

Күн бұрын

NEW!!! See the updated version 2.0 video: 599cd.com/Sear...
You will learn how to build a Customer Search Form in your Microsoft Access database. We will create a blank form with a text box to type in your search keyword, and a list box to show the results. There will be a tiny bit of VBA code (one line) to requery the customer list.
Here are some other helpful links to more free tutorials I mentioned in the video, including the Search As You Type form I mentioned in the tip video:
ACCESS DEVELOPER LEVEL 8: 599cd.com/XQBGSB
LIKE KEYWORD: 599cd.com/XACB5
EVENT PROGRAMMING VBA: 599cd.com/XVRK8T
Here's a link to my FREE full Access Level 1 course here on KZfaq:
• Microsoft Access 2013 ...
(Yes, it says Access 2013, but it's perfectly valid for 2016 and every version past 2007).
And here's a link to get my full LEVEL 2 course for just $1:
FULL LEVEL 2 COURSE FOR $1: 599cd.com/XFREE1YT

Пікірлер: 223

@DianaEvans1228 5 жыл бұрын

I have been trying to find a simple and straight forward way to complete this task. You nailed it for me. Thank you.

@599CD 3 жыл бұрын

My pleasure

@taylorharrison4303 3 жыл бұрын

my exams are on monday, you answered my question in a minute and thirty eight seconds, bless you

@599CD 3 жыл бұрын

Thanks

@yalbaseer 3 жыл бұрын

A well-explained lesson. I followed the steps and got what I wanted. Thank you very much.

@599CD 3 жыл бұрын

Glad it helped!

@LavonYoung1 Жыл бұрын

Like the way You explain things. You get to the point and don't talk forever. They you show by example.👍

@599CD Жыл бұрын

Thanks

@freddiemortos8519 6 ай бұрын

Thank you so much sir..Slowly I'm completing my costumer records and improving it using your tutorials.

@599CD 6 ай бұрын

Awesome. What kinds of costumes do you create? Halloween? LOL. Just messin' with ya. :)

@freddiemortos8519 6 ай бұрын

😂😂😂LOL Halloween 🤣. I've just created a record for my Electronics repair business sir😁, so that I can easily search for my costumers record. I followed your great tutorials and walla I successfully made it😊. Now my question is how can I improve it more? I mean, what I want now is if I search for the name and double click on it,it will show me the record of that particular costumer? Can you point me to your tutoial sir? Thanks so much🤩@@599CD .

@ajn4753 2 жыл бұрын

I wish I watched this a couple days ago, before I stumbled through a bunch of highly complicated macros to no avail. Thanks for yet another simple lesson!!!

@599CD 2 жыл бұрын

Glad it was helpful!

@thaneshrajendran5081 Ай бұрын

Pls share the continued videos of next steps. If I need to double the selected customer I need to go to the customer record

@rowellamichaels Жыл бұрын

Great, I am now binge watching your videos!

@599CD Жыл бұрын

Glad you like them!

@TheCoolHandFluke 11 ай бұрын

Excellent, Helpful and able to meet my needs. What video explains how to select the record from the search results and open the master table so you can edit the master table, or if the search results in no matching records, the ability to start entering a new record in the master table. I have already created a master form from an earlier video now I need to link the two processes.

@jakemasters3208 Ай бұрын

Hi - I’ve implemented this with great success so I thank you. I’m trying to develop my database further however I’ve hit a roadblock, it seems this method only works where the field is short text, however I wish to search a long text field - is this possible? If so how?

@Goesserandmore Жыл бұрын

Very good explanation. This is exactly what I was looking for. Thank you! Nevertheless, compared to the FileMaker database, Access is far too complicated for a normal user. I wonder why Microsoft can't manage to get a really user-friendly database up and running.

@wrightpc1215 3 жыл бұрын

Thank you I will be signing up for some classes very helpful and very well explained thank you sir

@599CD 3 жыл бұрын

Thanks and welcome

@damon98xp 2 жыл бұрын

Excellent tutorial, Thank you from Taiwan.

@599CD 2 жыл бұрын

Welcome

@khaleeltonnimeeran972 3 жыл бұрын

Interesting... Learnt a lot from this video.. Thank you

@599CD 3 жыл бұрын

Glad it was helpful!

@haninalyahya2888 6 жыл бұрын

I just finished ur access level 1 series and they're helpful! thank u so much, can't wait to learn more from you.

@599CD 3 жыл бұрын

My pleasure

@pyarenabikipyarinaatein6149 Жыл бұрын

nice to watch this video, helped me to learn more from this? sir I have a question, can we make a search form from where we can enter any information like customer name and when we click on search button specific record from customer form displays? how can we make such search, please guide

@599CD Жыл бұрын

599cd.com/SearchButton

@shahulmohideen3685 4 жыл бұрын

Nice Tips. Thank you very much. Its very useful for my programs.

@599CD 3 жыл бұрын

You are welcome

@leeavo2302 5 жыл бұрын

i am getting an error message 424 when i try to conduct the search

@deybicocluso6 4 жыл бұрын

Probably your code in the [after update] section is incorrect. Make sure you referenced your list displayer well and added the right code.

@599CD 3 жыл бұрын

Start over. 150,000 other people had no problems. :) When in doubt: 599cd.com/Trouble

@olliwest7341 2 жыл бұрын

The is most likely an object reference error. Make sure that whatever you label your "List Box" is what is referenced in your VBA. For example: In the video he named the List Box "SearchList". So his VBA code appeared as follows: Searchlist.Requery. If you named your List Box for example: ListBox 1. Your VBA code would be: ListBox 1.Requery.

@ahmadzafar5051 9 ай бұрын

Great video. But on 7th minutes code builder here. Run-time error '424': Object required

@599CD 9 ай бұрын

Well, ya did somethin' wrong. :)

@ahmadzafar5051 9 ай бұрын

@@599CD sorry i don't understand

@jaredmigeta5618 2 жыл бұрын

youre very helpful to every , every minute. Thank yuo

@599CD 2 жыл бұрын

Welcome

@dimerciabaruani 3 жыл бұрын

SUBBED! my favorite tutorials on the web rn. can this be applied to a date field as well?

@599CD 3 жыл бұрын

Yes, definitely

@Phone_Geek 4 жыл бұрын

just what looking for as a beginner. thanks! will be looking at your other vids!

@599CD 3 жыл бұрын

Glad it was helpful!

@jupiter2479 5 ай бұрын

but what if some of those field equal Null? They just don't show up before the search.

@therandom7153 4 жыл бұрын

The search list doesn’t update when the new criteria is put in

@carolinamendizabal7545 4 жыл бұрын

First, it didn't update but then I realized that when I hit tab and the down arrow it prompted me with the right search.

@599CD 3 жыл бұрын

Yeah... what she said ^^^ :)

@mali5591 Жыл бұрын

you bad boy! Complicated made simple! Thank you, just one, is there a way of adjusting the TABLE size within the list box?

@599CD Жыл бұрын

You mean the column widths? Sure. It's a property. Also make sure you see the newer video: 599cd.com/Search2

@UsmanGhani-de1mz 3 жыл бұрын

Dear Sir, i Watch you regularly and learned very much. Sir i need your help that when i use generated database to another system its setting looks change, plz tell me how to fit it any system

@599CD 3 жыл бұрын

Not sure what you mean.

@eyezeezeeoh 3 жыл бұрын

Great tutorial!!! I've never used access before and I created a database from Excel in one afternoon. This is super helpful! My only question was after I hit tab and have results come up, is there a way to clear the search box and have all the items in the list show back up?

@599CD 3 жыл бұрын

Yes, I'll be showing this in a followup video.

@sasaxu5585 3 жыл бұрын

Great Course! Thank you!!! Also, I have 2 questions: 1) Is there a file size limit to attach a PDF to Access? 2) If a PDF has more than 10 years of data to import into Access, how much might it slow Access down? Please let me know. Thank you so much!!!

@599CD 3 жыл бұрын

1) Don't use attachments. Link to the file if you want, but don't store it in your database. See 599cd.com/Images. Same concept. 2) See #1.

@vasilisavasya4245 5 жыл бұрын

thank you, very good and clear tutorials

@599CD 3 жыл бұрын

My pleasure.

@matthewsharpe4273 4 жыл бұрын

Needed a quick how-to on displaying a list from a table, very helpful. Going to run over to Developer 8 about this auto-update on type versus after update! Much obliged!

@599CD 3 жыл бұрын

My pleasure.

@shileshia 5 жыл бұрын

Very helpful. It has been a long time since I have been access so the refresh is nice. I will be checking our your other courses.

@599CD 3 жыл бұрын

My pleasure.

@lisacalhoun306 5 жыл бұрын

Great video! Super helpful for protecting tables from non-developer users!

@599CD 3 жыл бұрын

599cd.com/Encryption is the only thing you can do short of using SQL Server

@user-hm8wz4vp8l 5 жыл бұрын

Is there a way to show the field headers on the list box?

@599CD 3 жыл бұрын

Yes, but I don't recommend it. Put labels over the box.

@HabibiComeToCali 3 жыл бұрын

Great tutorial. very simple i have successfully created using your directions sir. when the search results are shown on my form they are editable. and can be deleted. if i tried to restrict it ...the search bar is also restricted and i cannot enter anything to search. how can i restrict the searched records on the form.?

@599CD 3 жыл бұрын

I'm sorry but I don't understand.

@bismarkaboagye2662 5 жыл бұрын

Wow.. Video on point... Thank you sir

@599CD 3 жыл бұрын

My pleasure.

@natashaaustin7137 2 жыл бұрын

Great tutorial! Is there a way to open the search result to allow you to see the full record?

@599CD 2 жыл бұрын

Sure. Add a button. 599cd.com/Blank

@ChocaZed 4 жыл бұрын

noob here, it works great thanks!

@599CD 3 жыл бұрын

My pleasure.

@mervynlewis4416 4 жыл бұрын

Thank you for the tutorial. I have a problem when I search it asks for me to enter the parameter value. Any ideas?

@599CD 4 жыл бұрын

Access can't find a field. You probably spelled it wrong.

@mdsalahuddin2846 5 ай бұрын

great sir

@GSFRANKy 3 жыл бұрын

Thank you so much for the video. Is it possible if the list box to be empty(no records displayed) when I open the form and display the records after the searching?

@599CD 3 жыл бұрын

Sure

@yunengtan3689 2 жыл бұрын

Very informative video ! I have a problem which my data is a long text and it does not appear in the listbox option when I wish to select it. Do you have any suggestions to solve this problem ?

@599CD 2 жыл бұрын

Can't put long text in a list box. Use short text.

@creativeacademy1175 5 жыл бұрын

Super description. Love you sir

@599CD 3 жыл бұрын

My pleasure.

@danielbrandstetter8713 2 жыл бұрын

Great video. Question though: is there a way to make it requery on every keypress? So that I get live updates as I'm typing? I tried the "on keypress" event, but it doesn't seem to trigger unless I click outside the searchbox and back into it

@599CD 2 жыл бұрын

Sure. I cover that in 599cd.com/ACD8L

@paulho2282 5 жыл бұрын

Very helpful, thanks Richard

@599CD 3 жыл бұрын

My pleasure.

@sujayshil5830 3 жыл бұрын

Sir, you have uploaded a great video. But sir if I want to create every day's records altogether of a customer then is it possible in ms access ?. If possible then please create a video about it. If not then possible in visual basic ? Please create a video about it.

@599CD 3 жыл бұрын

It's certainly possible. Sounds like you need an Aggregate Query with a Group By Date. 599cd.com/XACX11

@azmanazlan9941 Жыл бұрын

Hi, why does the 'Enter Parameter Value' box appear... caused by... Like "*" & [Form]![SearchF]![SearchBox] & "*"

@599CD Жыл бұрын

599cd.com/EPV

@shayan1181 5 жыл бұрын

Very Interesting tip. Thank you.

@599CD 3 жыл бұрын

My pleasure

@vkaariainen 3 жыл бұрын

Access Newbie here. I managed to do Search function in the video. However, I would like that the selected value from the ListBox is passed/copied to other TextBox. This should be simple but I have spent hours to find help.

@599CD 3 жыл бұрын

You'd need an event in your ListBox (or a command button) to then set the value in whatever field you want. See: kzfaq.info/get/bejne/hL6XotCIrZqmoX0.html

@jeanninefisk9868 4 жыл бұрын

I believe that I'm doing this exactly as you show how it's done. I'm, unfortunately, not getting their first name in my list box. What am I missing?

@599CD 4 жыл бұрын

Wish I could tell you, but without seeing your database it's impossible for me to say.

@JackeyTranArchives 3 жыл бұрын

Thank you so much, this is very helpful. I have a situation where if a record has a null value for the column we are applying the LIKE condition in, then the row does not appear in SearchList at all. What can I do if there is someone without a LastName? Say, Cher or Madonna for example?

@599CD 3 жыл бұрын

If you want to check specifically for a NULL value, then you'd have to say: IsNull(LastName)

@JackeyTranArchives 3 жыл бұрын

@@599CD Thanks Richard. Although, my scenario is: I have null values in my LastName (FirstName is present). After I input the LIKE criteria for LastName and open form, before entering any value, all records with null LastName is automatically filtered out.

@JackeyTranArchives 3 жыл бұрын

Seems I have figured it out. The nature of the SQL view is super convoluted (don't even wanna look at Design view). I had to write up 4 scenarios of LIKEs ANDs and ORs statement. Ended up writing about 108 lines of code, give or take. But, all in all, I wouldn't have gotten even the beginning parts done without your tutorial.

@599CD 3 жыл бұрын

I'm glad you solved it. That's the best way to learn... figuring it out yourself. I've had MANY nights of pulling my hair out trying to figure out why something doesn't (or DOES!) work. One of my favorite memes: 599cd.com/a?26065

@azizuddinabdullah1010 2 жыл бұрын

Good videos. But i have problem. The list box do not show the list. Can u help me?

@599CD 2 жыл бұрын

Not without a whole lot more information.

@azizuddinabdullah1010 2 жыл бұрын

Its okay. After tried a few time it works. At first it doesnt work bcs of i did not put formula LIKE "**

@piradext 3 жыл бұрын

It helps me a lot! Just one thing: i want to redim the columns on the listbox, is this possible?

@599CD 3 жыл бұрын

I don't understand what you mean by "redim." You want to change what columns are there? Sure. Go ahead. Customize it however you want.

@piradext 3 жыл бұрын

@@599CD Sorry. By redim i mean I want to chage column width depending on the results I have. For example: Let's assume that my qry has only one column. If my result is "Raj" I dont need a large column, but if my result is "Rajesh kootrapalli" then i need to make it larger than normal. Is this posible to do?

@599CD 3 жыл бұрын

Yeah... changing the width of the columns is definitely possible, but difficult. With a fixed-width font like Courier you could know how wide to make each column, but with most fonts, you'd have to guess. All you have to do is change the ColumnWidths property, but again, it's a guess based on the number of characters. I'll add this to my list for a possible future video... but the list is quite long. Lots of members have questions in first. Love the Big Bang Theory reference. :)

@piradext 3 жыл бұрын

@@599CD all right, I'll try to do what you said. Thanks! Ps: The Big Bang Theory is awesome 😎

@ArtyomGalstyan 3 жыл бұрын

What if I have a sentence in each record, and i need to search for the specific word within each sentence in my records? Does MS Access have full text search support?

@599CD 3 жыл бұрын

Sure. You just need to use the LIKE keyword. 599cd.com/Like

@conghanh3002 Жыл бұрын

I get an error about the search form when transferring files from one computer to another, I can search when the file is on my computer, but I can't search on someone else's computer.

@599CD Жыл бұрын

This sounds more like a networking problem than a Microsoft Access problem.

@shaheentanoli1972 3 жыл бұрын

Hi Richard I have a field in table , Named, Amount. But In the report i want to display the same field data in across column. How can i get the sum under each column. Any help please

@599CD 3 жыл бұрын

Sounds like you need a crosstab query. 599cd.com/Crosstab

@quincyirang2543 3 жыл бұрын

Hello, I use this method on access 2007 and it works. But in access 2020 it doesn't work. At first I checked 4 fields in Query, but when I opened the List Box Wizard , it only appear 1 field. Any other method ?

@599CD 3 жыл бұрын

It should work. Make sure you followed all the steps. I'll be updating this video soon with some new stuff.

@RangelDirector 2 жыл бұрын

Hello, this did not work for me... Please help: I followed everything step by step but there when I finish the List Box, no values come up.

@599CD 2 жыл бұрын

Try again.

@enikobakonyi1843 Жыл бұрын

This is a great tutorial, but I couldn't quite complete the form. I followed all the steps, but at the end in the search box I now have #Name? and I can't use the field to search. Where did I go wrong?

@599CD Жыл бұрын

#Name? usually means something is spelled wrong.

@vickihudson4952 3 жыл бұрын

my query is working but results do not show up in my SearchList? Any ideas. Is there supposed to be a record source for the form like SearchQ?

@599CD 3 жыл бұрын

Nope. The form is unbound. Check your spelling. #1 problem.

@kathrynbennett7342 5 жыл бұрын

Process didn't work for me.

@599CD 3 жыл бұрын

If at first you don't succeed... you know what comes next...

@overwhelmingcalm1851 3 жыл бұрын

Smashed that subscribe button. GREAT content.

@599CD 3 жыл бұрын

Sweeeeet!!!!

@rafjan89 3 жыл бұрын

The after button is not working after i close my file.. When i check, the after button properties is on click.. How to solve this? Happen everytime after i close my files and reopen

@AnasAlyousofi 2 жыл бұрын

How do we search a form inside another form?

@599CD 2 жыл бұрын

Subforms are tricky. 599cd.com/SearchSeminar

@rubydona 4 жыл бұрын

hi tnx for your video...i have a question .hope you can help me, how can I put my birthday queries list in a form? i want my queries be put in form so that it will be easy from me to look up the list of our members who will be celebrating their birthday a week before Sunday. Ex. I want to know who will be celebrating their birthday before March 8 regardless of the year..hope you can help me to do that. tnx God bless you

@599CD 3 жыл бұрын

This is close: kzfaq.info/get/bejne/bNJxateCqa2weIU.html

@joernqai7944 3 жыл бұрын

it works fine until i save the files and then reopen the access file again and the requery list not working anymore. Any idea why this happen?

@599CD 3 жыл бұрын

No idea.

@piotrratajczak1773 5 жыл бұрын

Dear Sir is it possible to add to this searching from an deleting button?

@599CD 3 жыл бұрын

Yep.

@donvilleneuve8021 Жыл бұрын

i added a new ID 97 (AUTONUMBER)to my table and my search button will not return id 7 when enter 7 in the search box it returns 97 the new ID? but 17 27 27 47 57 67 77 87 are all fine. this has me really confused????

@599CD Жыл бұрын

599cd.com/ask

@liamhelfrich2411 3 жыл бұрын

It worked perfectly for me until I restarted Access. Now it won't read in the textbox value and instead asks me to enter it as a parameter every time I open the form. I redid the query from scratch and it still won't work, even though the autocomplete recognizes that the textbox is there. What's going on? Update: Completely deleting both the form and the query and making new ones worked. It seems something got changed or corrupted somewhere and caused it to stop working. I'm still not sure what broke it in the first place.

@599CD 3 жыл бұрын

Interesting. Sometimes starting from scratch fixes weird problems. Also, be sure to check out my troubleshooter: 599cd.com/Trouble

@jsong3799 5 жыл бұрын

Amazing. Thank you

@599CD 3 жыл бұрын

My pleasure.

@paulheath4540 5 жыл бұрын

At Last... THANK YOU !!!

@599CD 3 жыл бұрын

My pleasure.

@miko25ful 2 жыл бұрын

Dear Sir! I need help... In regards to this list you just made, I`m trying to do the same, but with a search button. So I have a text box where the user should entry a last name, and a list that shows all current users. The user should enter a last name, press search and only the last name the user puts should come up in the list below. Do you have a video that shows how to correctly set this up. I'm struggling to correctly set the search button up...

@599CD 2 жыл бұрын

599cd.com/SearchCombo

@miko25ful 2 жыл бұрын

@@599CD thank you!!! :)

@drallisimo34 5 жыл бұрын

cool tut!!!

@599CD 3 жыл бұрын

My pleasure.

@dardeejaycalura927 2 жыл бұрын

How do you requery using a button?

@599CD 2 жыл бұрын

What form?

@gamekamajalo1599 4 жыл бұрын

nice tutorial. :)

@599CD 3 жыл бұрын

Thanks. :)

@dolphinplaygames3106 3 жыл бұрын

is it possible to do this with a combo box ?

@599CD 3 жыл бұрын

Sure. I'll probably cover this in an upcoming video.

@vinto69 Жыл бұрын

This just does not work... dunno why... i did it exactly as you did, but it is not updating when i type in... it only updates after some random cliks into the textfield

@599CD Жыл бұрын

can't tell from here

@jontucker2582 4 жыл бұрын

okay so i tried to follow the video to the letter. even named everything that you did. does not update when i press tab or enter. I copied exactly what you did even changing of the color and still does not auto update.

@599CD 4 жыл бұрын

You must have missed something. 100,000 people have viewed this video, so I know it's right. :) Without seeing your database I really can't tell you what you did wrong though.

@kurtturner5120 3 жыл бұрын

Hello. What would be the VBA code to make a button to clear the search box?

@599CD 3 жыл бұрын

SearchBox = "" That's all. You can clear any text box that way.

@kurtturner5120 3 жыл бұрын

@@599CD Thanks! I stumbled on your videos by chance. I know 0, so I'm starting at the lesson 1. I look forward to learning a new skill. Your teaching method is spot on!

@williamnovarese51 4 жыл бұрын

Couldn't get this to work Access 2007.

@599CD 3 жыл бұрын

It should work fine in pretty much every version of Access from 2007 on.

@Ali-uz8qg 5 жыл бұрын

In the searchQ (Query) when I changed the criteria from a wildcard (Like) to be Exact, meaning I removed the (Like "*" & ) and at the end (& "*") the searchF doesn't show any data. The search doesn't work.

@SouthParkXVIDS 5 жыл бұрын

=[Form]![XXX]![XXX]

@599CD 3 жыл бұрын

What ^ he said

@GainTECH4IT 4 жыл бұрын

Nice i get success. but for the second record i need go back no live update.

@599CD 3 жыл бұрын

Keep trying

@SouthParkXVIDS 5 жыл бұрын

I am trying to have a search button that when hit will display the selected "Search" information that contains that. Example: If I hit NFL in the search. I would like my form to display all teams that associated with the NFL. (That is not my real project) but I work for a company and don't want to put information out there. I right now have a Form that has my search command button and then a subform inside that and that is where I want the information to be displayed. I have ran code expressions, simple queries such as =Form XXXXX , Like "*" & xxxxxx ... Let me know if you can help me.

@599CD 3 жыл бұрын

599cd.com/Like

@emanyounis5694 4 жыл бұрын

Nice😍

@599CD 3 жыл бұрын

Thanks

@kabir73722 3 жыл бұрын

Dear when i press Tab button nothing happen?

@599CD 3 жыл бұрын

Press it again. :)

@celinebalay2899 3 жыл бұрын

I followed every step three times over and the tab button won't actually narrow down the search results. Any ideas about what's happening?

@599CD 3 жыл бұрын

No, sorry. I've taught this exact example in my classes for years. Not many people have problems with it. The number one culprit is usually a misspelled field name.

@celinebalay2899 3 жыл бұрын

@@599CD I finally got it! Thank you :)

@MyArtsandTips 2 жыл бұрын

Great

@599CD 2 жыл бұрын

Thanks

@chestacupoftea2342 4 жыл бұрын

i LOVE YOU!!

@599CD 3 жыл бұрын

Awwwww..... so sweet of you. My #1 fan?

@zuberareef8655 5 жыл бұрын

welldone

@599CD 3 жыл бұрын

My pleasure.

@MrSuraj2me 4 жыл бұрын

I got error text box enter parameter value

@599CD 4 жыл бұрын

Something is probably spelled wrong

@rinehartbrent 3 жыл бұрын

Richard or anyone this has to be simple and I am just having a loss of memory, trying to ask user for input with a input box and open another form to that record if found, but it keeps telling me data type mismatch my field on other form is test and I have dim my variable a s a string. What am I missing? Private Sub SearchL_Click() Dim S As String S = InputBox("Please Enter Purchase Order Number", "Search for Purchase Order") If S = "" Then Exit Sub DoCmd.OpenForm "JobF", , , "PO=" & S End Sub

@599CD 3 жыл бұрын

S is a string, and I'm assuming PO is a string, therefore you have to treat it like a string in your criteria expression: DoCmd.OpenForm "JobF", , , "PO=""" & S & """" See this video: kzfaq.info/get/bejne/jJ2TnLR02qq3hZ8.html

@rinehartbrent 3 жыл бұрын

@@599CD @Computer Learning Zone Thank you Richard I remember you telling me this all to well the one concept that plague me to this day i need to practice practice practice because this is probably still the hardest to grasp even when you lay it out as well as you did for me in that tutorial. It worked beautifully now I just needed error handling when what they type is not in the database. I will attempt that one next.

@599CD 3 жыл бұрын

A little DLOOKUP should solve that problem: 599cd.com/dlookup Don't forget to wrap it in an NZ: 599cd.com/nz

@lindseyoneal4602 3 жыл бұрын

It didn't work for me... I search the name and nothing comes up. I followed everything step by step

@599CD 3 жыл бұрын

Well, you may have missed a step. Try again.

@RealAlexMoreton 3 жыл бұрын

HERO!!!!

@599CD 3 жыл бұрын

Superman and I have never been seen in the same room together... just sayin'.

@ricardssencenko3209 5 жыл бұрын

Something went wrong for me. When I type the surname results dont change.

@fuego09esmeralda 5 жыл бұрын

In the example described on this video, the list refreshes only until you press tab or enter... (8:05)

@Ali-uz8qg 5 жыл бұрын

@@fuego09esmeralda - For me it worked fine. But In the searchQ (Query) when I changed the criteria from a wildcard (Like) to get exact search data, meaning I removed the (Like "*" & ) and at the end (& "*") the searchF doesn't show any data at all. The search doesn't work. Would you know? Appreciate your time. Thanks.

@599CD 3 жыл бұрын

We have a correct answer. :)

@dbdata9836 3 жыл бұрын

well but where file?

@599CD 3 жыл бұрын

This video was created long before I was saving the files for download. Now Gold Members on my channel can download all of the databases I make in my TechHelp videos. 599cd.com/Members

@KimoraMyliaa 3 жыл бұрын

I’ve followed this tutorial 4 times and I’m not sure why I can’t get it to work for me. I get a error message every time I write the line of code ...😭😭

@599CD 3 жыл бұрын

Can't tell without seeing your code. Sorry.

@KimoraMyliaa 3 жыл бұрын

@@599CD I ended up doing it using one of your other tutorials! Thanks