calling/using a sql server scalar valued function

J

John

I have a button on the main form for submitting the information. But,
part of the process is to see if the user exceeded their purchase
limits. The DBA has provided a scalar-valued function that returns
the information based on the userid that is passed into it. Below is
the if statement line that would use it. The rest of the IF works
when I put numbers in for testing. Now it is time to go to the
sqlserver for the info.

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

Never had to use/call one of these before. How does one go about
calling a scalar-valued function in access07 to get the return value
which is a decimal?

Thanks.
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calling sql server 2005 function in access 1
function use with table 6
using sql server function 2
SQL Scalar Valued function in VBA for a Access Project (ADP) 4
Using a table-valued function of a linked SQL Server database 3
Access SQL Scalar Function DAYOFWEEK Problem 1
scalar function return value into a VBA variable 1
Query on SQL Server is fast, while Access is crawling 2

Top