28-Jul-2006, 08:42 AM
|
 | Guest | | | | | | | | |
| Re: Use Value of a variable in vb function
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14002-use-value-of-variable-vb-function.html
> 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
> 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
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
--
----------------------------------------
I am using the free version of SPAMfighter for private users.
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
 |