When do you use Set to assign a value to a variable, and when do you use Select?
Set @var1 = 50
or
Select @var1 = 50
What if you need to result of a query, like this one:
Select @var1 = count(*) from table1
The following is code that works in VBA that utilizes the Excel function "Median" from an Access module...
Dim objExcel As Excel.Application
Dim dTemp As Double
Set objExcel = New Excel.Application
dTemp = objExcel.Application.Median(1, 2, 5, 8, 13)
..................
I need to be...
I installed MDAC 2.7 on a Windows 98 second edition machine that was already running Oracle 8.0.5 client. When the machine rebooted from the installation, I was able to create a DSN using msorcl32.dll, and run my application.
When I logged off, and let another user login to try the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.