Combining fields 3

[hoofit]

I have the following code:

strSql = "Insert into tblImage (txtImageName, fileName) VALUES ('" & strFolder & "', '" & strFile & "')"

Here's the values:
txtImageName is a field
fileName is a field
strFolder is "c:\photo"
strFile is "pic1.bmp"

I need to combine the 2 outputs to read c:\photo\pic1.bmp. Can this be done in code?

Thank you

 

[dhookom]

Try:

strSql = "Insert into tblImageNames (FolderPath, strFolder, aImages) VALUES ('" & strFolder & aImages(i) & "', '" & strFolder & "', '" & aImages(i) & "')"

Duane
Hook'D on Access
MS Access MVP

 

[hoofit]

dhookum,
that's it by golly It would be quite a lengthy explanation of why I need this arrangement. As an overall view, the code cycles loops thru a particular folder on the hd that contains photos. The links to these photos are stored in a table to minimize space. First, the code looks for the correct folder and stores it. Next, it looks for an associated photo link. The array is returned and assembled in code to form the complete folder path.(the combined field you guys helped create) I suppose there are a ton of ways to do this. Maybe this is a better explanation.

Thank you kindly

hoof

 

[PHV]

OOps, sorry for the typo.
Thanks Duane for the correction.