David Emerson
newsgrps at dalyn.co.nz
Thu Apr 24 18:38:05 CDT 2014
Gary, Looks promising. I am using a stored procedure. Can you please give me an example of how you make the recordset call to a SQL view - when I try to replace my stored procedure name with a view name in my call it rejects it and tells me it is because it is a view!! David -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gary Miller Sent: Friday, 25 April 2014 11:21 a.m. To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Continuous Forms and Filters David, I have a 2010 FE linked to a 2008 SQL BE living on the internet using ODBC. The subforms are fed by dynamic recordsets that I populate on the selection of the parent record and I seem to have the 'Text Filters' available on right-click of the fields in it. I just tried a 'Contains' filter and it worked fine. Caveat is I am not using a stored procedure as such -- just a recordset call to a SQL view that I am filtering by Parent ID in the SQL statement for the subform RecordSource. Have you double-checked your AllowFilters property of the subform? Gary Miller -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Thursday, April 24, 2014 3:56 PM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Continuous Forms and Filters Jim, General filtering when getting a recordset is not a problem. What I am referring to is when a user right clicks in a continuous form the shortcut menu has an item called "Text Filters" as well as a number of predictive filters based on the current field. These work with an Access BE but searches on the web indicate that they don't with an SQL BE. Just trying to confirm what others might have done to get around this apparent limitation. David -----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 10:48 a.m. To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Continuous Forms and Filters 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com