Query in code not working
  Home FAQ Contact Sign in
Search only in:
microsoft.public.access.gettingstarted
 
 Advanced search
MATCHING GROUPS



more...
Group Profile...
POPULAR GROUPS

more...
found 13561 articles for 0.665 sec
Re: Query in code not working     

Author: Johnny Bright
Date: Nov 15, 2007 22:57

...:B9935A9B-FA89-4F89-B5D7-3FF7DBE3AE14@microsoft.com... DateReceived is part of the where clause in the query. WHERE (((Donation.DateReceived)>=[Forms]![frmLook]![txtBegin] And ...wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? ...
Show full article (4.61Kb) · Show article thread
Re: Query in code not working     

Author: Douglas J. Steele
Date: Nov 15, 2007 21:57

...news:B9935A9B-FA89-4F89-B5D7-3FF7DBE3AE14@microsoft.com... DateReceived is part of the where clause in the query. WHERE (((Donation.DateReceived)>=[Forms]![frmLook]![txtBegin] And (...spelled wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? ...
Show full article (4.09Kb) · Show article thread
Re: Query in code not working     

Author: Johnny Bright
Date: Nov 15, 2007 21:36

...(((Donation.DateReceived)>=[Forms]![frmLook]![txtBegin] And (Donation.DateReceived)<=[Forms]![frmLook]![txtEnd])) The query is activated by a button on frmLook so the form is definitely open! I suppose if ... spelled wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? ...
Show full article (3.11Kb) · Show article thread
Re: Query in code not working     

Author: Douglas J. Steele
Date: Nov 15, 2007 20:47

..., Email and PhoneNumber (remember, if it's not in the SELECT part, you can't refer to it.) Also, the query is looking for [Forms]![frmLook...# AND DateReceived<= #11/30/2007# the sql for the query is: SELECT Runner.ProvinceStateID, RunSite.RunSiteID,... that would fix it but it's still not working! Still getting too few parameters. Does this code look right?...
Show full article (2.59Kb) · Show article thread
Re: Query in code not working     

Author: Johnny Bright
Date: Nov 15, 2007 20:16

... DateReceived = #1/1/2007# AND DateReceived<= #11/30/2007# the sql for the query is: SELECT Runner.ProvinceStateID, RunSite.RunSiteID, RunSite.City, Runner.... spelled wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? mySQL = "Select * from qryAllParticipants " _ & "Where ...
Show full article (1.95Kb) · Show article thread
Re: Query in code not working     

Author: Douglas J. Steele
Date: Nov 15, 2007 19:25

...-195F-4352-A12D-D21EA9D33991@microsoft.com... Well, I did have Received spelled wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? mySQL = "Select * from qryAllParticipants " _ & "Where ProvinceStateID = '" & Me.cboProv & "' " _...
Show full article (0.83Kb) · Show article thread
Re: Query in code not working     

Author: Johnny Bright
Date: Nov 15, 2007 19:22

... wrong so I thought that would fix it but it's still not working! Still getting too few parameters. Does this code look right? mySQL = "Select... as it's criteria the two text boxes on a form and is an aggregate query with several Group by's and one Sum field. All help greatly apprecitated! ...
Show full article (6.08Kb) · Show article thread
Re: Query in code not working     

Author: Douglas J. Steele
Date: Nov 15, 2007 18:54

...s criteria the two text boxes on a form and is an aggregate query with several Group by's and one Sum field. All help greatly... couple syntax mishaps in there. Here's a technique that will help you for the rest of your coding days... Create a variable to build the SQL string...
Show full article (5.23Kb) · Show article thread
Re: Query in code not working     

Author: Johnny Bright
Date: Nov 15, 2007 17:52

...as it's criteria the two text boxes on a form and is an aggregate query with several Group by's and one Sum field. All help greatly apprecitated! ...do have a couple syntax mishaps in there. Here's a technique that will help you for the rest of your coding days... Create a variable to build the SQL string and examine ...
Show full article (4.65Kb) · Show article thread
Re: Query in code not working     

Author: Douglas J. Steele
Date: Nov 15, 2007 17:16

... has as it's criteria the two text boxes on a form and is an aggregate query with several Group by's and one Sum field. All help greatly apprecitated! ...You do have a couple syntax mishaps in there. Here's a technique that will help you for the rest of your coding days... Create a variable to build the SQL string and examine it ...
Show full article (4.06Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next