recordset

Good Afternoon, I have a simple .xlsm book into which users can paste a list of file numbers and when run, the macro reads each file number, one at a time, and runs a query against a SQL DB and then pastes the results back into the book. Is there a way to read all of the file numbers...

Hi All I'm toying with sorting arrays using ADO recordsets... I know there are other ways of processing arrays but for now I'm just trying to understand how to process recordsets... No problem sorting numbers, but I have trouble sorting text. The code below works a treat but if I substitute...

Hi I am getting an error attempting to load and array from a recordset... This is slimmed down version, initially populating recordset with array but then eventually want to write it back out to an array too... Public Sub phoo1() Dim arr() Dim lngArrItem As Long Dim recData As...

Hello Everyone, I need to create a field in a report that calculates the average of the last 5 records (from the [volume2009] field) in the report. The report is based on a query called qry_Daily_Volume. I figured the best way to do this would be to create a VBA function ("Last5DaysAvg")to move...

The subroutine below (as an example) will open an Access file named "budget" and extract data from a table also named "budget". I need to import only selected fields from this Access file. See my comments in the file at the locations where selecting the fields might be possible. Your help will...

I'm Using a SubForm with Dataentry=Yes to type and see only the new records. in every row in the sub form I write the Number of the row in that batch using: n=recordset.recordcount+1 (at before update event of the form) now I want 2 things: 1. After Update, To summarize one of the fields (but...

I am currently using the following code to populate a list box with the contents of an ADODB recordset: Private Sub PopulateListBox() With Me.lboxRecords .ColumnCount = rsListBox.Fields.Count .Column = rsListBox.GetRows .ColumnHeads = True End With End Sub Is...

Hi All, I am a newby to programming & need some help with my coding. Currently, my code involves making a connection to a db then run queries. Results from the queries goes to recordset & from the recordset copy to specified range in excel worksheet. I am trying to do an automation process...

This is probably fairly basic but despite searching I can't find some simple advice on how to do the following: I have some VBA code that runs when a form is opened at a specific record - the code updates a field on the form depending on date values in other fields. This code works fine...

I have a problem with the following code. It is not recognising the following variable: objRecordSet My knowledge of Access is only in the beginner stage. I have seen plenty of examples of code online that use this but for some reason I canlt get it to work Sub Populate_Funds() 'On Error...