object variable or with block variable not set

[Tia]

Hello,

I have a problem, once i am trying to open the acess i am geting this
message Data type mismatch in criteria expression when i press ok i
get object variable or with block variable not set and i cannot access
my data
What can i do

Please advise

 

[Tom van Stiphout]

On Mon, 7 Dec 2009 01:00:13 -0800 (PST), Tia

Hold down the Shift key while you open the database, so the AutoExec
macro does not run.
Also, when you get an error you can hit Ctrl+Break to break into the
code and inspect it.

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

The type mismatch is being caused by a data type which may be different than
the one designed in the table, such as trying to have a text value in a
numeric column. The second error is caused by not having data in something,
like trying to close a recordset that never got opened.