Microsoft Access datatype mismatch error

[Andrew MacIntyre]

On Thu, 5 Feb 2004, Steve Briley wrote:

> >>>rs3 = db.OpenRecordset("select * from work where ID = 3 ")

{...}

> >>>rs3 = db.OpenRecordset("select * from work where ID = '%i'" %(idnum))

You're doing excessive quoting in this case; try

>>>rs3 = db.OpenRecordset("select * from work where ID = %d" %(idnum))

--
Andrew I MacIntyre                     "These thoughts are mine alone..."
E-mail: andymac at bullseye.apana.org.au  (pref) | Snail: PO Box 370
        andymac at pcug.org.au             (alt) |        Belconnen  ACT  2616
Web:    http://www.andymac.org/               |        Australia