Conditional record navigation

[AA Arens]

I amde a helpdesk database and on the calls form I put record
navigation buttons
[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]

Is het possible to navigate [<] / [>] through the records with a
certain status.
Each call has a certain status with is set via an Option Group and
filled in the Status colomn in the Calls table.

Bart
Acc 2003.

[pietlinden@hotmail.com]

Re: Conditional record navigation


AA Arens wrote:

I amde a helpdesk database and on the calls form I put record
navigation buttons
[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]
>
Is het possible to navigate [<] / [>] through the records with a
certain status.
Each call has a certain status with is set via an Option Group and
filled in the Status colomn in the Calls table.
>
Bart
Acc 2003.

yes, filter the form before navigating.

[AA Arens]

Re: Conditional record navigation

How to perform the filtering?


pietlinden@hotm ail.com wrote:

AA Arens wrote:

I amde a helpdesk database and on the calls form I put record
navigation buttons
[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]

Is het possible to navigate [<] / [>] through the records with a
certain status.
Each call has a certain status with is set via an Option Group and
filled in the Status colomn in the Calls table.

Bart
Acc 2003.

>
yes, filter the form before navigating.

[salad]

Re: Conditional record navigation

AA Arens wrote:

How to perform the filtering?
>
>
pietlinden@hotm ail.com wrote:
>

>>AA Arens wrote:
>>

>>>I amde a helpdesk database and on the calls form I put record
>>>navigation buttons
>>>[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]
>>>
>>>Is het possible to navigate [<] / [>] through the records with a
>>>certain status.
>>>Each call has a certain status with is set via an Option Group and
>>>filled in the Status colomn in the Calls table.
>>>
>>>Bart
>>>Acc 2003.

>>
>>yes, filter the form before navigating.

>
>

You could have a combo box of status's. In the AfterUpdate event you
could have a statement like the following. I'll assume the status value
is a string, not a number

Me.Filter = "Status = '" & Me.ComboStatus & "'"
Me.FilterOn = True

It would be nice to have a status that is for displaying all Records.
Let's say you have a table of status codes. You could have a statement
similar to this
Select StatusCode, StatusDescripti on from Status Codes
UNION
Select "0", "All" From Status Codes

Then your filter statement might be something like
If Me.ComboStatus <"0" Then
Me.Filter = "Status = '" & Me.ComboStatus & "'"
Else
Me.Filter = ""
Endif
Me.FilterOn = (Me.ComboStatus = "0")


Me.FilterOn = True

[AA Arens]

Re: Conditional record navigation

Hallo Salad,

Thank you for your input. I am not professional as you are. Could you
help me further?
The situation is as follows:

I have status (in text format) like
Open
Wait
Bug
Closed

I want to record through the records with the regular record nav.
buttons, but then only brows through the records with status = Open. (I
also have the nav buttons for navigating through all records)
The status is mentioned in the column Status of the Calls table, added
via the Frame construction. (In this table there is also other info
about calls, like name customer, name officer, software version etc.)

May be you could assist me how to have it all performed. Thank you.

Bart


salad wrote:

AA Arens wrote:

How to perform the filtering?


pietlinden@hotm ail.com wrote:

>AA Arens wrote:
>
>>I amde a helpdesk database and on the calls form I put record
>>navigation buttons
>>[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]
>>
>>Is het possible to navigate [<] / [>] through the records with a
>>certain status.
>>Each call has a certain status with is set via an Option Group and
>>filled in the Status colomn in the Calls table.
>>
>>Bart
>>Acc 2003.
>
>yes, filter the form before navigating.

You could have a combo box of status's. In the AfterUpdate event you
could have a statement like the following. I'll assume the status value
is a string, not a number
>
Me.Filter = "Status = '" & Me.ComboStatus & "'"
Me.FilterOn = True
>
It would be nice to have a status that is for displaying all Records.
Let's say you have a table of status codes. You could have a statement
similar to this
Select StatusCode, StatusDescripti on from Status Codes
UNION
Select "0", "All" From Status Codes
>
Then your filter statement might be something like
If Me.ComboStatus <"0" Then
Me.Filter = "Status = '" & Me.ComboStatus & "'"
Else
Me.Filter = ""
Endif
Me.FilterOn = (Me.ComboStatus = "0")
>
>
Me.FilterOn = True