Nulls driving me nuts..

[kev]

Hi folks,

1)I have created a search query by ID which returns results like below:
EquipmentID, name,location, building, status1, status2,status3
0010 , roller, malacca, 8,
pending/approved,pending/approved,pending/approved

Now my problem is at times, there will be blank values for
status1,status2,status3 in which i was trying to search if it is null
and then replace it with a string "Not Applicable".

I have tried various ways like = Nz(Status1, "No such records") or
=IIf(IsNull([Status1]),"No such records", [RequestStatus]) in the
criteria portion of the query design yet it does not yield the results
that i need.

What am i doing wrong?Can anyone please help out with this.

2)i have posted a query earlier on how to set a tabbed page invisible
if the txtIssue is empty. i received a code on it from King Ron as
below but it does not give the desired output.
Private Sub frmMyForm_OnCurrent()
If (IsNull(Me.txtIssue) = True) then
Me.tabMain.pgLevel1Punchlist.Visible = False
Else
Me.tabMain.pgLevel1Punchlist.Visible = True
End If
End Sub

can anyone tell me why, perhaps another suggestion?

Thanks again, hoping for a quick response. when replying, please bear
in mind that i am a newbie, detailed instructions will be very much
welcomed.

[Rick Brandt]

kev wrote:

Hi folks,

1)I have created a search query by ID which returns results like
below: EquipmentID, name,location, building, status1, status2,status3
0010 , roller, malacca, 8,
pending/approved,pending/approved,pending/approved

Now my problem is at times, there will be blank values for
status1,status2,status3 in which i was trying to search if it is null
and then replace it with a string "Not Applicable".

I have tried various ways like = Nz(Status1, "No such records") or
=IIf(IsNull([Status1]),"No such records", [RequestStatus]) in the
criteria portion of the query design yet it does not yield the results
that i need.

What am i doing wrong?Can anyone please help out with this.

The Nz() or IIf() would be used in FIELDS of the query, not in the criteria.

2)i have posted a query earlier on how to set a tabbed page invisible
if the txtIssue is empty. i received a code on it from King Ron as
below but it does not give the desired output.
Private Sub frmMyForm_OnCurrent()
If (IsNull(Me.txtIssue) = True) then
Me.tabMain.pgLevel1Punchlist.Visible = False
Else
Me.tabMain.pgLevel1Punchlist.Visible = True
End If
End Sub

can anyone tell me why, perhaps another suggestion?

Try...

Me.tabMain.pages("pgLevel1Punchlist").Visible = False

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[kev]

Hi Rick,

Both worked like a charm. Thanks you are d best!!!

Rick Brandt wrote:

kev wrote:

Hi folks,

1)I have created a search query by ID which returns results like
below: EquipmentID, name,location, building, status1, status2,status3
0010 , roller, malacca, 8,
pending/approved,pending/approved,pending/approved

Now my problem is at times, there will be blank values for
status1,status2,status3 in which i was trying to search if it is null
and then replace it with a string "Not Applicable".

I have tried various ways like = Nz(Status1, "No such records") or
=IIf(IsNull([Status1]),"No such records", [RequestStatus]) in the
criteria portion of the query design yet it does not yield the results
that i need.

What am i doing wrong?Can anyone please help out with this.

The Nz() or IIf() would be used in FIELDS of the query, not in the criteria.

2)i have posted a query earlier on how to set a tabbed page invisible
if the txtIssue is empty. i received a code on it from King Ron as
below but it does not give the desired output.
Private Sub frmMyForm_OnCurrent()
If (IsNull(Me.txtIssue) = True) then
Me.tabMain.pgLevel1Punchlist.Visible = False
Else
Me.tabMain.pgLevel1Punchlist.Visible = True
End If
End Sub

can anyone tell me why, perhaps another suggestion?

Try...

Me.tabMain.pages("pgLevel1Punchlist").Visible = False

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com