[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Register Video Clip control in Access 2003?

Posted on 2006-05-02
7
Medium Priority
?
250 Views
Last Modified: 2008-01-16
Questions:
(1) is Video Clip control a part of Access 2003? Where is its folder?
(2) I got error message, "OLE server is not registered", when linking a .mpg file to a boun frame. What name should use  to register Video Clip control from tools-references list?
(3) Anyone could give me an example for user to generate an text file, based on a Access table records, and export this ASII file to hard drive?

Thanks.

0
Comment
Question by:TANGC-NCTIP
  • 5
  • 2
7 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16634451
TANGC-NCTIP,

This is really three questions, not one

<Video Clip control>
(1) Do you mean the Windows Media Player Control?
It is in the Controls tool box, under: "More Controls"

(2) Link by a Hyperlink Field, not a Bound frame.
Create a new field in your table called something like "HypLnkVid", and make the DataType: Hyperlink
Then, simply right-click the Hyperlink Field and choose: Hyperlink-->Edit Hyperlink.
Click the "File..." button.
Browse to the file you want
Click: OK
Click: OK again.

(3). Select the table in the database window.
Click File-->Export
Browes to the folder you want to place it
Save as Type: Text Files
Click Save
Select  Delimited
Click: Next
Select the Delimiter you want
Check On: Include Field names on Row 1
Click: Next
Click Finish

OK?

Any chance on tripling the points for Three questions?
0
 

Author Comment

by:TANGC-NCTIP
ID: 16643427
1) Do you mean the Windows Media Player Control?
It is in the Controls tool box, under: "More Controls"

No.  I need to use Video Clip ActiveX control to link Movie file by VBA codes only.  My cleint has no knowledge how to link manually and he doesn't like the media player.

(2) Link by a Hyperlink Field, not a Bound frame.
Create a new field in your table called something like "HypLnkVid", and make the DataType: Hyperlink
Then, simply right-click the Hyperlink Field and choose: Hyperlink-->Edit Hyperlink.
Click the "File..." button.
Browse to the file you want
Click: OK
Click: OK again.

I Shall try this.  But My client still wants to find the file on DVD disk in drive 'D:\' automaticaslly, no browse needed!

(3). Select the table in the database window.
Click File-->Export
Browes to the folder you want to place it
Save as Type: Text Files
Click Save
Select  Delimited
Click: Next
Select the Delimiter you want
Check On: Include Field names on Row 1
Click: Next
Click Finish

Again, my client needs to transfer some results from Access table to text file on hard disk by VBA code automatically.  There might have hundreds files need to be transferred.


I shall give you 300 if you could solve all of them.


0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16644460
“Multimedia”
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16644539
TANGC-NCTIP,

The rules of this site specify 1 question per post, see here:
http://www.experts-exchange.com/help.jsp#hi107

I see that you are a new member, just letting you know…

OK, In keeping with the spirit of this site, I will try to help you as best I can.

So let’s see where we are so far:

Question 1:
<is Video Clip control a part of Access 2003? Where is its folder?>
Answer: No
*Conclusion: Question 1 Answered.
Optional info:
I found it nowhere on a full install of Access 2003.
There are other "Video" and "Multimedia" type controls, but none with a name close to "Video Clip"
Could not be found in Access 2000 either.
There was a "Video Control" in Visual basic 6.0(1998). I have also heard of a "ActiveMovie control" but again this was 1996
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaractmov/html/msdn_actmovie1.asp

You could buy a third party Active x control, here are some links:
http://www.viscomsoft.com/products/videoeditgold/
http://www.mymusictools.com/download/activex/
http://www.download-by.net/development/active-x/cp0,9.html

Now, there is a reference to this "Video Clip" ActiveX control here:
http://support.microsoft.com/?scid=kb;en-us;884175&spid=2522&sid=313
But this refers to "PowerPoint", not Access.
In the above link the following statement is made:
>Additionally, the following objects are no longer available in the Insert Object dialog box:
>•      Media Clip
>•      MIDI Sequence
>•      Video Clip
>CAUSE
>This behavior occurs after you install Microsoft Windows XP Service Pack 2 (SP2). Windows XP SP2 classifies several >ActiveX controls as unsafe including the Media Clip, MIDI Sequence, and Video Clip controls. When you open a >presentation that contains ActiveX controls, PowerPoint verifies if the controls can be loaded. PowerPoint will not load the >control or make that control available as an object for you to insert on to a slide if Windows XP SP2 has marked the >ActiveX control unsafe.

(This may suggest that this control is no longer available)


Question 2:
<I got error message, "OLE server is not registered", when linking a .mpg file to a boun frame. What name should use  to register Video Clip control from tools-references list?>
Answer: "OLE Automation" (This is the reference)
Conclusion: Question 2 Answered. <'What name should use  to register Video Clip control from tools-references list?">
Optional Info:
But, that alone will not fix the problem.
The "OLE" server is the program associated with the file you are trying to open. These associations can sometimes be "Hi-Jacked"/changed by other products when they are installed.
That is why, most of the time the solution is to:
*Un-install, then Re-install Microsoft Office. *
(This is the most common solution to this problem on this site)
This restores the default associations that MS Office uses. (.jpeg files are a good example of this)
I have also had success importing all of my database objects to a brand new, blank database.
Also, make sure you have all the latest Service Packs for Window and Office.

Many things can cause this error, including Norton Anti-Virus
http://www.scholarware.com/supportfaq07.htm

If the error is corrected, the user will simply click the hyperlink, and the file will play.
1 follow up question: Is this Form "Bound" or "Un-Bound"? (The form, not the frame)


Question 3:
3) Anyone could give me an example for user to generate an text file, based on a Access table records, and export this ASII file to hard drive?
Answer:
Select the table in the database window.
Click File-->Export
Browse to the folder you want to place it
Save as Type: Text Files
Click Save
Select  Delimited
Click: Next
Select the Delimiter you want
Check On: Include Field names on Row 1
Click: Next
Click Finish
***Conclusion: *Question Answered.***

Now there is a "new", "modified" question 3?:
< Again, my client needs to transfer some results from Access table to text file on hard disk by VBA code>
<Again>?, The term "VBA" never appeared in the original question.
The Original question WAS answered!

Again, In keeping with the spirit of this site, I will provide the "VBA":

    DoCmd.TransferText acExportDelim, , "YourTableName", "FullPathAndFileNameIncludingExtension", True
   
The term “FullPathAndFileNameIncludingExtension”, would be something like this:
"C:\AccessFiles\ExportedTables\Table1.txt"

Here is the actual code I used to test this (Your object names will differ):
    DoCmd.TransferText acExportDelim, , "tblDetailVideos", "c:\tblDetailVideos.txt", True

Conclusion: Question 3 Answered for the second time.
0
 

Author Comment

by:TANGC-NCTIP
ID: 16651929
Thanks. Answers are accepted as they are.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 900 total points
ID: 16652951
Great!
Glad I could help!
:)

No just click the "Accept"  button to close the question(s)

Jeffc
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 16655063
Thanks !

(I meant "Now" just click...)
:)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question