Re: Multiple combo boxes - send parameters to a query?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Richard Horne wrote:
>Thank you for your replies. I think you're taking me the wrong way however.
>I am eternally grateful to everyone on this forum who has helped me. Without
>help on from people on this forum, the project I am working on would be
>nowhere near where it is now.
>
>And I wasn't passing blame. You asked the question:
>
>Why are you using Like "*" & ...? If you really need that kind of
>comparison, it implies that there may be something funny in
>you table's fields or that the combo boces only have a vague
>relationship with each other???
>
>And I replied by saying - I didn't write that script - another user had told
>me to try that code previously. That is all.
>
>And yes I admit, "doesn't seem to get me anywhere" is a bit of a vague reply
>for which I apologise. To elaborate further, I did what I thought you were
>telling me to do, and this generated some sort of infinitely looping query.
>When I viewed the SQL of my query after I applied OR
>Forms!yourform.cboQueriedCustomer Is Null to each criteria the SQL view just
>filled with hundreds of OR and AND clauses before crashing ACCESS. So it was
>back to square 1.
>
>You seem awfully defensive in your replies but to re-iterate I appreciate
>all the help I can get. A year ago I had never used Access but now have a
>reasonable understanding of Access and databases in general, however my VB
>skills are non existent so forgive my need for hand holding.


I probably did come across a little harsh. Must be my
frustration at trying to answer a question with so few clues
to go on.

Regardless, it sounds like the query designer blew up with
whatever you entered in the design grid. How about just
skipping that interface and making the changes directly in
SQL view? Does that work? If it doesn't blow up and you
have further questions, please post a Copy/Paste of the SQL
sstatement so I can see exactly what tried.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: How to search forum
    ... Is there any way to search this forum for ... and use the "exact phrase" ... What if the poster used the phrase "query by date" ... if you open the query in SQL view and post the SQL text, ...
    (microsoft.public.access.gettingstarted)
  • Re: Numerical integration using composite rectangle rule
    ... >Since this is a query on numeric rather than symbolic ... you will probably get more replies by posting to ... I just noticed that I was posting in the wrong forum. ...
    (sci.math.symbolic)
  • Does SQL Run Behind Queries?
    ... SQL that it is running? ... What I would like to do, if it is possible, is to see the query in the GUI ... TIA for any replies. ...
    (microsoft.public.access.gettingstarted)
  • queries using LIKE
    ... I'm new to sql and this forum stuff, so please bear with me. ... I am trying to do a query using LIKE ...
    (comp.databases)
  • Re: ExcelTip/ExcelForum threading
    ... I see the same thing as Tom. ... They appear to be replies to their own ... > own forum software, so I don't know that he has control of that aspect. ... > keepITcool ...
    (microsoft.public.excel.programming)