query with environement variable as criteria

[DevAccess]

hello there,

I would like to have query with criteria which should take input parameters/criteria from enviorment variable for example environ(username).

Is that possible ? so what would be the statement for that.


Thanks

 

[CJ_London]

in a module (not a form module) create a UDF something like

Function CurrentUser() as string
    CurrentUser=Environ("UserName")
End Function

then in your query use something like

SELECT *
FROM myTable
WHERE user=CurrentUser

 

[DevAccess]

Thanks but how to put this parameter in query designer I am not referring sql query here.

 

[CJ_London]

all the query designer is is a visual representation of the sql.

click on the sql button left of the ribbon or bottom right of the form and you will see the sql the designer has generated.

but to answer your question put 'currentuser' (no quotes) on the criteria line under the field you want to use it.

 

[DevAccess]

Thanks CJ IT IS JUST current user or environ(currentuser) in field criteria.

 

[CJ_London]

IT IS JUST current user