Search results

Hi, I have an Access 2007 db . I am the only user and developer. I click on access and it takes me to a Switchboard I created. I exit out of the switchboard. I want to edit a procedure in a module. So I click on the left side of the screen. Select the subroutine I want. I make the...

Paul, Thanks so much. CurrentDb.Execute did what i wanted.

Is it possible to loop through a record set and loading a new row to a table without getting the message " you are about to append 1 row' I want to loop through 4,000 records do some calcualtions and load that into a new row in a different table. Thanks,

Thanks so much, That worked with one exception. The date is being loaded as 12/31/1899, when then dates are 1/2/1991 , 1/3/1991 etc. Also one other question. Since I am looping through 4000 records it is obviously going to ask me to i want to append. Is there any way to get around this...

Hi, I am new to VBA. Trying to enter data into a table names Signals. The command I'm using is DoCmd.RunSQL "INSERT INTO signals ([date], sw, c )VALUES (s_date, buyflag, rut);" It displays a parameter box to enter a value rather than using the variables I have defined. I'm stumped...