object variable or with block variable not set

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
 
T

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
 
A

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.
 

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

Similar Threads

Data type mismatch in criteria expression 1
Object / With Block variable not set 5
error message 91 Object variable or With block variable not set 2
Object Variable or with block variable not set - Help 1
Object variable or With block variable not set 6
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Can you look for an image/OLE Object using dlookup 5
Object variable or block variable not set 4

Top