recordset

I am trying to connect to Microsoft Access using ADODB.Recordset in VBA, but apparently it seems to only accept alphanumeric table name. Changing table name manually in Access is just additional work (and I need to teach it) for the macro user, so it would be great if it can work without doing...

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 recordset which loops through and pulls the first column correctly, but I need 30 more columns to do...

Dear All master, I want to connect with multi data source for dbf file with vba array code. what I want is the following: 1. Modify the connection string according to the dbase file provider 2. Can I connect with my multi DSN reference and become one sheet Data Source Name DefaultDir FILE NAME...

Hello, I've got problem. I receive phone number hashed by MD5 (00037b319ddf1495b2e7ae64e29a8ef5). I need to get this number from our mysql database. So mysql query is: SELECT MD5(c.mob) phone, c.mob phone1 FROM db_hu.hu_cust c WHERE MD5(c.mob) IN ('00f9758dd73300b4025ea916c8a3e024'); I...

Is it possible to have a recordset object created in one workbook but access this recordset object from another workbook's vba code? I was thinking maybe getobject could be used to capture it from another workbook but I cannot find any resources on this.

Hi Cummunity, Needing some help to concatenate row values being retrieved from ACCESS Database. INstead of writing to multiple rows, i need to concatenate all the record set values and write it to a single cell. Here is a view of part of my code: Currently there are two rows in the database...

I have used the following previously to open a query in Access and then copy the data to a holding sheetrsQuery.Open strQuery, cnConnection, adOpenKeyset, adLockOptimistic I now need to use the same but stop anyone else from getting any of the records that are in the recordset so effectively...

I want to create a recordset that contains only a single result from a larger recordset, how can I do this? I have a recursive algorithm that calls itself many times, passing a single record in, and getting a new set of results where one entry will be used in the next step and then passed on...

I use this forum all the time and it is awesome but couldn't find an answer this time. I got the below vba macro to work but want to use a cell value as the search value instead of typing it directly in the macro. I tried several different things but always returned an error I changed the...

Trying to pass a parameter into a query to sort a recordset. I was keeping a recordset in memory to sort it but the rowsource will not take a recordset directly. So I figured I could use a parameter to pass into the query and sort it that way. The code works if I hard code the sort criteria but...

I'm binding a runtime query to a listbox. I hit the cancel button and the listbox displays the last several rows in the recordset rather than display the first row. ListIndex and the properties I use in Excel cannot be assigned values in Access. How can I get the listbox to display the first...

Hi guys, can someone help i am trying to do vba/access link for the first time, and its quite hard! I am trying to access a report in access (which has a password) called R_UCITS-AIFM_Summary via an excel VBA, my first issue is normally input two dates, start and end date (normally the same)...

Hi experts, I have a VBA code that opens a recordset: Private Sub Form_Load() Dim qdfFillDictionaryOptional As DAO.QueryDef Dim rsFillDictionaryOptional As DAO.Recordset Set qdfFillDictionaryOptional = CurrentDb.QueryDefs("qryFillDictionaryOptional") Set...

I am trying to find data from access using the below code. The variable R is the date which it will search in the table. If date find in table, it will pickup data from some of the field else it will close the connection and loop will forward. Now the statement "On Error GoTo ST2" is working for...

Hey all! I have created an Access 2016 database with a table that has a column set as a value list. This allows me to create a checkbox-style input for the user, but I am having difficulty retrieving the values using SQL in VBA to create a recordset. I want to pull the record that corresponds...

Hello forum, I have some code below that I've found that pastes an entire recordset (which is a query) from a database and pastes it in cell A2. Is there a way for me to be able to paste just the sum of a single field from the record set in cell A2? Sheets("Existing Access...

Good morning/afternoon everyone: I'm trying to update a table in a Excel's workbook using ADO. Few things before the code: I have to say that I checked the property RecordSet.Status for the AddNew method and the boolean given it is true. I'm using a Microsoft.ACE.OLEDB.12.0 driver. The data...

I have vb code using ADO that can insert a single row of data from an Excel sheet one at a time. But I am looking to insert the entire contents on the sheet1 all at once. Here is my single row code. Sub SampleInsertLoopingThroughRows() Dim conn As ADODB.Connection Set conn = New ADODB.Connection...

Hi guys, I have code to read data from about 50 data tables. Code opens connection, creates recordset and then pass it to the array. Next it close connection and then loop through the array. I am wandering now is this would be actually better/faster to loop through the Recordset itself? Or...

Hi, I have a macro that connects to a DB2 database and returns a recordset that I complete subsequent actions with. I have found that longer queries are causing excel to stall - giving me the 'this program is not responding' and forcing me to restart excel. I have played around with the command...