Stephen Bond
stephen at bondsoftware.co.nz
Mon Nov 24 20:54:20 CST 2003
Line 3 below takes 4 seconds to execute:
1. Dim db as DAO.database, qdf as DAO.QueryDef
2. set db = Currentdb()
3. set qdf = db.QueryDefs("qryTransactionEntryFormGenerate")
4. For each prm in qdf.Parameters
5. prm.value = Eval(prm.Name)
6. Next prm
7. qdf.execute
The query is an Append query, the table being appended to is empty. The execution time is negligible. Why should line 4 take so long??
Stephen Bond
Man will occasionally stumble over the truth,
but most of the time he will pick himself up
and continue on.
-- Sir Winston Churchill