Question » The problem is this: My boss has requested that I include an animated company logo which has been created using Flash in our Microsoft Access database splash screen, to be opened prior to the database switchboard form opening. From here i want to open any forms, queries and reports.
Is this possible, any help or advice would grateful as I have tried and can not find the solution?
ANSWER » Yes, this is possible using the following details and design -
If you are storing your Flash movie clip in the same directory as the database you can try the following:
With your start-up form in design mode, go to Insert » ActiveX Control. From the list choose Shockwave Flash Object:
The Insert dialog box, selecting the Flash Movie Object control.
Form in design view showing Shockwave Flash Object control
Property window showing obj_flashmovie properties
Now go to the properties of the form, and for the On Activate Event Procedure add the following code:
Private Sub Form_Activate() Me.obj_flashmovie.Movie = Application.CurrentProject.Path + "\Movie1.swf" End Sub
Change the Movie1.swf to the name of your flash file.