Re: access 2003

From: "Geoff" <geoff@xxxxxxxxxx>
Date: Mon, 31 Jul 2006 08:38:19 +0100

All is clear after a sleep!
No doubt you realised that the parameters are in "qryWordOrders_uninvoiced",
so are hidden from the code below. I didn't see it, working from this
distance without the database. Another good learning experience!
Regards
Geoff

I do now believe that your following code is very suspicious:

Set qd = db.CreateQueryDef("", "SELECT wrkky_invno FROM
qryWorkOrders_uninvoiced WHERE wrkky_invno = true;")
qd![Forms!frmInvoiceSelect!ChooseCust] = Me!ChooseCust
qd![Forms!frmInvoiceSelect!ChooseJob] = Me!ChooseJob

The SELECT clause and WHERE clause do not contain the required parameters:

[Forms!frmInvoiceSelect!ChooseCust]
[Forms!frmInvoiceSelect!ChooseJob]

References:
- Re: access 2003
  - From: Geoff

Prev by Date: Re: access 2003
Next by Date: Should I worry that my Access to SQL conversion has gone so well?
Previous by thread: Re: access 2003
Next by thread: Re: access 2003
Index(es):
- Date
- Thread