+ Reply to Thread
Results 1 to 2 of 2

Concatenate sql "for loop" statement

  1. #1
    Registered User
    Join Date
    10-19-2009
    Location
    singapore
    MS-Off Ver
    2010,2013
    Posts
    45

    Concatenate sql "for loop" statement

    Hi,

    i would like to create for loop append sql statement. I have named txtboxes to txt_f1, f2,f3.. same goes to the rest, as the for loops continue to append the sql statement the textboxes name will continue to change the integer respectively together with the for loop integer so that i dun have to replicate the code with extra line which cater to the specific textbox when the difference is only 1,2,3,4...

    anyone did this concatenation before ? i couldn't concatenate all of the attribute together. Please advise were they be a alternative ways to do it?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Concatenate sql "for loop" statement

    Me.Controls("txt_" & NumOfFollowup).Value

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF Statement Evaluates as "TRUE" but Returns "FALSE" Value (Excel 2007)
    By Simcik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2014, 12:43 PM
  2. [SOLVED] How to re-use macro? Best way to loop and "exit" with comparison statement ?
    By varreddor in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-21-2013, 08:43 PM
  3. Need first statement to Loop until "False"
    By bruce2444 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2009, 12:23 PM
  4. Replies: 3
    Last Post: 12-14-2006, 01:36 PM
  5. Replies: 0
    Last Post: 07-17-2006, 09:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1