If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Deleting a Query SQL
Hi all,
I am working with a multiple parameter search query. The form I am using to conduct the search displays the results in a subform. I have gone through and really combed through the SQL to make sure there are no blatant spelling errors or incorrect references within the code. Anyways when I open the form that it is attached to, I keep getting the boxes described in this website http://allenbrowne.com/bug-13.html .. The form is open, and I even changed names of fields in the table in case SQL was choosing to be picky about what I named my fields. Is there anything else that would cause this error that anyone is aware of? So, after I open my form and those boxes pop up, I will try to play around with the form a little to see if it's just a 'startup error'. If I hit the command button I set up to run the Query I will go back to the SQL after closing the form and Access will have deleted it. Does anybody know why this is happening? Is there anything I can do to fix this? Here is my code just in case it will help: SELECT [2007-08ScholarshipMaster2].* FROM [2007-08ScholarshipMaster2] WHERE ([2007-08ScholarshipMaster2].Name Like "*" & Forms! QueryMultiValueSearchForm!txtFilterName & "*" Or Forms!QueryMultiValueSearchForm!txtFilterName Is Null) And (Forms!QueryMultiValueSearchForm!txtFilterUMID Is Null Or [2007-08ScholarshipMasterLink].UMID=Forms!QueryMultiValueSearchForm! txtFilterUMID) And (Forms!QueryMultiValueSearchForm!txtProjectGrant Is Null Or [2007-08ScholarshipMasterLink].PG=Forms!QueryMultiValueSearchForm! txtProjectGrant) And (Forms!QueryMultiValueSearchForm!txtStartDate Is Null Or [2007-08ScholarshipMaster2].ScholarshipStart=Forms! QueryMultiValueSearchForm!txtStartDate) And (Forms!QueryMultiValueSearchForm!txtEndDate Is Null Or [2007-08ScholarshipMaster2].ScholarshipEnd=Forms! QueryMultiValueSearchForm!txtEndDate); |
Thread Tools | |
Display Modes | |
|
|