Programming Help

Web Development



What's Here?

  • Members: 132,707
  • Replies: 471,821
  • Topics: 73,161
  • Snippets: 2,541
  • Tutorials: 667
  • Total Online: 1,354
  • Members: 81
  • Guests: 1,273

Who's Online?

Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 132,707 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,354 people online right now. Registration is fast and FREE... Join Now!




using variable result as a variable

 
 Reply to this topicStart new topic

using variable result as a variable
jamesagarry
post 4 Sep, 2008 - 12:39 PM
Post #1


New D.I.C Head

*
Joined: 4 Sep, 2008
Posts: 3

Hi, thanks in advance.

I am writting a project in vb6.

I have a module where I do lots of caluclations. I want to update an access database with the results of the calculateions. then export to a file.
no problem.

my problem is
Private Sub AddAAS()

dim statements etc ...




rs_ReportOut1.Open strsql, conn, adOpenKeyset, adLockPessimistic
x = 0
i = 0
' the reason for this is I just need teh values dbl_aa189 throught about
' 80 values . this is just for testing and checking numbers
i = 189
For x = 0 To 80
' this makes the variable name

str_name = "dbl_aa" & i

If str_name = "dbl_aa201" Then
MsgBox "here"
End If
arr_Field(x) = (str_name)

' arr_Value (x)


i = i + 1
Next x
User is offlineProfile CardPM

Go to the top of the page

thava
post 4 Sep, 2008 - 10:05 PM
Post #2


D.I.C Regular

Group Icon
Joined: 17 Apr, 2007
Posts: 425



Thanked 17 times

Dream Kudos: 50
My Contributions
pls Clear !!!!!!!!!!!!
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 5 Sep, 2008 - 01:16 AM
Post #3


D.I.C Addict

Group Icon
Joined: 30 Jun, 2008
Posts: 561



Thanked 16 times

Dream Kudos: 575
My Contributions
Your problem with the code is not clear. You need to explain the following things:

Any error you are getting and on which line you are getting.

If something is not happening as per your plan then what you are trying to do and what you are getting.

Please use Code Tags while posting code.
Example: code.gif
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 08:38AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month