QUESTION ? - How to provide (Lookup List) with 2 colums + picture

[Patrick Carbonneau]

Recently, I create a new database (datasheet) and following that I have
created an electronic form where all my field are listed. I have a very
particular question and I would appreciate if someone could help me to
resolve this problem.

I have create a field called (exterior camera angles viewing) through my
original datasheet. Since this field offered up to 3 choices, I have create a
'' Lookup List ''.

Here my request below:

Since this database is associated to a company within (animation
marketing/sales) for my designated field above , for each lookup List of

Field (exterior camera angles viewing)
colum -1 colum- 2
choice answer 1 - correcponding picture or short avi video animation
choice answer 2 - corresponding picture or short avi video animation
choice answer 3 - corresponding picture or short avi video animation

 

[Scott McDaniel]

Here my request below:

Since this database is associated to a company within (animation
marketing/sales) for my designated field above , for each lookup List of

Field (exterior camera angles viewing)
colum -1 colum- 2
choice answer 1 - correcponding picture or short avi video animation
choice answer 2 - corresponding picture or short avi video animation
choice answer 3 - corresponding picture or short avi video animation

I assume that you want to launch a Picture or AVI based on the user's selection?

If so, how are you storing the pics and avi? The preferred way is to store the full path to the item and then use
various methods to launch them. The simplest method is the Shell command:

Sub YourCombo_AfterUpdate()
'/Columns are zero-based, so column 1 is actually 0, column 2 is 1, etc
Shell Me.YourCombo.Column(1)
End Sub

This will launch whatever program is associated with the file's extension (i.e. .jpg would launch an editing program,
..avi would launch a movie player, etc).

You can display pictures on your access form using an Image object, but AFAIK there is no native method to play AVI
files in Access. There are various ActiveX controls you could use to do this, but they can be somewhat troublesome in
Access.

If you're actually storing these objects in your Access database, then I'd urge you to rethink that method. It can cause
significant bloat and frequent corruption.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Patrick Carbonneau]

Hey ! Hello again Scott,

Thanks to reply to my previous message

INFORMATION ?

I think you exactly understand what I am looking to achieve. I would
definitevely prefer to launch & play an *.avi (animation file) based on the
user selection.

Based on your question about how I stored my *.avi files in a different
directory or I would say I new directory in my laptop.


In order to achieve this, you have recommended me to program SHELL command,
I am a very beginner so to be honest with you ! I don't know how to do this
? I would appreciate to get more detailed how to program this automatically.

Thanks very much !

Patrick


====================================================
Sub YourCombo_AfterUpdate()

'/Columns are zero-based, so column 1 is actually 0, column 2 is 1, etc
Shell Me.YourCombo.Column(1)
End Sub

=====================================================