Run time Error 2176

L

Liz

I have recently converted an Access 2 application to
Access 2000. While testing the converted app I get the
above noted error with the explanation " The setting for
this property is too long" when I run a particular peice
of code. The code in the module is adding the names of the
queries in the db to a combo box on a form. The code in
the module is as follows:

For i = 0 to db.querydefs.count - 1
If Mid(db.queryDefs(1).Name, 1, 3) <> "^sql" then
s = """" & db.queryDefs(1).Name & """;"
s = s & """ & Format(db.querydefs
(1).datecreated, "mm/dd/yy?) & """;"
s = s & """" & db.QueryDefs(1).lastUpdated & """;"
Forms![usys_frm_QuickTrack)![pickQuery].rowsource =
Forms![usys_frm_QuickTrack)![pickQuery].RowSource & s

The code runs fine until I hit a particular
query "qry_Audit_Totals". I have checked the query out and
it runs fine when I open it on it's own????? I have tried
changing the name of the query to qryAuditTotals,
qryAuditTots, qryAuditT but the code hangs up on this
particular query. What am I missing here?

Thanks,

Liz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top