J
JBL
I have two issues with the functionality around Server Filter By Form.
1. When I set the "Server Filter By Form" property of a form to yes,
the form opens in Filter By Form view but is completely disabled and
greyed out ie I can't type anything into any of the fields and none of
the drop down lists function. I have to click "Apply Sever Filter" to
view the form in normal view and then click "Server filter by form"
again to activate the Filter by Form view a second time. When opened
the second time like this it works fine. Is this normal behaviour or
am I missing something?
2. When using Server Filter by Form to filter date fields, Access
places # around the date when creating the filter. This happens
whether you type a date into the filter by form field or whether you
use a drop down. This makes the filter inoperable since SQL Server
does not recognise the # around the date field. This makes it near
impossible to use server filter by form to filter dates.
I am using Access 2003 with an ADP connected to SQL Server 2000
developer version.
Any assistance would be greatly appreciated.
1. When I set the "Server Filter By Form" property of a form to yes,
the form opens in Filter By Form view but is completely disabled and
greyed out ie I can't type anything into any of the fields and none of
the drop down lists function. I have to click "Apply Sever Filter" to
view the form in normal view and then click "Server filter by form"
again to activate the Filter by Form view a second time. When opened
the second time like this it works fine. Is this normal behaviour or
am I missing something?
2. When using Server Filter by Form to filter date fields, Access
places # around the date when creating the filter. This happens
whether you type a date into the filter by form field or whether you
use a drop down. This makes the filter inoperable since SQL Server
does not recognise the # around the date field. This makes it near
impossible to use server filter by form to filter dates.
I am using Access 2003 with an ADP connected to SQL Server 2000
developer version.
Any assistance would be greatly appreciated.