[dba-SQLServer] Continuous Forms and Filters

Paul Hartland paul.hartland at googlemail.com
Thu Apr 24 14:39:41 CDT 2014


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
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the dba-SQLServer mailing list