Using Field Data as Input to Stroed Procedure

[bpalesch]

I have an Access question that I didn't see addressed elsewhere (or maybe I just didn't find it). I'm using MS Access 2000 to front-end a MS SQL Server database named resdev. In Access I have a tabbed form named Dashboard. On one of the tabs (tab name, Resource Data) I use a drop down list to bring up an employee's record. On the tab I also have a command button, named RSUPThisYear, which, when clicked starts opens a report named RUPByNameThisYr. The report is based on a stored procedure on the MS SQL Server named SUPByNameThisYear. The stored procedure asks for a name, which I'd like it to get from a field on the form named FullNameField, so the user doesn't have to type in the name each time.

MS SQL doesn't seem to have a way to refer to an Access field. Any suggestions as to how I might accomplish this?

Thanks in advance,
bpalesch

 

[eforce]

Did you figure this out yet

I'm also trying to figure out how to use a form fields data in a stored procedure.

Eforce

 

[Fornatian]

Although I don't quite know your problem as I am not an SQL server user, but these might be workarounds:

Option 1. Presumably you've tried passing the field into the proceure as an argument

Option2. Set the field to a global variable and use that in your procedure.

Option3. Update a table with the field value from the form then use a dlookup to retrieve it from the table.

Option4. Output the desired field to a text file, then reference that in your procedure.