recordset_开发者

ADODB open recordset fails / "Operation is not allowed when object is closed"

I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute the scalar udf \"D100601RVDATABearingAllow\".[详细]

2023-04-11 12:46 分类：问答

ADO recordset fails on "memo" datatype during import into Excel

I am trying retrieve data from a SQL server, for use in some Excel 2003 macros. I would like to avoid the use of QueryTables, as I don\'t want this intermediate step of writing and reading from actual[详细]

2023-04-10 23:36 分类：问答

VBA Recordsets: Why does the way I declare my array, in the Fieldvalue parameters of .addnew, matter?

I\'ve been trying to dynamically add to a Recordset but I am unable to do so. The .addnew function of a adodb.recordset seems to not allow just any type of array to be passed to it\'s fieldvalues, val[详细]

2023-04-08 16:01 分类：问答

creating a mailing list from recordset in access 2010 vba?

I\'m trying to pull email addresses from a table and format them into a string that can be used in the \"TO:\" field of an outlook message. For some reason, the loop that i wrote is freezing the progr[详细]

2023-04-02 09:06 分类：问答

How do I copy and filter a DAO recordset in VBA?

Due to problems with DAO (see my previous question), I need to create an Excel VBA Recordset from an Access query and filter its results using a user-defined function.[详细]

2023-03-29 01:28 分类：问答

RecordSet methods generates conversion error and SQL results have no BOF And EOF

I have a SQL query that I have executed through the SQL program successfully.I ended up with the data that I combined into one column which has the header (No Column Name).[详细]

2023-03-26 09:41 分类：问答

Set OriginalValue property in VB6 classic ADO fabricated recordset

In classic ADO in VB6, in a recordset that\'s come from an external source, say, Set Rs = Conn.Execute(\"SELECT * FROM Table\"), each Field has an OriginalValue property, so that after an update to a[详细]

2023-03-21 17:53 分类：问答

vbscript dictionary adding in loop producing existing key error

I\'m simply trying to construct a dictionary of productIDs dim viewableProductIDs : set viewableProductIDs = CreateObject(\"Scripting.Dictionary\")[详细]

2023-03-21 00:02 分类：问答