When you go into the query editor, there should be a button on a toolbar that changes the query from design view to view to SQL view to datasheet view. It wil probably look like a data table, and it will have a small black arrow pointing down next to it. Press the black arrow, then click on the option that says SQL. This will bring up the text of the SQL query. Copy that and show us what it is.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
ok here ya go
That's the complete code via SQL view.SELECT [Movie Database List].Volume, [Movie Database List].[Movie Title], [Movie Database List].Rating FROM [Movie Database List] WHERE ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (([Movie Database List].[Movie Title]) Like [Forms]![search]![title] & "*") AND (([Movie Database List].Rating) Like [Forms]![search]![rating] & "*")) OR ((([Movie Database List].[Movie Title]) Like [Forms]![search]![title] & "*") AND (([Movie Database List].Rating) Like [Forms]![search]![rating] & "*") AND (("_ Forms!search!volume") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (([Movie Database List].Rating) Like [Forms]![search]![rating] & "*") AND (("_ Forms!search!title") Is Null)) OR ((([Movie Database List].Rating) Like [Forms]![search]![rating] & "*") AND (("_ Forms!search!volume") Is Null) AND (("_ Forms!search!title") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (([Movie Database List].[Movie Title]) Like [Forms]![search]![title] & "*") AND (("_ Forms!search!rating") Is Null)) OR ((([Movie Database List].[Movie Title]) Like [Forms]![search]![title] & "*") AND (("_ Forms!search!volume") Is Null) AND (("_ Forms!search!rating") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (("_ Forms!search!title") Is Null) AND (("_ Forms!search!rating") Is Null)) OR ((("_ Forms!search!volume") Is Null) AND (("_ Forms!search!title") Is Null) AND (("_ Forms!search!rating") Is Null));
Hmm, nothing jumps out at me. Try this instead:
If that doesn't work, I'd try creating a new query now that your table structure has changed, and see if that gives you the results you are looking for.SELECT [Movie Database List].Volume, [Movie Database List].[Movie Title], [Movie Database List].Rating FROM [Movie Database List] WHERE ((([Movie Database List].Volume) Like "*" & [Forms]![search]![volume] & "*") AND (([Movie Database List].[Movie Title]) Like "*" & [Forms]![search]![title] & "*") AND (([Movie Database List].Rating) Like "*" & [Forms]![search]![rating] & "*")) OR ((([Movie Database List].[Movie Title]) Like "*" & [Forms]![search]![title] & "*") AND (([Movie Database List].Rating) Like "*" & [Forms]![search]![rating] & "*") AND (("_ [Forms]![search]![volume]") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (([Movie Database List].Rating) Like "*" & [Forms]![search]![rating] & "*") AND (("_ [Forms]![search]![title]") Is Null)) OR ((([Movie Database List].Rating) Like "*" & [Forms]![search]![rating] & "*") AND (("_ [Forms]![search]![volume]") Is Null) AND (("_ [Forms]![search]![title]") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (([Movie Database List].[Movie Title]) Like "*" & [Forms]![search]![title] & "*") AND (("_ [Forms]![search]![rating]") Is Null)) OR ((([Movie Database List].[Movie Title]) Like "*" & [Forms]![search]![title] & "*") AND (("_ [Forms]![search]![volume]") Is Null) AND (("_ [Forms]![search]![rating]") Is Null)) OR ((([Movie Database List].Volume) Like "*" & [Forms]![search].[volume] & "*") AND (("_ [Forms]![search]![title]") Is Null) AND (("_ [Forms]![search]![rating]") Is Null)) OR ((("_ [Forms]![search]![volume]") Is Null) AND (("_ [Forms]![search]![title]") Is Null) AND (("_ [Forms]![search]![rating]") Is Null));
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
nope still no go .... a partial search is giving me the no results msg box still .... full search is returning the out of memory runtime error.
I am going to have a play with it over the next few days and will post back later.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks