Re: Help with code to run query and test a field in the record

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 12:55:17 +1000

Yes.

There are 3 Parameters that need to be resolved before passing the SQL
String to JET for processing. They are:

Forms![SINGLE BOOKING AVAILABILITY]!BookingDate
Forms![SINGLE BOOKING AVAILABILITY]!Combo8
Forms![SINGLE BOOKING AVAILABILITY]!Combo10

Note that JET Database Engine which process the SQL String does not know
anything about Forms or Controls on Form so these need to be replaced with
actual values before passing the SQL String to JET for processing. 

-- 
HTH
Van T. Dinh
MVP (Access)
"tina" <nospam@address.com> wrote in message
news:0Kikc.5336$Xj6.81543@bgtnsc04-news.ops.worldnet.att.net...
> hi Van.
> Kate did post the SQL, in a separate thread 3:59 pm this date, subject
line:
> I'm struggling with my limited knowledge of code.
> i posted an answer, but maybe you'll come up with something better on
> looking at it?
> tina  :)
>
>

Relevant Pages

  • Re: Help with code to run query and test a field in the record
    ... There are 3 Parameters that need to be resolved before passing the SQL ... String to JET for processing. ... Forms![SINGLE BOOKING AVAILABILITY]!BookingDate ...
    (microsoft.public.access.formscoding)
  • Re: Help with code to run query and test a field in the record
    ... There are 3 Parameters that need to be resolved before passing the SQL ... String to JET for processing. ... Forms![SINGLE BOOKING AVAILABILITY]!BookingDate ...
    (microsoft.public.access.gettingstarted)
  • Re: Problem with FROM Clause in Query
    ... The SQL I worked on was the one the OP had compounded to get rid of the ... original query, I don't believe this is the one they stated was working in ... "The Microsoft Jet database engine cannot find the input table or query ... > [some select string]. ...
    (comp.databases.ms-access)
  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)