linking to pictures in access

[Steven]

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)

[Tom van Stiphout]

On 2 Nov 2004 04:58:38 -0800, st**********@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.

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)

[Steven]

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!

[Tom van Stiphout]

On 03 Nov 2004 10:06:58 GMT, Steven <bo*@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.

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!