[dba-SQLServer] Continuous Forms and Filters

Hi Paul,

Yes they are linked to 2010 front end.

Regards

David

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Hartland
Sent: Friday, 25 April 2014 7:40 a.m.
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Continuous Forms and Filters

David,

Seems strange I haven't used anything past 2003 for development, but I know
what your saying works in 2003, are your tables linked into the 2010 front
end ?

Paul


On 24 April 2014 20:27, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers.
>
>
>
> Access 2010 with SQL2008 BE.  I have a continuous form of client 
> details. I already have a search combobox for finding a client name 
> but sometimes I may want to filter for all clients in a city, or in a 
> street. With an Access BE I can right click on the rows in a 
> continuous form and use the filter function to filter based on a 
> number of tests. This doesn't seem to work with an SQL BE..
>
> Does anyone have a solution for this? My only thought is to have a 
> line of filter controls at the top of the screen and pass these 
> through to the stored procedure but this seems clunky.
>
>
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand