[dba-SQLServer] Continuous Forms and Filters

Jim Lawrence accessd at shaw.ca
Thu Apr 24 17:48:12 CDT 2014


Hi David:

Once a data set can be placed in a recordset then filtering should be not problem. I am not that current on the latest and greatest MS SQL DB features but to my understanding, the fastest way to extract data is through a query...or am I not understanding your question?

Jim 

----- Original Message -----
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, 24 April, 2014 1:18:00 PM
Subject: Re: [dba-SQLServer] Continuous Forms and Filters

Hi Jim,

Just to confirm, do I take from your reply that the built in filtering
doesn't work with an SQL BE?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand



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

Hi David:

This is not a difficult process but it does take a bit of coding to
accomplish and I posted code samples on that effort earlier this year. IMHO
it would be unwise to have a synchronized connection to a SQL BE an
asynchronous connect model would be my recommendation. If you would like the
posts, just ask and I will see if they easy to find.

Jim  

----- Original Message -----
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "AccessDSQL" <dba-SQLServer at databaseadvisors.com>
Sent: Thursday, 24 April, 2014 12:27:57 PM
Subject: [dba-SQLServer] Continuous Forms and Filters

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



More information about the dba-SQLServer mailing list