How do I declare a variable that allows data to be added to it without losing its existing value?

[Colleyville Alan]

I seem to recall reading somewhere that there was a keyword that allowed a
variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?

[Randy Harris]

"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:hQ5Xb.3019 71$xy6.1484743@ attbi_s02...

I seem to recall reading somewhere that there was a keyword that allowed a
variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?

There's no keyword to do that, however, you can use:

myvar = myvar & a
myvar =myvar & b

[Mike Storr]

myvar = a & b

Mike Storr
www.veraccess.com
"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:hQ5Xb.3019 71$xy6.1484743@ attbi_s02...

I seem to recall reading somewhere that there was a keyword that allowed a
variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?

[Colleyville Alan]

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:Y0******** ************@ne wssvr28.news.pr odigy.com...

"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:hQ5Xb.3019 71$xy6.1484743@ attbi_s02...

I seem to recall reading somewhere that there was a keyword that allowed a variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?

There's no keyword to do that, however, you can use:

myvar = myvar & a
myvar =myvar & b

Well, to be more specific, I am trying to load the contents of an array into
a variable string.

For x = 1 To iNumRecs3 Step 1
myStr = rstMyRecs![Group] & " " & rstMyRecs![Name] & " "
rstMyRecs.MoveN ext
Next x

Msgbox("The missing information is" & myStr)


I cannot figure out how to do this. Right now, the myStr gets overwritten
each time through. How can I add to this variable from a loop?

[Randy Harris]

"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:Uf6Xb.1706 81$U%5.797137@a ttbi_s03...

"Randy Harris" <ra***@SpamFree .com> wrote in message
news:Y0******** ************@ne wssvr28.news.pr odigy.com...

"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:hQ5Xb.3019 71$xy6.1484743@ attbi_s02...

I seem to recall reading somewhere that there was a keyword that

allowed

a variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?
There's no keyword to do that, however, you can use:

myvar = myvar & a
myvar =myvar & b

Well, to be more specific, I am trying to load the contents of an array

into a variable string.

For x = 1 To iNumRecs3 Step 1
myStr = rstMyRecs![Group] & " " & rstMyRecs![Name] & " "
rstMyRecs.MoveN ext
Next x

Msgbox("The missing information is" & myStr)


I cannot figure out how to do this. Right now, the myStr gets overwritten
each time through. How can I add to this variable from a loop?

For x = 1 To iNumRecs3 Step 1
myStr = myStr & rstMyRecs![Group] & " " & rstMyRecs![Name] & "
"
rstMyRecs.MoveN ext
Next x

[Colleyville Alan]

> >

I cannot figure out how to do this. Right now, the myStr gets overwritten each time through. How can I add to this variable from a loop?
For x = 1 To iNumRecs3 Step 1
myStr = myStr & rstMyRecs![Group] & " " & rstMyRecs![Name] &

" "
rstMyRecs.MoveN ext
Next x

I must be getting punchy since I used that exact same way of doing things in
many SQL statements but could not see it as a solution here!
Thanks

[Tom C]

Alan,
I create a module to put all my global public variables in.
Each variable is prefaced with the word "Public" (g for global)

i.e. Public gstrMyGlobalCon stant As String
Public gstrAnotherGlob alConstant as string

These variables can then be set from anywhere in the program and the
value will remain even after the procedure which set them is complete.

In response to your code as listed in your original note, I think you may
want to try something a bit different such as:

gstrMyGlobalCon stant = "Hello"
gstrAnotherGlob alConstant = "Alan"

In order to now place BOTH values into one variable you could use:

myvar = gstrMyGlobalCon stant & " " & gstrAnotherglob alConstant
the result would be: "Hello Alan"

OR
myvar = gstrMyGlobalCon stant
myvar= myvar & " " & gstrAnotherGlob alConstant
the result would again be: "Hello Alan"

Hope this helps.

Tom
"Colleyvill e Alan" <ae***********@ nospam.comcast. net> wrote in message
news:hQ5Xb.3019 71$xy6.1484743@ attbi_s02...

I seem to recall reading somewhere that there was a keyword that allowed a
variable to have data added to it without losing its contents.

a = "Hi " and
b = "There"

myvar = a
myvar = b

the value of myvar after this would be "Hi There".

How do you do accomplish this?