Tdating
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2 articles for 0.226 sec
It looks as if I stepped in where I should not have. I should have read your entire post and looked at your procedure. I do almost NOTHING in ADODB so my advice is probably way off-base. I think that in ADODB you need to delimit dates with ' marks and not # marks. Also, the error says that qryFilter already exists - which should have little to do with whether or not SQL string's syntax     

Group: microsoft.public.access.queries · Group Profile · Search for Tdating in microsoft.public.access.queries
Author: John Spencer
Date: Jan 28, 2010 10:09

Thanks Daryl and thanks John! Ya know, I've done this before, but it was a while ago, and forgot about the #-thing and the parameters-menu-thing. I think you're both right! I fiddled with both of your recommendations, seperate and together, and I'm still stuck, but pretty close I think. This is what I'm working with now: SQL: PARAMETERS [forms]![SearchForm]![cboFrom] DateTime, [forms
Show full article (5.80Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Tdating in microsoft.public.access.queries
Author: ryguy7272
Date: Jan 28, 2010 09:51

Show full article (10.99Kb)