set path in global variable

[anick]

I have a database containing 2000 pictures and their informations. All the pictures are presently IN the database as bitmaps. They are planning to add more pictures.

I have an idea but I'm not sure if its possible or how to do it... so what I want to do is to put all the pictures (in jpg) in a folder and set the path to that folder in a global variable. Then, I would add a text field on my form. The user would put the name of the file (the picture) in that field. Ideally, this file name would be added to the path and therefore, it would show the picture on the form...

Is this possible? I would appreciate any kind of help!! Thanks in advance.

 

[Travis]

Different approaches to this:

1. Create a single Record Table to store the path (Use DLookup to get the entry)

2. Create a Modual and add a Public variable in the Declarations section. ie Public cstrPath="C:\Temp\"

3. Add the path information to a registry setting

 

[anick]

Let's say i'm choosing #2, there would be a way for me to concatenate the file the person just entered in the text field on the form with the public variable so I can show the picture on the form?

Thanks for your help!

 

[Travis]

The control source (or file source property) would be this:

=cstrPath & [Picture File Field Name]

 

[directormac]

Anick: It's considered bad form to cross-post a question for which folks are already offering you advice in another thread.

--Miss-Manners Mac