Need loop help, add records by field that match query records

Thanks for all the help so far, this forum is great. I have one other function that I need help with. I have a tblPayments that stores the actual and projected costs by cost code and billing period; the billing periods are pulled from a separate ...

Message posted on the July 3rd, 2011 - 8:00 PM ET

Loop Help

I found this code & is very close to what I need! Since I'm a novice at code writing, I find what I need & then try to modify. I think this will work but I need a "do loop" or something to select "This" and ...

Message posted on the February 20th, 2009 - 08:26 am ET

Need MVP Help - OL 2007 Contact "Email Addresses Not Valid"

Windows Vista Home Premium 64 Bit Office 2007 Ultimate with Outlook 2007 SP1 Problem: How to fix e-mail addresses in Contacts with invalid display names. Error Message: “The name or distribution list has been deleted and is no longer a valid ...

Message posted on the January 23rd, 2009 - 12:41 pm ET

Got it working! First post from inside Damn Small Linux! Need more help pls

OK, live and learn. Repost since my first post got lost when Firefox unexpectedly disappeared from my Linux screen. But not blaming Linux (Damn Small Linux) since I have a Pentium II with 1 GB (!) hd and a few sticks of RAM. Can't expect much. ...

Message posted on the June 08th, 2010 - 08:27 am ET

Copying a sequence of records with a loop - Help

I want to copy a sequence of records from one form to another. At the moment this is done via a command button with the code below. But having to click the button each time is becoming painful on my fingers (there are '000s of mouse clicks). So what ...

Message posted on the February 21st, 2009 - 07:22 am ET

Need VBA Help...adding and deleting 40 sheets

I'm stuck. I am hoping someone can point me in the right to resolve this. I am working on a project using Excel 2003. I am programmatically adding about 40 worksheets to the workbook, loading them with data from text files. I am using a hidden ...

Message posted on the August 05th, 2009 - 09:02 am ET

LOOP HELP!

I am trying to create a loop in which it will ask the same questions to the user repeatedly until the user opts out. However, I need to be able to reference the answers to all of their questions each time they go through the loop. How do assign a ...

Message posted on the May 04th, 2009 - 05:23 pm ET

Find and loop help-multiple columns

I an trying to write a macro to search for a cell value in one column and see if it occurs in other columns I'm having 2 problems: 1. How can I look from the last used row up to row 4 in "myrange+5" as set below? 2. How can I look in ...

Message posted on the April 20th, 2010 - 03:55 pm ET

need some help

i have 2 tables: CREATE TABLE [dbo].[table1]( [tbl1ID] [int] identity(1,1), [cID] [int] NOT NULL, [pID] [int] NOT NULL, [rate] [decimal](6, 3) NULL, [groupID] [decimal](6, 3) NULL) GO CREATE TABLE [dbo].[table2]( [tbl2ID] [int] identity(1,1), ...

Message posted on the June 10th, 2011 - 09:13 am ET

hi guys (thanks for loop help) part 2: cumulative summing/counting

Hey Guys, need some greater minds than mine to help me out so I need it to cumulatively sum the 1's in column a but the moment there is a 0 it needs to stop summing.Then once there is a 1, start the process from 1 again. This is going from the ...

Message posted on the July 24th, 2009 - 06:06 am ET

Need some help constructing a Do While statement

I would like to get information from column D of Sheet1 into column E of Sheet2 where a one to many relationship exists between them (One row in Sheet2 could have 0 to x matching rows in Sheet1). Column B in both sheets contains the value (a text ...

Message posted on the April 27th, 2009 - 01:28 pm ET

Insert rows based on a count value **** Need some help ****

Hello, I was wondering if it would be possible to write a single T-SQL statement which will insert XX number of rows into a table based on count without the need to iterate through a loop. For example, let's say I have a temp TableA which contains ...

Message posted on the January 14th, 2009 - 06:56 pm ET

Need some help with ASP code

This the code inside an ASP file Set rsPromoSale = MSCS.Execute(strSQL) If Not rsPromoSale.EOF Then ' They have X in their basket Do While Not rsPromoSale.EOF ' Response.Write "PROMO: " & rsPromoSale("cond_value") & ...

Message posted on the September 03rd, 2009 - 11:30 am ET

[PATCH] x86, kdump: No need to disable ioapic in crash path

A customer of ours noticed when their machine crashed, kdump did not work but hung instead. Using their firmware dumping solution they grabbed a vmcore and decoded the stacks on the cpus. What they noticed seemed to be a rare deadlock with the ...

Message posted on the February 02nd, 2012 - 01:20 pm ET

		Advanced search
In

need loop help