A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Deleting a Query SQL



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2007, 06:44 PM posted to microsoft.public.access.queries
michelleumich
external usenet poster
 
Posts: 21
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.