Dynamic Queries

  • Thread starter Thread starter Tereza Zambrano
  • Start date Start date
T

Tereza Zambrano

I have been trying to create a dynamic query, it works for
some of the variables, then it stops, when I try to look
at the sql code its HUGE and wont open..here is my code
Basically I have a dialog box with 10 fields, and set 10
parameter in my query ( exactly the same order as the
query)
This critieria for the 10 fields:[Forms]![FrmDynamic]!
[DMPC]Or Like [Forms]![FrmDynamic]![DMPC] Is Null
When I make a selection the cmd button calls the query.
Please help...
 
Anything more than one parameter, especially when an OR condition is needed,
I switch to the method of creating the SQL string in VBA code.

---
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Hi Tereza,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following article on creating a truely "dynamic" query is the way to go:

Query by Form (QBF) Using Dynamic QueryDef

http://support.microsoft.com/default.aspx?scid=kb;en-us;210242

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top