calling sql server 2005 function in access

[John]

I have a button on the main form does several processes. Part of the
process is to see if the user exceeded their purchase limits. The DBA
has provided a scalar-valued function (dbo.POLimitGetFromEmployeeID)
that returns a decimal based on the userid that is passed into it.
The parameter for the function is @emp_id. Below is the IF statement
line that would use it.

If Me.Subtotal.Value > "scalar-valued function result goes here" Then

Never had to use/call one of these before. Been googling but I am
finding very limited information. How does one go about calling a
scalar-valued function in access07 to get the return value?

Thanks.
John

 

[Douglas J Steele]

The only way you'll be able to call a SQL Server function in Access is if
you're using a pass-through query.