28-Jul-2006, 08:42 AM
|
 | Guest | | | | | | | | |
| Re: Use Value of a variable in vb function
Thanks a bunch, I will try it.
Nichole
"Pieter Wijnen" wrote:
> Use the construct Me.Controls("H" & Num).value
>
> Pieter
>
> "NMThoman" wrote in message
> news:790FDBA6-4CA1-4CC2-AA4E-3DCFEF602384@microsoft.com...
> >I have 12 fields in a form (H1, H2, H3, etc). Each field has a button that
> > can be clicked to perform an action (move all the values up one space, or
> > down one space). On click, I pass the number 1, 2, 3, etc. to the vb
> > function to know where to start shifting data.
> >
> > I am attempting to create a "generic" statement that can be used for all
> > 12
> > fields. To do this I have said that my variable = "H" & Num (Num being
> > populated with 1-12). This works fine. My variable (holdentry) then
> > equals
> > H3 (for example).
> >
> > I then have another variable that I am trying to equate to the value of
> > the
> > variable. H3, for example, represents a field on my form. I want my new
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14002-use-value-of-variable-vb-function.html
> > variable to be = to the value stored in H3 on the form. It's a hire date.
> > So if the date is 4/23/2000. I want my new variable to = 4/23/2000. Not
> > the
> > string H3. I have made many attempts with single and double quotes,
> > ampersands, etc. I obvioulsy have something wrong, because I either get
> > the
> > "string" H3, or I get the variable name (holdentry). I then want to test
> > this field for specific things.
> >
> > My latest attempt was:
> >
> > holdentry = "H" & Entry
> > (where Entry contains a number 1 - 12 --- 3 in this case)
> >
> > I would like to know the screen/form value of H3.
> >
> > holdEntryValue = "'" & holdentry & "'"
> >
> > (double quote, single quote, space, ampersand, space, variable, space,
> > ampersand, space, quote, single quote, quote).
> >
> > Any suggestions will be greatly appreciated. I have done this before, I
> > just can't remember the exact formatting used before.
> >
> > Thanks a bunch for your help!
> >
> > Nichole
> >
> >
>
>
>
> --
> ----------------------------------------
> I am using the free version of SPAMfighter for private users.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> It has removed 4367 spam emails to date.
> Paying users do not have this message in their emails.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>
>  |