Need help returning values from database in vb code

[ecomajor]

Hi,
I have a query (or a stored procedure) that I want to return an integer value from sql server into my vba code in access.
How do I go about executing the procedure (or the query) and then getting that integer value from it so that I can use it within my vba code?

 

[rbinnington]

If you use a query that only returns one row you can use the DLookup function like so.

Dim i As Integer
i = DLookup("FieldName", "QueryName")

if you want to filter out the row you want
Dim i As Integer
i = DLookup("FieldName", "QueryName", "Where clause without the Where")

Richard