Arthur Fuller
artful at rogers.com
Wed Feb 26 09:34:30 CST 2003
It's the last item on the Data tab of the property sheet. The sproc I included in my previous message should be enough to get your own going. In AXP there is only one Queries tab on the db window, and it contains sprocs, views and UDFs. -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] Sent: February 26, 2003 10:23 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Bound forms filtered on a control on the form >Input Parameters is a property of the form, even in A2K and you can set it on the form or in code with me.inputparameters = ..... Really? What tab is it on in the property box? I am not finding it. (A2K) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Susan Zeller Sent: Wednesday, February 26, 2003 10:12 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Bound forms filtered on a control on the form Input Parameters is a property of the form, even in A2K and you can set it on the form or in code with me.inputparameters = ..... Don't have much more to offer on this as I've been working mostly with unbound forms since I moved to SQL/Adp's. --Susan > -----Original Message----- > From: dba-sqlserver-admin at databaseadvisors.com > [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John > W. Colby > Sent: Wednesday, February 26, 2003 8:57 AM > To: dba-sqlserver at databaseadvisors.com > Subject: RE: [dba-SQLServer]Bound forms filtered on a control on > the form > > >I think there's some misunderstanding here (could be on my part J). > Does your form have, say, a combo or list that is the form's > navigation scheme? Such that you select a row in the list and then the > form navigates to that record? > > Precisely. this is just one scenario that I actually need to handle > in my databases, to port them to ADPs. > > >In the InputParameters property, write "@PK = " & Me.cboName. > > I guess what I don't understand is that the sproc looks like a query > from inside the ADP. The form is bound to the sproc (query), but how > do I feed the parameter to the sproc? Where is the "Input Parameters > property"? What is it a property of? Do I assign the sproc to an ado > object which has such a property, then assign that to the form's > recordset property? If I do that, is the form R/W? If that is what I > do (and it must be R/W to be useful) can I see some example code? > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: dba-sqlserver-admin at databaseadvisors.com > [mailto:dba-sqlserver-admin at databaseadvisors.com] > Sent: Wednesday, February 26, 2003 8:06 AM > To: dba-sqlserver at databaseadvisors.com > Subject: RE: [dba-SQLServer]Bound forms filtered on a control on > the form > > I think there's some misunderstanding here (could be on my part J). > Does your form have, say, a combo or list that is the form's > navigation scheme? Such that you select a row in the list and then the > form navigates to that record? Or are you passing the selection to > another form that you want to filter? > If it's the same form, you'll need: > a) a view or sproc that populates the list with PK and description; > b) a sproc that drives the form, and that accepts an int parameter > @PK. Within the sproc, default the parameter @PK to zero. > > The code for the sproc should resemble this: > CREATE PROC myProc > ( @PK integer = 0) > AS > SELECT * FROM myTables > WHERE (PK = @PK) > > In the InputParameters property, write "@PK = " & Me.cboName. In the > AfterUpdate event of cboName, requery the form. > It's dead simple, and leaves all the data you don't want on the server > where it belongs. > HTH, > Arthur > > -----Original Message----- > From: dba-sqlserver-admin at databaseadvisors.com > [mailto:dba-sqlserver-admin at databaseadvisors.com] > Sent: February 25, 2003 7:08 PM > To: dba-sqlserver at databaseadvisors.com > Subject: RE: [dba-SQLServer]Bound forms filtered on a control on the > form > > Hmmm... OK. My understanding is that this actually pulls all of the > records in the recordset and then only DISPLAYS one record (filter). > That is useful in certain instances, however I would really like to > just pull one specific record, having SQL Server do all the work of > finding that record and handing it back. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: dba-sqlserver-admin at databaseadvisors.com > [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Selina > Iddon > Sent: Tuesday, February 25, 2003 5:31 PM > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer]Bound forms filtered on a control on the > form > > > Hi John > I may be reading the question wrong, but would this help? > > Sub MyComboControl_AfterUpdate() > Me.Filter = "FieldName = " & Me.MyComboControl > Me.FilterOn = true > End Sub > > Cheers > Selina > > > ---------------------------------------------------------------------- > ------ > ---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy > Access > Databases > ----- Original Message ----- > From: "John W. Colby" <jcolby at colbyconsulting.com> > To: "AccessD-SQLServer" <dba-sqlserver at databaseadvisors.com> > Sent: Wednesday, February 26, 2003 7:53 AM > Subject: [dba-SQLServer]Bound forms filtered on a control on the form > > > > I have been following the thread on the report thing. The > discussion has > > focused (the ones I have read) on using XP, where there are actually > > properties to do this. How do I do this in A2K? > > > > I have a form. I want to select a record in a combo box. Having > selected > > that record, I want to run an sproc, passing a parameter to filter > the > data > > returned to only return the record selected in the combo box. > > > > How do I do that in A2K? > > > > John W. Colby > > Colby Consulting > > www.ColbyConsulting.com > > > > ---------------------------------------------------- > > Is email taking over your day? Manage your time with eMailBoss. > > Try it free! http://www.eMailBoss.com > > > > > > _______________________________________________ > > 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 > > > > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 6620 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030226/7795b955/attachment.bin>