image file = *wildcard*

[casey]

Hello all,

Is it possible to use a wildcard character when setting an image control = to an unknown file type (.bmp, .jpg, etc...)?

I'm trying to point an image control to a file. It works, but because I'm unsure what type of image, I would like to change the command to use a wildcard at the end of the search string to have the control look for any image file type with the same ImageLocation key.

i.e. Form's OnCurrent
[imgPicture]="C:\Images\" & [FileLocation] & ".*"

This does not work though.

Can I set the image control to look for a wildcard in this way?

Thanks.

 

[casey]

I don't think I can do this

Probably not?

 

[IMO]

Maybe you can adapt this example

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45260

IMO

 

[casey]

IMO,

Thanks for your response. I took the day off, but will check out the example when I get the chance tomorrow.

 

[casey]

IMO,

Got a chance to look at your db. It's great!
I'm wondering how you accessed a picture without knowing the TYPE of picture though. I'm unable to see your code, but I'm interested in knowing how to do that.

Thanks.

 

[IMO]

Casey,

When you open the db, hold down the shift key, you'll be able to see the code then. The 'modPath_File' module has the code for the file types.
ie:
Select Case Types
Case "xls", "JPG", "PCD", "PCX", "WMF", "EMF", "DIB", "BMP", "ICO", "EPS", "PCT", "DXF", "CGM", "CDR", "TGA", "GIF", "PNG", "WPG", "DRW"

let me know how you get on

IMO

 

[casey]

Thanks IMO,

Thanks for your help. My db is not as complex as what yours, but it really helped.

I can move forward now...