IsNull - Switches (1 Viewer)

vdanelia

Registered User.
Local time
Today, 02:43
Joined
Jan 29, 2011
Messages
215
Hello Mates need your help!

I;m Using
Code:
If IsNull(ItemCode) = True Then
How can I specify other table Name and then Field name
Code:
If IsNull(tableNamehere, fieldnamehere) = True Then
Something Like That...

Thank you!
 

vdanelia

Registered User.
Local time
Today, 02:43
Joined
Jan 29, 2011
Messages
215
Hello John
I'm really confused... I'll explain whole my problem..
I'm Building Sequential numbering (Product Codes) Based on this example http://www.techonthenet.com/access/modules/sequential_nbr2.php

It uses only one form, but my problem is:
My Category Combo is on the main form and the other fields are on the Sub-Form... I'm Struggling with it about 3 hours and couldn't solved it...
This is very good example that i was looking for and need to modify for my needs...
Your Help will be Highly Appreciated
 

John Big Booty

AWF VIP
Local time
Today, 20:43
Joined
Aug 29, 2005
Messages
8,263
You would use the Nz() function wrapped around the DCount() function to return a meaningful result if the DCount() returned a Null result, something like;
Code:
Nz(DCount(),0)
 

vdanelia

Registered User.
Local time
Today, 02:43
Joined
Jan 29, 2011
Messages
215
Thanks John for the reply

I'll Try It
 
Last edited:

Users who are viewing this thread

Top Bottom