John W. Colby
jcolby at colbyconsulting.com
Wed Feb 26 09:23:02 CST 2003
>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: 4212 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030226/c5baf18d/attachment.bin>