Object exists...and it doesn't

[FP1]

Some kind of zen thing in Access, maybe? I'm calling a procedure with an
optional paramter. I'm NOT passing that parameter in the calling procedure
and therefore the object should be "missing". Access returns False from
IsMissing, IsEmpty and IsNull, and of course I then get "object or with
variable not set" when I try to access it. Any ideas?

Sub check_for_records_added(oldDB As ADODB.Connection, newDB As
ADODB.Connection, updatedTable, outOfDateTable, keyfields As Collection,
Optional outkeyfields As Collection)

Dim outkeys As Collection

'irrelevant stuff snipped

If (IsMissing(outkeyfields) or Isnull(outkeyfields)) Then
Set outkeys = keyfields
Else
Set outkeys = outkeyfields '<--always true
End If

 

[Guest]

The IsMissing only works with Variant data types. It will not work with an
object variable.

 

[FP1]

The IsMissing only works with Variant data types. It will not work
with an object variable.

Ouch! Thanks. So how would I check it? Isnull and Isempty return false.
Would I use "is Nothing"?

 

[FP1]

What is outkeyfields and keyfields?

Both user-defined class objects.

 

[FP1]

If they are class objects, I don't think passing them as collections
is correct.
It isn't clear to me what these objects contain or what it is you are
trying to do.
Maybe a description of the intent would be helpful.

Actually, they are collections. It's pretty simple, really. I'm building a
comparision of two tables in different database with potentially
differently primary keys (same basic keys, but could have differnt names).
If they're different, I pass the secod set names, but if not, just copy the
first set.

Probably the best answer was the first one, that I can't check for a
missing object if it's not a variant. Been coding access for over three
years and I still run into this stuff!

 

[Guest]

What is outkeyfields and keyfields?

 

[Guest]

If they are class objects, I don't think passing them as collections is
correct.
It isn't clear to me what these objects contain or what it is you are trying
to do.
Maybe a description of the intent would be helpful.