object variable or with block variable not set

  • Thread starter Thread starter Tia
  • Start date Start date
T

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
 
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
 
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.
 
Back
Top