AlphaTabs to Filter form

  • Thread starter Thread starter sljack63
  • Start date Start date
S

sljack63

I modified the Customer Phone List macro and copied the option group
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:

[CurrentRecord]=0

My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:

IsNull([GrievantLastName])

TIA
 
I modified the Customer Phone List macro and copied the option group
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:

[CurrentRecord]=0

My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:

IsNull([GrievantLastName])

TIA
Click to expand...

The condition for the MsgBox, according to the Northwind Customer
Phone macro is:

[RecordsetClone].[RecordCount]=0

it works for me in both Continuous and Single form view.
 
[RecordsetClone].[RecordCount]=0
Click to expand...

Maybe I have an older version of the Northwind Database. In any event,
I tried the above condition and it did not work either. If the user
selects an alpha tab where no records are found, the form displays a
blank form, "Record 1 of 1 (Filtered)" at the bottom. No message box.


My form has a subform. Is that the problem?

S. Jackson
I modified the Customer Phone List macro and copied the option group
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:

[CurrentRecord]=0

My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:

IsNull([GrievantLastName])

TIA
Click to expand...

The condition for the MsgBox, according to the Northwind Customer
Phone macro is:

[RecordsetClone].[RecordCount]=0

it works for me in both Continuous and Single form view.
Click to expand...
 
Okay, I've done some checking. It is not that the form contains a
subform. The macro works with the condition set to: [Current]=0 if
you set the form's property to "no additions." If the form allows
additions, then the message box will not display. So, the question is,
how do I modify this condition so that a message box displays if there
are no records displayed?

S. Jackson

[RecordsetClone].[RecordCount]=0
Click to expand...

Maybe I have an older version of the Northwind Database. In any event,
I tried the above condition and it did not work either. If the user
selects an alpha tab where no records are found, the form displays a
blank form, "Record 1 of 1 (Filtered)" at the bottom. No message box.


My form has a subform. Is that the problem?

S. Jackson
I modified the Customer Phone List macro and copied the option group
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:

[CurrentRecord]=0

My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:

IsNull([GrievantLastName])

TIA
Click to expand...

The condition for the MsgBox, according to the Northwind Customer
Phone macro is:

[RecordsetClone].[RecordCount]=0

it works for me in both Continuous and Single form view.
Click to expand...
Click to expand...
 
Back
Top