Error message in event processing

[Kumar Thiagarajan]

I have a form with an on_load event that does some processing. Everything
was working until today. When the user opens the form it bombs at the 1st
line of the sub "Dim dbs as Database" with the error message "Compile
error - user defined type not defined." or something similar. What is
missing?

Any thoughts?

Thanks,
Kumar

 

[chas]

Hi Kumar,

Sounds like a either VBA refrence has become lost or a
required file is either missing or overwritten with a
different version. Choose Tools|References and note if
anything is listed as '(Missing))'. Depending on what it
is determines your next step, please post a reply and
someone else may help - I'm offline soon).

note - regsvr32 of the DAO file may help - please ask....

hth

chas

 

[chas]

Hi Kumar,

Sounds like a either VBA refrence has become lost or a
required file is either missing or overwritten with a
different version. Choose Tools|References and note if
anything is listed as '(Missing))'. Depending on what it
is determines your next step, please post a reply and
someone else may help - I'm offline soon).

note - regsvr32 of the DAO file may help - please ask....

hth

chas