1,122 questions
2
votes
0
answers
135
views
Using two words in LIKE operator (eg.: %John%Doe%) VB6
TL;DR Is it possible to search for matches using two words in LIKE operator?
Eg.: rsCustomers.Filter("Name LIKE '%John%Doe%'").
I have this ADODB.Recordset called rsCustomers that persists ...
- 31
0
votes
0
answers
23
views
Recordset.Close() extremely slow following server restart
Due to a power failure yesterday, one of my servers restarted and now a web based application on that server is so slow it is unusable.
Using the Failed Request log files I have tracked the problem ...
- 1
1
vote
1
answer
96
views
Are adChar and adVarChar valid ADO datatypes? Run-time error '3001'
Work has removed MS Access from our PC's!! Therefore I am trying to learn use ADO recordsets on a more standalone basis, and trying the following code:
Dim lcStrSQL As String
Dim lcObjRcs ...
- 31
0
votes
1
answer
58
views
Loop Though Access Table and Send Email with Related Data for Each Individual Sales Person
I have an Access DB table with 28 rows of sales persons with their respective emails and sales data. I need to loop through the table and create one Excel file for each salesperson and then send an ...
-1
votes
2
answers
145
views
How to use a VBA Recordset in a SQL Query
I am trying to write a VBA function that returns a set of records that can be used in a SQL statement.
Here's what I tried:
Public Function GetYieldForContainer(code As String, fldName As String) As ...
- 1
0
votes
2
answers
352
views
How do you display a record set inside a report in Microsoft access
I am trying to display the results of a recordset inside of a report that I made, my process is that I select a year on a form then click a button, once that button is clicked it sends that year to ...
- 1
0
votes
1
answer
56
views
Access Form Linked to SQL Server: Automatically Generated Record Source Corrupted in Design View
I'm facing an issue with Access forms linked to SQL Server tables. I typically set the forms' RecordSource property using VBA in the Form_Load event, like this:
Set Me.Recordset = CurrentDb....
- 23
0
votes
1
answer
139
views
How to disconnect recordset obtained from local table in MS Access?
I'm looking for a way to create an in-memory datasheet form. And I like the idea of using a disconnected recordset. But I ran into the problem of the app crashing after reassigning disconnected ...
-1
votes
2
answers
121
views
Save dataset contents to variant array – VBA vs VB.net
In VBA it is very simple to define an array, read a recordeset with ADO (a simple accdb table) and then populate the array with the info from the recordset. Say I have a table with 3 columns, A is ...
1
vote
2
answers
189
views
In VB6, ADODB.Recordset values from sql query not returning decimals
I'm fetching data from a db2 in VB6 using ODBC. The connection and setup is fine, but there's a problem in the returned data.
The fields in my record set are all rounded down to integer, so if the db ...
- 11
0
votes
1
answer
192
views
Access VBA accessing element of recordset
How do I select the actual variable if the recordset is JOINed from to tables?
Dim db As DAO.Database
Set db = CurrentDb
Dim rs As DAO.Recordset
Set rs = Currentdb.OpenRecordset("SELECT ...
- 19
1
vote
1
answer
513
views
Stored Procedures, NPGSQL, and returning a recordset
Version 7.0 of the Npgsql dotnet client interface to PostgreSQL databases introduced a breaking change in which CommandType.StoredProcedure now calls a PostgreSQL PROCEDURE rather than a FUNCTION.
Our ...
- 1,001
0
votes
1
answer
213
views
Access VBA to Copy Folders from Server to Desktop - FIle Path of Folders listed in query
Help! I can't get my VBA to work and your help is appreciated!
-Need to copy a set of folders from server to desktop.
-Folders on the server are for each item by model number.
-Within Access database, ...
- 3
0
votes
0
answers
85
views
How to copy a RecordSet contents on a split Range in Excel?
I have one ADODB.RecordSet with 1 row and 4 columns.
I want to copy the content of the recordset in the range "A1:B1, D1:E1", skipping "C1".
The range was creat with the Union ...
- 3,031
0
votes
0
answers
840
views
How to automatically create a DNS zone and DNS records in google cloud for a CLoud Run hosted API using terraform
I want to host my website on Cloud Run. The website is developed in React, and packaged using golang's "embed" package, which enables the React build assets to be served by the Go "...
0
votes
1
answer
153
views
Add Opened Recordsets in Collection and Close On-Demand
I have a function in which a recordset is opened using module level declared variable rst. The variable is not closed on the completion of the function as it is used by another sub. It may be possible ...
- 39
1
vote
1
answer
76
views
VB6 data match a recordset current record to an Array and get description text
I have table called beacons which has PrimaryCode, SecondaryCode and Description
I need to retrieve the full code from aonther table called data and split that code into Left$ and Right$ so that it ...
- 81
0
votes
1
answer
39
views
dialog form 's record is locked
I have form (Arzyabi_Tamin_Konande_da) that opens in dialog form by this code:
Me.Form.Dirty = False
Dim ASK As Integer
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
With rs
.MoveFirst
...
- 3
1
vote
2
answers
292
views
openrefine - Sorting column contents within a record?
Scoured the internet as best as I could but couldn't find an answer -- I was wondering, is there some way to sort the contents of a row by record? E.g. take the following table:
Key
Row to sort
Other ...
- 125
0
votes
0
answers
124
views
VBA having column name and value down the left of the worksheet
rather than have all my column names across the top of the worksheet, I'm looking to have them down the left hand side eg in Column A. The value of that will then be in Column B.
I have used a record ...
- 81
0
votes
0
answers
201
views
updating an adodb recordset opened from a postgres database?
I'm trying to connect to a postgres database with adodb so that to get data within a recordset and then update this data.
On postgres side :
create table test (description varchar) ;
I establish the ...
- 7,129
0
votes
1
answer
235
views
Using recordset without a db to connect to; runtime error 3709
The aim here is to copy a few rows of Excel data into a recordset object, using a header row for field names, without any sort of database/database connection in the picture. (It has been claimed, by ...
- 31
0
votes
0
answers
279
views
VBA - Retrieve multiple RecordSets from SQL query
I have a Stored Procedure on the SQL Server and I pull the results via VBA (Library: MS ActiveX Data Objects Library, ADODB).
Everything works fine when I only expect the query to return the result ...
- 455
0
votes
2
answers
406
views
VBA ADODB.Recordset values disappear suddenly
When loading data from mssql database in a recordset all fields get populated correctly. If I inspect the recordset in vba debugger all fields have values. As soon as I access one field f.e to assign ...
- 21
3
votes
0
answers
130
views
Using 'N in ADO.recordset.filter string
I have a VB6 ADO recordest that contains unicode text and need to filter it using .filter method with unicode text. I tried to use N' function but it does not work when I use it in .Filter text
Rs....
- 383