Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Use Value of a variable in vb function

Discussion in 'Information Technology' started by NMThoman, Jul 28, 2006.

  1. NMThoman

    NMThoman
    Expand Collapse
    Guest

    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.

    Thanks a bunch for your help!

    Nichole
     
  2. Loading...

    Similar Threads Forum Date
    Sikh Values Blogs Oct 21, 2015
    Jainism Jainism and Sikhism: The Value of Being “Footnote” Traditions Interfaith Dialogues Jul 13, 2015
    World Why do we value gold? Breaking News Dec 9, 2013
    Canada Quebec's Charter of Values: If You Have A Personal Story, Please Share It Here! Breaking News Sep 19, 2013
    Canada Thousands March through Montreal to Protest Quebec Charter of Values (& Video) Breaking News Sep 16, 2013

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Use the construct Me.Controls("H" & Num).value

    Pieter

    "NMThoman" <NMThoman@discussions.microsoft.com> 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,
    > 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.
    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. NMThoman

    NMThoman
    Expand Collapse
    Guest

    Thanks a bunch, I will try it.

    Nichole



    "Pieter Wijnen" wrote:

    > Use the construct Me.Controls("H" & Num).value
    >
    > Pieter
    >
    > "NMThoman" <NMThoman@discussions.microsoft.com> 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,
    > > 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.
    > 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
    >
    >
    >
     
  5. NMThoman

    NMThoman
    Expand Collapse
    Guest

    Worked perfectly! Thank you very much!

    "Pieter Wijnen" wrote:

    > Use the construct Me.Controls("H" & Num).value
    >
    > Pieter
    >
    > "NMThoman" <NMThoman@discussions.microsoft.com> 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,
    > > 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.
    > 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
    >
    >
    >
     

Share This Page