Code:
Function Receipts(ByVal CHEMICAL As String) As ADODB.Recordset
Dim sql As String
Dim beginningDate As Date
Dim endingDate As Date
Dim chemicalID As String
5 results in 0.0043 seconds.
-
Calling an adodb recordset in a text box
I am trying to call a function from a text box on a subform that returns a summed total of a single calculated field. I need to reproduce this function in multiple subforms so it is encapsulated as possible. Here's the code:
... -
recordset gets messed up by EOF/ reading in it ?
This is a copy of an old post in here, but (presumably because it is so old) I cannot post an answer to, so I am re-creating it....
=============== =============== ==========
Seems like a $rs-> EOF messes up the record set ?
(using php 4.2.2 and MSSQL database)
I try to read the ntext-field "body".
THIS WORKS !!
...Code:$dbMail = new COM("ADODB.Connection"); -
Data provider could not be initialized error help
I am trying to debug a VBA program in Access and have no idea what I am doing, but when I execute the code I get the following error:
"Data provider could not be initialized"
The debugger sends me to the "Set conn = CurrentProject. AccessConnectio n" in the code below which I searched help for and found that current project is one of the properties in Access 2007 that is blocked by sandbox mode. So I followed... -
ADODB.Connection Automation Error
Hello,
Every time I try to create an ADODB.Connectio n object, I receive the following error:
-----------
Runtime Error '-2147024703 (800700c1)':
Automation error
%1 is not a valid Win32 Application.
-------------
I am running Windows 7 Ultimate (64 bit).
This IS NOT a connection string problem, nor is it application-specific.
I can easily reproduce the error in a number... -
Can't find installable ISAM error message when using ADODB method
I'm trying to use this method to copy an range in Excel workbook that is closed to the one that's open. I'm using the following code, which gets the "Can't find installable ISAM" error when I get to the line "cnt.Open". My Windows files (various .dll) are up to date, so there is some other hitch in there.
Sub Get_Data_Closed _Workbooks()
Dim cnt As ADODB.Connectio n
Dim cmd As ADODB.Command...
