Re: When do I open my Recordsets?

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

Yes. Looks to me as if you have the idea right.


"Joy M" <ab520@xxxxxxxxxxxxxxx> wrote in message
news:O%5yf.155081$Ph4.4725781@xxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi -
>
> So if I build an SQL statement using parameters in the query SQL View, and
> set these parameters in the code before
> I call the query, then I don't have to worry about what I am doing in the
> query Design View (with the QBE grid).
>
> I see that the parameters are used for both purposes:
> (1) some parameter = the actual value that goes in the field of the new
row
> of the table
> (2) take the values from the row (of the old table) with index = some
> parameter
>
> Does this how I create the action query and use it?
>
> Thanks,
>
> Joy
>
>


.

Relevant Pages

  • Re: Error using " in .open with ADODB.Recordset
    ... recordset but I'm getting hung up on the SQL statement. ... query that has a string as a condition. ... Dim mrk As String ...
    (microsoft.public.data.ado)
  • Re: expiration
    ... First what type of field are you applying the criteria against? ... You can try the following in a query. ... If you are trying to get just records with the License has expired within ... it is the actual SQL statement that is executed. ...
    (microsoft.public.access.queries)
  • Re: Same date range in main and sub form
    ... You need to concatenate together the parts to make up the SQL string ... it will look like the SQL statement you original ... Allen Browne - Microsoft MVP. ... well as the name of the query on which the form is based. ...
    (microsoft.public.access.forms)
  • Re: Sessions and Pagination Problem
    ... I don't get an error with the query. ... I have multiple if statements that append "AND"'s to the SQL statement ... If you click on page numbers and the prev or next links, ...
    (comp.lang.php)
  • Re: expiration
    ... If you are trying to get just records with the License has expired within ... In the Design view of the query ... This query is based off the existing employee database created by someone ... it is the actual SQL statement that is executed. ...
    (microsoft.public.access.queries)