What Code and where do I put it to Nest Loop

I preface this with...Yes I am quite a novice in VBA.. In a table, I have two different criteria that I need to loop through to build a dataset. The fields that I need to Loop through are Project_ID AllocationDesc (P1, P2P9). Once I've reached the ...

Message posted on the June 16th, 2009 - 3:33 PM ET

Would like to loop

Would someone please offer a solution to loop through the following code for as many times as there are records in "rs" The code compiles and it loops through it all but only updates the first record. I can't get my head around the loop ...

Message posted on the January 16th, 2009 - 6:26 PM ET

do loop through a table

I want to go through records in a table "TESTLIST" and assign 1,2,3... to Field1 based on whether there Field2 is not Null. if Field 2 is Null Field1 should start at 0. Field1 Field2 1 Mr. and Mrs. John Smith 2 1 Park Avenue 3 New York, ...

Message posted on the August 6th, 2009 - 1:41 PM ET

needing help with loop issues

Hello. I have a form that has a listbox on it. Also on the form are 3 textboxes as well as an update button. The code below is on the Update button click event. What is needed is the listbox will list out records from a table (BuiltList). The ...

Message posted on the September 16th, 2010 - 11:53 AM ET

Data Collection Reverse Engineering

Hello, I am in the process of reverse engineering the data collection functionality (this is where I found out I could do this reverse engineering of this process: ...

Message posted on the June 7th, 2012 - 10:14 AM ET

Wildcard Filtering on ADO Recordset

I am not an expert coder.. more of a copy cat As an example I will just use 1 record tables. I have a datatable with three fields. For ease I have just put in Excel (cell referance below) D1 E1 F1 CSXX850 8505141 22971.92 and I have a ...

Message posted on the October 26th, 2012 - 11:56 PM ET

ADO hierarchical recordset and DRD

Hi all, I know this is an arcane topic, but I'm sure one of you guys still has this kind of (useless?) knowledge floating around in there somewhere. I have a legacy app using the data report designer and I need to add a report to it. The report I ...

Message posted on the December 9th, 2009 - 11:44 AM ET

data from Excel into SQL Server 2008 via VBA

I currently have some code in an Excel 2007 workbook which takes data out of a worksheet and creates records in two different Access 2007 tables. I would like to place the data into two SQL Server 2008 tables instead and am unsure on how to change ...

Message posted on the November 25th, 2009 - 9:19 AM ET

dir$ problem listing all files?

using dir$ I don't seem to get all of the files in a director. in the folowing loop, dir$ gives me 37,184 files, but windows explorer directory properties says there are 37,315 files. (These files are stored in one directory by a commercial ...

Message posted on the June 22nd, 2009 - 10:56 AM ET

VBA question

The following is code to take information from an Excel 2007 spread sheet and dump it into an Access 2007 database. I need to somehow make sure this only happens if the information has not already been placed in the database. Each record should be ...

Message posted on the June 9th, 2009 - 3:57 PM ET

Recordset processing problem

I have a very complex loop that does recordset processing. I'm getting an error on an .ADDNEW statement saying 'operation not allowed when object is closed'. Well... I am not closing the object except after I have exited the loop. What could cause ...

Message posted on the May 13th, 2009 - 4:00 PM ET

running access

Hi, I am trying to run a macro, I am using the right code db.Execute "Macro1" ??? Thank you all Dim db As Database, rs As Recordset, r As Long Dim cncpath As String cncpath = "N:1CNCACCESSAPPSAccessAppsexceltemptransf.mdb" ...

Message posted on the February 5th, 2009 - 4:43 PM ET

RollUp by Date

I'm doing a date rollup. The rollup period varies based on user input. The following sub works EXCEPT when I cross Over midnight, the rollup begin time needs to reset for a new day with the new being time being midnight and the new end time being ...

Message posted on the April 23rd, 2010 - 7:37 PM ET

ADO Connection Opens as Read Only

Below is the vba I am using to connect to an Access 2007 database from Excel 2007 to import data to a table. The code works well the first time I run it, but on subsequent runs, it fails at ".AddNew" with a run-time error of 3251. That ...

Message posted on the April 22nd, 2010 - 5:45 PM ET

addnew loop