By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Test for <Object variable not set>

P: n/a
Hi!
I hope someone can help me with this.

I have form (unbound) where the user enters different selections criterias
in combo- and text boxes.
I use the data to make a query (usually a crosstab query) and present the
result in a subform.

The fields/columns in the result are dependent on the selection criterias.
If the user selects the wrong combination of data the query may return
nothing

even
"If queryrecordset.EOF/BOF then
....will execute this..
endif"

The debug-windows shows this "QueryRecordset <Object/Variable not set>"
The IsNull() or IsEmpty() function doesn't work
How can i test for <Object/Variable not set>?

Thanks,
André


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try to use it. If you get Error 91, then it's not set. React accordingly to
this in your error handler.

--
Wayne Morgan
MS Access MVP
"Andre Kristoffersen" <an*****************@c2i.net> wrote in message
news:cl**********@services.kq.no...
Hi!
I hope someone can help me with this.

I have form (unbound) where the user enters different selections criterias
in combo- and text boxes.
I use the data to make a query (usually a crosstab query) and present the
result in a subform.

The fields/columns in the result are dependent on the selection criterias.
If the user selects the wrong combination of data the query may return
nothing

even
"If queryrecordset.EOF/BOF then
....will execute this..
endif"

The debug-windows shows this "QueryRecordset <Object/Variable not set>"
The IsNull() or IsEmpty() function doesn't work
How can i test for <Object/Variable not set>?

Thanks,
André

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.