linking to pictures in access

i want to be able to find jpeg's in a certain directory on my server
and then link them to an id and display them in a form. at present the
table is very basic but i am struggling on how to make this default
directory so that access can find the pictures automatically without
intervention. any help would be greatly appreciated :o)

re: linking to pictures in access

On 2 Nov 2004 04:58:38 -0800, steven.kelly@gmwn.co.uk (Steven) wrote:

Your program should have an Options form, where the user can specify
the root folder for your images. Such options can be stored in a table
with a single record. At application startup time the options can be
read into a UDT, for later use.
The images can be linked by filename, so you would have a table with
ImageNumber, ImageFilename. This is just a simple filename, not a
path. The path is concatenated from the root folder in the UDT and the
simple filename.

-Tom.

[color=blue]
>i want to be able to find jpeg's in a certain directory on my server
>and then link them to an id and display them in a form. at present the
>table is very basic but i am struggling on how to make this default
>directory so that access can find the pictures automatically without
>intervention. any help would be greatly appreciated :o)[/color]

re: linking to pictures in access

Hi Tom,

Thanks for replying. I'm using Access 2000. I'm unsure what a UDT is.
Could you let me know please.

Thanks,

Steven



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

re: linking to pictures in access

On 03 Nov 2004 10:06:58 GMT, Steven <bob@bob.com> wrote:

UDT = User Defined Type

Type typGlobals
strImageRootDir as String
' other globals
End Type

Global g_Globals as typGlobals

g_Globals.strImageRootDir = rs("ImageRootDir")

etc.

-Tom.

[color=blue]
>
>
>Hi Tom,
>
>Thanks for replying. I'm using Access 2000. I'm unsure what a UDT is.
>Could you let me know please.
>
>Thanks,
>
>Steven
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it![/color]