Use Value of a variable in vb function

#1 (**permalink**) 28-Jul-2006, 08:42 AM

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
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14002-use-value-of-variable-vb-function.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002

Thanks a bunch for your help!

Nichole

#2 (**permalink**) 28-Jul-2006, 08:42 AM

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
> 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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
>
> 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.
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

#3 (**permalink**) 28-Jul-2006, 08:42 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> > 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!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> >
> > Nichole
> >
> >
>
>
>
> --
> ----------------------------------------
> 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
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:42 AM

Worked perfectly! Thank you very much!

"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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> > 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:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14002
> >
> > 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.
> 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
>
>
>