Automation

M

Matt_Barraud

Hi there

I am trying to get a text box to automatically fill itself in by getting
data from another text box and merging it into a network path to an object.
e.g.
Text1 has a students ID number stored in it such as S000123
Text2 has the path to the network resource such as \\abcd-12\images\

What i would like to code is that access pulls the data out of text1 and
puts it at the end of text2's path to give: \\abcd-12\images\s000123

The other thing i would like it to do is add .jpg at the end

Any ideas?
 
T

Tom Wickerath

Hi Matt,

It sounds like you just want to concatenate the values from Text1 and Text2,
along with the file extension. Try adding a new textbox to your form. Set the
Control Source as follows:

= Text2 & Text1 & ".jpg"

Note that you should not store calculated values in the database. This
control source will display the calculated result, but it will not store it.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?", which should be visible at the bottom
right corner of your screen.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi there

I am trying to get a text box to automatically fill itself in by getting
data from another text box and merging it into a network path to an object.
e.g.
Text1 has a students ID number stored in it such as S000123
Text2 has the path to the network resource such as \\abcd-12\images\

What i would like to code is that access pulls the data out of text1 and
puts it at the end of text2's path to give: \\abcd-12\images\s000123

The other thing i would like it to do is add .jpg at the end

Any ideas?
 
Top