Prev: Query to conditionally handle duplicates
Next: combine multiple recs into one with repeating fields
From: Phil Smith on 21 Apr 2010 17:03
The Connect string helps, but bot sure about the passthrough. You are
saying basicly create my "placeholder" query as a passthrough, and it
will stay a passthrough when I update the SQL?



On 4/20/2010 5:53 PM, Duane Hookom wrote:
> I just create a pass-through query and then use a little DAO code to set
> the SQL property (and the connection property if necessary)
> Your Dim's should be
> Dim Q As DAO.queryDef, DB As DAO.Database
>
> Set DB = CurrentDb()
> Set Q = DB.QueryDefs("FGDetail")
> Q.SQL = SQLSTRING
> Q.Connect = Cnnect
> Q.Close
>

 | 
Pages: 1
Prev: Query to conditionally handle duplicates
Next: combine multiple recs into one with repeating fields