Passing date fields from form to Access ADP Views
This is a discussion on Passing date fields from form to Access ADP Views within the SQL Server forums, part of the Microsoft SQL Server category; --> I have a whole bunch of forms that have an unbound StartDate and an EndDate field that I have ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:34 PM
| ||||
| ||||
 Passing date fields from form to Access ADP Views I have a whole bunch of forms that have an unbound StartDate and an EndDate field that I have used in MSAccess MDB databases as parameters in queries (ie tblEvent.StartDate > Forms!myFormName.StartDate.) So, now I'm migrating this beast over to and ADP/SQL Server project using Views and Procedures. How do I pass the value in Forms!myFormName.StartDate to a Procedure and get something that looks like: If tblEvent.StartDate > Forms!myFormName.StartDate then ... Any help is GREATLY appreciated. This is a major problem before I can move ahead with this beast! lq      |
|
02-28-2008, 06:50 PM
| ||||
| ||||
| Re: Passing date fields from form to Access ADP Views Send it in using the form's InputParameter property. Set the form's recordsource to the stored procedure. -- Jerry Boone Analytical Technologies, Inc. http://www.antech.biz "Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message news:47e5bd72.0310291336.dd6bfe2@posting.google.co m... > I have a whole bunch of forms that have an unbound StartDate and an > EndDate field that I have used in MSAccess MDB databases as parameters > in queries (ie tblEvent.StartDate > Forms!myFormName.StartDate.) > So, now I'm migrating this beast over to and ADP/SQL Server project > using Views and Procedures. > How do I pass the value in Forms!myFormName.StartDate to a Procedure > and get something that looks like: > If tblEvent.StartDate > Forms!myFormName.StartDate then ... > Any help is GREATLY appreciated. This is a major problem before I can > move ahead with this beast! > lq > |
Linear Mode
