pass globals?

[aspnetuser]

Is it possible to pass a global string i store at user login to a view/stored procedure? I am using access project with sql 2000 as my backend.

this works fine for a form, because i set the form filter = to global variable i set at login.

how to I write that in a SP or from the report level in access project. what is the best approach for this?

 

[SSapphire]

Yes, where you call the stored procedure in the VBA code, pass the global variable as parameter.

e.g

Me.recordSource = "exec dbo.test" & globalVariable

With ADO.

dim ccn as adodb.connection
ccn = currentproject.connection
dim sql as string
sql = "exec dbo.test" & globalVariable

ccn.execute sql

or write code to capture result in recordset to populate your report.


I hope this answers your question.

 

[aspnetuser]

i set a global variable at login called 301. I need to query a view using this criteria 301 before I execute my generic report so it filters by the person logging on. I could easily do this in access but in project I do not know how to. Can you provide a specifc example?