xbb4ac
07-08-2001, 03:54 PM
I'm developing an MS Access DB for a highschool assignment. I've managed to do a lot so far, much more than the criteria requires but I got hooked on Access and I wan't to go even further with my project, just for personal satisfaction...and to impress my friends ofcourse. However, there are two problems I have encountered.
Firstly, I would like to include an animation in my startup form. I've made an avi file and inserted it in my form by the 'insert -->object-->from file' option. I've played around with the properties and managed to make it self activate amd loop when the form is opened. All the avi player controls are hidden and there's no border so the animation looks like its part of the form. However, the animation requires the external avi file to run and if the location is changed, the animation won't work. I think its because the animation is being opened in edit mode. Is there a way to completly integrate the avi file in the database like a picture and still make it self activating? Or is there a way to provide a general link so the DB looks for the avi file in the directory or subdirectory of where the .mdb file is being run from?
Secondly, I've made a few movies with MS CamCorder as part of my help system. The movies have an exe extension. I have a form which has buttons bound to macros which open these movies using the 'RunApp' command and the full file path. This works but has the same problem as above. If the file location is changed, the movies won't run. Again, is there a way to generalise the link to a subdirectory only? Or is there another way to get around the problem?
These problems are important because when I give the database in for marking, the teachers may have a different drive letter or something and it will reflect badly on me if things don't work properly so I would appreciate any help you could offer. Also, remmember I'm only a highschool student so I have no Visual Basic knowledge and I don't know how to use modules.
I'm looking forward to your reply. If you can't help or don't know what I'm babbling on about don't worry about it.
Thanks
Firstly, I would like to include an animation in my startup form. I've made an avi file and inserted it in my form by the 'insert -->object-->from file' option. I've played around with the properties and managed to make it self activate amd loop when the form is opened. All the avi player controls are hidden and there's no border so the animation looks like its part of the form. However, the animation requires the external avi file to run and if the location is changed, the animation won't work. I think its because the animation is being opened in edit mode. Is there a way to completly integrate the avi file in the database like a picture and still make it self activating? Or is there a way to provide a general link so the DB looks for the avi file in the directory or subdirectory of where the .mdb file is being run from?
Secondly, I've made a few movies with MS CamCorder as part of my help system. The movies have an exe extension. I have a form which has buttons bound to macros which open these movies using the 'RunApp' command and the full file path. This works but has the same problem as above. If the file location is changed, the movies won't run. Again, is there a way to generalise the link to a subdirectory only? Or is there another way to get around the problem?
These problems are important because when I give the database in for marking, the teachers may have a different drive letter or something and it will reflect badly on me if things don't work properly so I would appreciate any help you could offer. Also, remmember I'm only a highschool student so I have no Visual Basic knowledge and I don't know how to use modules.
I'm looking forward to your reply. If you can't help or don't know what I'm babbling on about don't worry about it.
Thanks