Thank you! I haven't tried it yet BUT having trawled through the Internet again and again looking for form access multiple fields and only finding complicated solutions, I added the search criteria "simple" OR "easy" and yours was the first result. Bingo! Thank you again from England.
I used this video along with a database I made to figure out which SIM cards go into what smartphones based on Manufacturer/Model. I was wrecking my head all day trying to find a way to do this and this video was PERFECT. Thank you so much!!
You're absolutely right. Again, thanks for taking the time to share your valuable input. I try to impress the "this is a quick tip, see my full tutorial for lots more information" message in these short tutorials, but you're definitely right that this technique is only for the simplest of uses. On a side note, I just want to say that I love your books. Your Access 2010 Inside Out and Building Access Applications books are two of my favorite Access books - and I have a LOT. :)
I did figure out a solution, but not in query form. My solution was to add a default value to each searchable field on the form I use to input information. Each searchable field is a simple text box. In design view, I opened the property sheet, and clicked on the text box. In the Data tab, there is an option for a default value. I use "-" as my default value, so that when I don't have information for a particular field, there is at least something to show the field is not null. Works great!
Love them. In fact, Inside Out is one of the books I routinely recommend to my customers who ask for a great reference book to keep on the shelf for Access developers.
You are correct, John. Thanks for sharing. Obviously if you have much larger sets of data, you need to adjust your approach. This is only a brief tutorial for "novice to intermediate" users. In my full seminar I go over more advanced techniques, such as writing custom SQL statements in VBA to get exactly what you want.
You are correct. Looking for blank values gets a LOT more complicated. I'm addressing this issue in my upcoming Access Search Seminar which should be out later this week. You basically have to use IIF and IsNull functions to handle this.
This video is the best video ever written for Access. I followed the instructions step-by-step however I am still having an issue with my query. When I search, no results are given. I know I have something out of place...I just don't know what. How can I troubleshoot and fix?
Thank you! Self taught in everything I use at work but many years in the past. Hadn't built a DB our a query in about 4 years and this was the best refresher I could have used.
Sure. Just feed to search results into a blank form with a list box, then have an On Double Click event for that list box to open up the record in your form. I cover this in detail in my forthcoming Access Search Seminar (which should be out this weekend).
I want to create a search form that also includes searching between two dates. Also after following this video, my name search does not filter, but selects all names. Love your tutorials.
This can be tricky with multiple fields. Sometimes even wildcard searches don't work with NULL values. I'll be covering this in depth in my upcoming Access Searching & Sorting Seminar... and I'll try to post a tip video about this on my Channel.
What can I say Mate. You're the best!!! I'm wrapped to get your response and attempt to assist me. I did actually follow your lesson from my PC with my laptop doing the work... However, I will try building your data base and see if I can work it out from there. Again, THANKS!!! Your lessons are truly inspiring and assist people who would not otherwise have the support to get their head around Access. Cheers.
Well, I wouldn't put foreign and domestic students in two separate tables. I try to keep LIKE DATA together in the same table. If you want, use a checkbox (or a country field) to determine if they're domestic or not.
Please can you help me Richard, this tutorial was exactly what I needed for my database, I created exactly the same thing and it all worked excellent, but when ever I put in new records to my original table it is not bringing up new data. What am I doing wrong. I'm a complete novice so easy explanation would-be so gratefully received. Look forward to hearing from you
I'd really need to see your database to get a better idea of what you're trying to do. You can use the SUM function in the footer section to get a count of items.
These are cool tricks for novices, but LIKE *[Parameter]* is incredibly inefficient. Put 20,000 rows in your table and enter multiple parameters, and your query could take a long time even with indexes. Also, LIKE ** will NOT find any rows that have an "empty" or Null field. To do that, you would need to code your criteria like this: LIKE "*" & [Parameter] & "*" Or ([Parameter] Is Null) Do that for more than 3 parameters, and you'll get "query too complex" John Viescas Access MVP
You should keep your end-users in FORMS. Don't let them interact with tables directly. Watch my Access 2010 Beginner Level 1 course which is free here on UA-cam to get started. You'll find it on my channel page.
Great tutorial; I'm having difficulty implementing a multi-field search form using several tables with many-to-many relationships and lookups. For instance, I have one table listing foreign students, a second table listing domestic students, and a third table with classes, as well as junction tables between the class table and the two student tables. The objective of the query/form is to determine which classes two students (one foreign, one domestic) share.
This is a clear and easy to follow tutorial. Question. If one of the fields I want to search on is a date field (DD/MM/YYY), and I want to have on this form where you enter the year of the date only (YYY). How do I code that? I just want the user to type in the 4 digit year.
Hello, I followed your subject, the search(research) is great, only I shall like(love) that a field (exp: NumDossier) gives us exactly the figure to ask, otherwise he(it) shows nothing, not of *. Thank you
It's impossible for me to tell what you're doing wrong without looking at your database. I can tell you that I've used this technique in MANY of my classes and seminars, and it works in EVERY version of Access - as long as you follow the directions exactly. Try building the example that I build. Don't try to apply it to your database until you get that working first.
My table has male/female as varchar in one of the columns. Now, if I want to see only male records, I'll get the female records too, as it has 'male' in it. To eliminate this, I have tried using iif in the criteria field. But I face another problem where I need to check if my text field on the form has a 0 character string or a null value. It's getting complicated. Can you please suggest an easier way to do this? I'm using a lot of drop down options, check boxes, etc. on my search form
thank you so much. I'm a student and I have to build an application and one of the pages of this application will be a multi-field search form - I knew how to program it but the way I knew it was not really suitable for more than 2 fields (check if both are empty; then check if both are filled in; then check if one of them is filled in) so this is really handy. I'm using a newer version of access but I'm sure this will still be usable. thanks!
I'm not sure. I'd have to see your database to tell you what you've done incorrectly. You can send it to me via then TechHelp page on my web site if you want and I'll look at it when I have some time.
If the table structure is identical (or at least close enough) you could UNION them together and just search one resulting query. There are other, more advanced methods you can use that involve some SQL and VBA. I'll be covering these in my upcoming Access Searching & Sorting Seminar which should be available next week on my web site.
Sorry if this has already been asked, but what can I do if some information is missing? (eg: someone didn't enter their last name) at the moment entire records are not being searched for because of a few missing bits. Thanks for this video you are a hero!
Hi, did you solve this? I had the exact same problem, came up with a query statement to make a workaround. I ended up using lots of brackets and OR statements. Here's an example of a parameter query selection from a form (called Frm_Report_Query_Builder): Like "*" & Forms!Frm_Report_Query_Builder!Title & "*")) Or ((YourTableName.Title Is Null) And (Forms!Frm_Report_Query_Builder!Title="" Solved the problem of not returning results for nulls. Hope it helps.
This almost does what I am trying to do expect I'd like the search result to show up in a form instead of a table, any easy way to do this? Or show up in a table in the form below in like a list and then select one to show up in a form
This is brilliant I do have a question however. When using this to search through a table with lookup fields it doesn't seem to recognise them, only works with pure text entries. Anyway I can modify this to recognise the drop down list choices as well as search criteria? Thanks for a great tutorial!
What if some fields are blank in the search - it appears that there is no response for that row. Looks like all rows must have data in the search fields to get a response for that row?
thanx for the helpful video, I have a little question, I have Access 2010, I followed your tutorial step by step, but I stock in 7:13 , when I inserted the command button it didn't show me the window where I can choose the categories and Actions, would you please advise, thank you in advance :)
Hi - I'm referring to fields that use look-up tables and I keep getting their ID number instead of the text of the field - I know there's a simple fix and I've done it before - but it's been a while and I can't remember how to remedy this relationship issue so that my combo boxes in the SearchForm return the text category rather than their IDs...
I have a text field for gender whose value comes from a form. I have a complex interface for the query form. I have set the default values of all the text fields to null and now when the user selects from a drop down or radio buttons, the invisible text fields are populated with the values. When I run the query for the first time, it works, but when i try to play around wit different conditions,it does not return any value.I think I am facing this because of the default values in the text fields
Hi there. I input the formula exactly as you specified but using my own search form and field so it reads: Like "*" & [Forms]![ChemSearch]![Chemical] & "*" However, everytime I run the query, new data is not shown and if I open the query it comes up with "Enter Parameter Value. Forms!ChemSearch!Chemical!".
Hi thank you for your video. It helps me alot. I have a request can you make a video on how to get the person who will celebrating their birthday. A week before sunday. It will help me in our church. Tnx
Hi. I have followed the instructions on this tutorial but for some reason every time I run the query it comes up blank. This is the script I have used: Like "*" & [Forms]![F_Search]![First name] & "*" where F_Search is the name of my form and I have named the text box "First name". I have no idea why this is not working! Can you please shed some light on this?
Thanks for this video. All working fine, except it doesn’t include in the search any new records I’ve entered into the database since the query was built. Any advice please?
If your database is split properly, you should see the SAME data on all machines when you open a table, query, or form (that's based on the same table). Without seeing what you have there, it's impossible for me to tell you what's wrong, however.
Thanks for the video, it has helped me a lot. I'm not getting empty fields to show up in queries though. Like "*" & [Forms]![Job Site Search]![CityF] & "*" That combined with the other 3 fields I'm using should return any search criteria where there are empty fields? Yet all I see when I hit my 'run query' button is all records that are filled in completely. I've watched your video 3 times and been to your website as well. There doesn't appear to be anything else on the web for this either.
I am trying to make this form for a database at work, but every time i run the query I get zero results. I also have Access 2010 and have been following all the steps in the video. What could be causing the problem?
Incredibly helpful tutorial. Is there a way to search for more than one name? For example, I type Joe and Smith in Search and it outputs both Joe and Smith results. Thanks!
Some of the fields are currently blank for all records, these seem to be the ones giving problems. Should there be a reason for this? How can I get round it?
I have been working on this particular search form, however when I replicated exactly what you had at 5:15 but my results kept showing up blank. Even when I did enter something into the search form. I do not understand why.
Hi this is a great video and I was able to do this, but is there a way for the search results to come up in a form instead of the datasheet view? I want the whole process to stay within the form and never go to a data table because then the user will not know how to close that haha
I need to make a form with text boxes that can be clicked to enter a new customer (user is directed to Customer Table) or submit a work request, but I'm so lost. Can you help?
hello sir, i have a question, can i possibly display the query result below the search form? i think it would be great to see the query result on the same form after hitting the run query button, thanks!
Without seeing your tables, it's impossible for me to tell you what's wrong. Make sure you have connecting fields to form the proper relationships between those tables.
I tried that but the issue is I have Where Clauses so I have 4 different queries. Each query has a where clause. I basically want 1 report instead of 4 separate reports. All 4 queries come from the same table.
I'm trying to add a text field in which people have to type something, and accordingly a button which opens up a form/record of one person in the database. Yet, whenever I try to create the button, the value that people enter doesn't appear in the list of fields in my create button wizard, why not?
hi, im using access 2007, i copied this tutorial as an exercise and i'm wondering why my query table wont refresh like yours do, whenever i hit the "Run Query" Button i have to hit Refresh to see the latest result on the search that i typed in my form, mine does not automatically display the new values like yours do hope you could help me - thanks!
Thanks a lot sir! This has helped me tons. But I face a small problem, each time I have to search for something I have to close the form, the query table and open the form again and search to make the query run. Can you help me around this? Thanks
Hello this video was very informative! It helped me with a project at work. . Question, How would i have the selected record in the query show up in a Main Form that i already have. . The user could search based on their criteria, and then select a record from the query results, and have it open up in my "main form" is this even possible??? Thanks for any input.
Love it! Thank you. Just one question, how would you be able to create a query that can search through different tables all at the same time? I was trying to figure it out but wasn't able to. Hope you can help! Thanks!
That all depends. Are those tables related? If so, join them together. If not, you might be able to Union them together. 599cd.com/Relationships 599cd.com/Union
Hey, Great vid. Is it possible to run a search across multiple fields but only have one search box. An example from your video would be having a single search box, I type in "mi" and run the query. the query would return rows 1,2,4 and 6 as each of these have "mi" in one of the fields (Smith, Mike, Miami). Thanks
Thank you! I haven't tried it yet BUT having trawled through the Internet again and again looking for form access multiple fields and only finding complicated solutions, I added the search criteria "simple" OR "easy" and yours was the first result. Bingo! Thank you again from England.
Hope it works for you.
I used this video along with a database I made to figure out which SIM cards go into what smartphones based on Manufacturer/Model. I was wrecking my head all day trying to find a way to do this and this video was PERFECT. Thank you so much!!
Welcome
You're absolutely right. Again, thanks for taking the time to share your valuable input. I try to impress the "this is a quick tip, see my full tutorial for lots more information" message in these short tutorials, but you're definitely right that this technique is only for the simplest of uses. On a side note, I just want to say that I love your books. Your Access 2010 Inside Out and Building Access Applications books are two of my favorite Access books - and I have a LOT. :)
I watch this video in 2019 and express my deep gratitude. You really helped me. With love from Armenia!
My pleasure... from Florida in 2021. :)
I did figure out a solution, but not in query form. My solution was to add a default value to each searchable field on the form I use to input information. Each searchable field is a simple text box. In design view, I opened the property sheet, and clicked on the text box. In the Data tab, there is an option for a default value. I use "-" as my default value, so that when I don't have information for a particular field, there is at least something to show the field is not null. Works great!
Love them. In fact, Inside Out is one of the books I routinely recommend to my customers who ask for a great reference book to keep on the shelf for Access developers.
You are correct, John. Thanks for sharing. Obviously if you have much larger sets of data, you need to adjust your approach. This is only a brief tutorial for "novice to intermediate" users. In my full seminar I go over more advanced techniques, such as writing custom SQL statements in VBA to get exactly what you want.
You are correct. Looking for blank values gets a LOT more complicated. I'm addressing this issue in my upcoming Access Search Seminar which should be out later this week. You basically have to use IIF and IsNull functions to handle this.
This video is the best video ever written for Access. I followed the instructions step-by-step however I am still having an issue with my query. When I search, no results are given. I know I have something out of place...I just don't know what. How can I troubleshoot and fix?
Thank you! Self taught in everything I use at work but many years in the past. Hadn't built a DB our a query in about 4 years and this was the best refresher I could have used.
Sure. Just feed to search results into a blank form with a list box, then have an On Double Click event for that list box to open up the record in your form. I cover this in detail in my forthcoming Access Search Seminar (which should be out this weekend).
You can use the IsNull function or Is Null in a query criteria to find those blank records and enter the data.
I want to create a search form that also includes searching between two dates. Also after following this video, my name search does not filter, but selects all names. Love your tutorials.
This is such a great tutorial! Every single one of your tutorials are absolutely FANTASTIC!
And still are, with it now being Saturday, September 18, 2021. 👍😎
Thank you, from 2025. Oh wait... I set the DeLorean for the wrong coordinates again... hang on...
That bit starting at 5:45 helped me a lot. Coming from T-SQL and MySQL, Access is a bit fuzzy with operators.
It can be confusing if you're used to multiple versions of SQL. It got me too at first.
Sure. You could display the results in a list box or subform.
All you have to do is build the query and then use that query as the record source for the report or form.
I learn more than about your teach-thanks a lot
This can be tricky with multiple fields. Sometimes even wildcard searches don't work with NULL values. I'll be covering this in depth in my upcoming Access Searching & Sorting Seminar... and I'll try to post a tip video about this on my Channel.
I wish you were an instructor at my college, you made this so easy
What can I say Mate. You're the best!!! I'm wrapped to get your response and attempt to assist me. I did actually follow your lesson from my PC with my laptop doing the work... However, I will try building your data base and see if I can work it out from there. Again, THANKS!!! Your lessons are truly inspiring and assist people who would not otherwise have the support to get their head around Access. Cheers.
Sure. Just use that query to feed a form. Display the form instead.
Excellent tutorial, in 5 minutes i had the Search Form/Query running...thanks a lot
Welcome
You're very welcome. Let me know how it goes.
Well, I wouldn't put foreign and domestic students in two separate tables. I try to keep LIKE DATA together in the same table. If you want, use a checkbox (or a country field) to determine if they're domestic or not.
Please can you help me Richard, this tutorial was exactly what I needed for my database, I created exactly the same thing and it all worked excellent, but when ever I put in new records to my original table it is not bringing up new data. What am I doing wrong. I'm a complete novice so easy explanation would-be so gratefully received. Look forward to hearing from you
I also have the same problem.
When I add a new record it doesn't show up in the results. Can you help me?
This is a GREAT way to create a search form versus using drop down boxes or DLOOKUP!!!! Thanks!!!
Turn your control wizards on (option in the controls toolbox)
It finally worked! I failed so many times last night! So glad it finally worked lol! Thanks a lot!
I'd really need to see your database to get a better idea of what you're trying to do. You can use the SUM function in the footer section to get a count of items.
These are cool tricks for novices, but LIKE *[Parameter]* is incredibly inefficient. Put 20,000 rows in your table and enter multiple parameters, and your query could take a long time even with indexes. Also, LIKE ** will NOT find any rows that have an "empty" or Null field. To do that, you would need to code your criteria like this:
LIKE "*" & [Parameter] & "*" Or ([Parameter] Is Null)
Do that for more than 3 parameters, and you'll get "query too complex"
John Viescas
Access MVP
You should keep your end-users in FORMS. Don't let them interact with tables directly. Watch my Access 2010 Beginner Level 1 course which is free here on UA-cam to get started. You'll find it on my channel page.
Very nice presentation style - not too wordy or detailed and not too quick. thanks
You're welcome.
I cover creating a much more complex search form using dynamic SQL in my full Search Seminar.
Great tutorial; I'm having difficulty implementing a multi-field search form using several tables with many-to-many relationships and lookups. For instance, I have one table listing foreign students, a second table listing domestic students, and a third table with classes, as well as junction tables between the class table and the two student tables. The objective of the query/form is to determine which classes two students (one foreign, one domestic) share.
This is a clear and easy to follow tutorial. Question. If one of the fields I want to search on is a date field (DD/MM/YYY), and I want to have on this form where you enter the year of the date only (YYY). How do I code that? I just want the user to type in the 4 digit year.
Use the Year function and create a separate calculated field. 599cd.com/Calculated
Are you using actual Date fields? If so, they behave a lot differently than text. You have to enclose dates in # symbols, like this: #1/1/2012#
Hello,
I followed your subject, the search(research) is great, only I shall like(love) that a field (exp: NumDossier) gives us exactly the figure to ask, otherwise he(it) shows nothing, not of *.
Thank you
It's impossible for me to tell what you're doing wrong without looking at your database. I can tell you that I've used this technique in MANY of my classes and seminars, and it works in EVERY version of Access - as long as you follow the directions exactly. Try building the example that I build. Don't try to apply it to your database until you get that working first.
Very happy to hear you like my books!
I follow your instruction but after one search the query dont want to take a second search. Can you tell me what may be the problem?
Your Better Than My Dad's Tutorials, And He's Been At This For Years...
My table has male/female as varchar in one of the columns. Now, if I want to see only male records, I'll get the female records too, as it has 'male' in it. To eliminate this, I have tried using iif in the criteria field. But I face another problem where I need to check if my text field on the form has a 0 character string or a null value. It's getting complicated. Can you please suggest an easier way to do this? I'm using a lot of drop down options, check boxes, etc. on my search form
Just base a form on the results query. I cover this in my full seminar.
thank you so much. I'm a student and I have to build an application and one of the pages of this application will be a multi-field search form - I knew how to program it but the way I knew it was not really suitable for more than 2 fields (check if both are empty; then check if both are filled in; then check if one of them is filled in) so this is really handy. I'm using a newer version of access but I'm sure this will still be usable. thanks!
Welcome
I'm not sure. I'd have to see your database to tell you what you've done incorrectly. You can send it to me via then TechHelp page on my web site if you want and I'll look at it when I have some time.
Yes, you could certainly make a query to group data like this.
If the table structure is identical (or at least close enough) you could UNION them together and just search one resulting query. There are other, more advanced methods you can use that involve some SQL and VBA. I'll be covering these in my upcoming Access Searching & Sorting Seminar which should be available next week on my web site.
It could be several things. I'd need to see your database to tell you for sure.
Sorry if this has already been asked, but what can I do if some information is missing? (eg: someone didn't enter their last name) at the moment entire records are not being searched for because of a few missing bits.
Thanks for this video you are a hero!
Hi, did you solve this? I had the exact same problem, came up with a query statement to make a workaround. I ended up using lots of brackets and OR statements. Here's an example of a parameter query selection from a form (called Frm_Report_Query_Builder):
Like "*" & Forms!Frm_Report_Query_Builder!Title & "*")) Or ((YourTableName.Title Is Null) And (Forms!Frm_Report_Query_Builder!Title=""
Solved the problem of not returning results for nulls. Hope it helps.
This almost does what I am trying to do expect I'd like the search result to show up in a form instead of a table, any easy way to do this?
Or show up in a table in the form below in like a list and then select one to show up in a form
Richard, Is there any way to include a date search in the multi-field search form???
This is brilliant I do have a question however. When using this to search through a table with lookup fields it doesn't seem to recognise them, only works with pure text entries. Anyway I can modify this to recognise the drop down list choices as well as search criteria? Thanks for a great tutorial!
What if some fields are blank in the search - it appears that there is no response for that row. Looks like all rows must have data in the search fields to get a response for that row?
thanx for the helpful video, I have a little question, I have Access 2010, I followed your tutorial step by step, but I stock in 7:13 , when I inserted the command button it didn't show me the window where I can choose the categories and Actions, would you please advise, thank you in advance :)
Hi - I'm referring to fields that use look-up tables and I keep getting their ID number instead of the text of the field - I know there's a simple fix and I've done it before - but it's been a while and I can't remember how to remedy this relationship issue so that my combo boxes in the SearchForm return the text category rather than their IDs...
I have a text field for gender whose value comes from a form. I have a complex interface for the query form. I have set the default values of all the text fields to null and now when the user selects from a drop down or radio buttons, the invisible text fields are populated with the values. When I run the query for the first time, it works, but when i try to play around wit different conditions,it does not return any value.I think I am facing this because of the default values in the text fields
is it the same if you replace the textboxes with a drop down list?
Great lesson on forms, but I can seem to be able to have the form close after the query has run?
I don't understand.
I had a similar problem. Everything was spelled correctly, but the query with the criteria EXACTLY as specified returned all records. Any suggestions?
Hi there. I input the formula exactly as you specified but using my own search form and field so it reads: Like "*" & [Forms]![ChemSearch]![Chemical] & "*"
However, everytime I run the query, new data is not shown and if I open the query it comes up with "Enter Parameter Value. Forms!ChemSearch!Chemical!".
Thanks, you saved my college life :D
Hi thank you for your video. It helps me alot. I have a request can you make a video on how to get the person who will celebrating their birthday. A week before sunday. It will help me in our church. Tnx
ua-cam.com/video/6lA7tQDGLHQ/v-deo.html
Amazing tutorial sir... Thank you
Welcome!
varchar? Is your backend table stored on SQL Server? In Access you would just use a Yes/No field.
I really appreciate your hard work
Thanks
Hi. I have followed the instructions on this tutorial but for some reason every time I run the query it comes up blank. This is the script I have used: Like "*" & [Forms]![F_Search]![First name] & "*"
where F_Search is the name of my form and I have named the text box "First name". I have no idea why this is not working! Can you please shed some light on this?
Thanks for this video. All working fine, except it doesn’t include in the search any new records I’ve entered into the database since the query was built. Any advice please?
599cd.com/qq
If your database is split properly, you should see the SAME data on all machines when you open a table, query, or form (that's based on the same table). Without seeing what you have there, it's impossible for me to tell you what's wrong, however.
Your videos are always top notch! I love to watch them for I learn new techniques every time. keep it up. Thanks John
You're welcome. 3 years later. :)
Thanks for the video, it has helped me a lot.
I'm not getting empty fields to show up in queries though.
Like "*" & [Forms]![Job Site Search]![CityF] & "*"
That combined with the other 3 fields I'm using should return any search criteria where there are empty fields? Yet all I see when I hit my 'run query' button is all records that are filled in completely.
I've watched your video 3 times and been to your website as well. There doesn't appear to be anything else on the web for this either.
To have a good command in MS Access, one has to look this tuto. It is wellcome
Thanks
I am trying to make this form for a database at work, but every time i run the query I get zero results. I also have Access 2010 and have been following all the steps in the video. What could be causing the problem?
Without seeing your query it's impossible to tell.
Incredibly helpful tutorial. Is there a way to search for more than one name? For example, I type Joe and Smith in Search and it outputs both Joe and Smith results. Thanks!
Some of the fields are currently blank for all records, these seem to be the ones giving problems. Should there be a reason for this? How can I get round it?
I have been working on this particular search form, however when I replicated exactly what you had at 5:15 but my results kept showing up blank. Even when I did enter something into the search form. I do not understand why.
Hi this is a great video and I was able to do this, but is there a way for the search results to come up in a form instead of the datasheet view? I want the whole process to stay within the form and never go to a data table because then the user will not know how to close that haha
Very specific, complete, well explained and useful video, thank you so much!
You're very welcome!
Great lesson. You help me so much
My pleasure
I need to make a form with text boxes that can be clicked to enter a new customer (user is directed to Customer Table) or submit a work request, but I'm so lost. Can you help?
hello sir, i have a question, can i possibly display the query result below the search form? i think it would be great to see the query result on the same form after hitting the run query button, thanks!
Hi!My search form does not function unless I save it before running the query. Please help. Thank you!
Without seeing your tables, it's impossible for me to tell you what's wrong. Make sure you have connecting fields to form the proper relationships between those tables.
Hi there, can you give the link after you have update your Access Search Seminar...Thanks a lot...your video are very helpful...
Awesome video, very straight forward and no need for macro. Thank you so much :)
YW
I tried that but the issue is I have Where Clauses so I have 4 different queries. Each query has a where clause. I basically want 1 report instead of 4 separate reports.
All 4 queries come from the same table.
This tutorial is good, and easier to understand
I want to make a report using 4 different queries but I keep getting an error saying can't connect tables. Any Suggestions on how to fix this issue?
If you didn't intentionally create the parameter, then you have something (usually a field name or criteria) spelled wrong.
I'm trying to add a text field in which people have to type something, and accordingly a button which opens up a form/record of one person in the database.
Yet, whenever I try to create the button, the value that people enter doesn't appear in the list of fields in my create button wizard, why not?
hi, im using access 2007, i copied this tutorial as an exercise and i'm wondering why my query table wont refresh like yours do,
whenever i hit the "Run Query" Button i have to hit Refresh to see the latest result on the search that i typed in my form, mine does not automatically display the new values like yours do
hope you could help me - thanks!
Thank you so much for these Tutorial. It solved what I was looking for.
My pleasure.
I joined the queries in relationships they all have a Primary key 'EEID'
a number. This still didn't allow me to due a report in the report wizard.
works great... but it only works once for me. the query works the first time round but when i press my button again it doesnt run the query
Thanks a lot sir! This has helped me tons. But I face a small problem, each time I have to search for something I have to close the form, the query table and open the form again and search to make the query run. Can you help me around this? Thanks
You are very welcome. Glad you enjoyed! Yeah, that's a limitation of how that form is set up.
Hello Richard, in a "web" database how can you do this "Run a Query" from a Button? I didn't found a work around :-)
Thanks! Your Videos are excelent!
Hello this video was very informative! It helped me with a project at work. . Question, How would i have the selected record in the query show up in a Main Form that i already have. . The user could search based on their criteria, and then select a record from the query results, and have it open up in my "main form" is this even possible??? Thanks for any input.
Love it! Thank you. Just one question, how would you be able to create a query that can search through different tables all at the same time? I was trying to figure it out but wasn't able to.
Hope you can help! Thanks!
That all depends. Are those tables related? If so, join them together. If not, you might be able to Union them together.
599cd.com/Relationships
599cd.com/Union
Hey, Great vid. Is it possible to run a search across multiple fields but only have one search box. An example from your video would be having a single search box, I type in "mi" and run the query. the query would return rows 1,2,4 and 6 as each of these have "mi" in one of the fields (Smith, Mike, Miami). Thanks