Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jean
Starting Member
6 Posts |
 Posted - 2003-04-04 : 14:32:28
|
| how do i reference controls objects such as forms or reports in MS Access in SQL Server 2000 Query. Like for example in MS Access Query Criteria = like forms!frmUser.txtUserName im using MS Access 2002 as my frontend and SQL Server 2000 as my backend.thanks a lot, jean |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-04-04 : 15:00:04
|
| The Most Accurate Way is to create a Stored Procidure that you wish to use with the Condition. Where(txtUserName = @txtUserName) Remember if you Code this by Hand you will have to Delare it at the Begining. Now Create A new Form That Has this S.P. as its "record source". Note: I usualy place just a text field on the screen that says "proccessing Please Wait" just incase my S.P. takes Awhile.Last in the form properties Iput peramiters Line of this form Place a code line like this.@txtUsername = Forms!frmUser!txtUsernameTo use it you can just open the form that you just created, use the DoCmd.openform "formname" This will run the procidure you just created referencing that txtUsername field in the original form. Note: The "Processing Please Wait" form is rairly seen. and Closes itself. Edited by - JimL on 04/04/2003 15:04:19Edited by - JimL on 04/04/2003 15:05:49 |
 |
|
|
|
|
|
referencing forms control value in query criteria