Access VBA ActiveX Controls

Hi there,

I’m trying to get a simple Shockwave Movie to play in the splash screen on my Access 2000 (VBA) application, but seem to be having some difficulty with the syntax. I know that when I’m working in VB6 I simple add a Shockwave Flash Component as use syntax of the form:

ControlName.Movie = App.Path & "MovieName.swf"
ControlName.Play

However in Access when I insert an ActiveX Control on my form I have a choice of either a “Shockwave ActiveX Control” or a “Shockwave Flash Object”, which one do I use to play a simple movie file, can I define the file path in the properties of the ActiveX Control or in the code, and what is the correct syntax to use???

I’d really appreciate any help with this problem as I’m having great difficulty finding any information about using Shockwave/Flash in Access applications.

Many thanks: Gavin.

Well for the app.path alternative, you can try using...

msgbox CurrentProject.Path

For the other one, no idea which control to use but when you select the control in the vb ide control selection box, it shows you the path name & filname of the control doesn't it?

I think you could do a browse for a control in access where you could specify to add in this control also...