John W. Colby
jcolby at colbyconsulting.com
Tue Feb 25 18:06:08 CST 2003
>Pass that records identifier to the sproc as an Input Parameter. But what does that mean? I have heard that A2K forms (don't know about combos and the like) can be bound to open recordsets, but I heard a nasty rumor that that only works for read only recordsets, i.e. not too useful for data entry type forms. So how do I "Pass that records identifier to the sproc as an Input Parameter" so that a form pulls a specific record? >If you have ADH2000, volume 2 has a lot of information about using Access with SQL Server. Nope, don't have ADH 2000. 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 Mike and Doris Manning Sent: Tuesday, February 25, 2003 5:28 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Bound forms filtered on a control on the form Pass that records identifier to the sproc as an Input Parameter. If you have ADH2000, volume 2 has a lot of information about using Access with SQL Server. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, February 25, 2003 04:53 PM To: AccessD-SQLServer 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 -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2660 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030225/40975f59/attachment.bin>