<div>
<br />
Create/use a table with an &quot;OLE Object&quot; type field.<br />
<br />
design a form and insert a &lt;Bound Object Frame&gt; named eg &quot;OLEFile&quot; and a &lt;textbox&gt; named eg &quot;txt1&quot; for the filename and a &lt;command button&gt; named eg &quot;Command1&quot;.<br />
define a commandhandler for Button1 and write :<br />
<br />
Private Sub Command1_Click()<br />
&nbsp; [OLEFile].Class = &quot;Word.Document&quot;<br />
&nbsp; [OLEFile].OLETypeAllowed = acOLEEmbedded<br />
&nbsp; [OLEFile].SourceDoc = [txt1]<br />
&nbsp; [OLEFile].Action = acOLECreateEmbed<br />
&nbsp; DoCmd.RunCommand acCmdRecordsGoToNew<br />
End Sub<br />
<br />
now the file is saved in the database.
</div>



Create/use a table with an "OLE Object" type field.

design a form and insert a <Bound Object Frame> named eg "OLEFile" and a <textbox> named eg "txt1" for the filename and a <command button> named eg "Command1".
define a commandhandler for Button1 and write :

Private Sub Command1_Click()
  [OLEFile].Class = "Word.Document"
  [OLEFile].OLETypeAllowed = acOLEEmbedded
  [OLEFile].SourceDoc = [txt1]
  [OLEFile].Action = acOLECreateEmbed
  DoCmd.RunCommand acCmdRecordsGoToNew
End Sub

now the file is saved in the database.

<div>
<br />
Hi svenkarlsen<br />
again the same thing, I have to become faster &nbsp; :-(
</div>



Hi svenkarlsen
again the same thing, I have to become faster   :-(

<div>
<div class="content wysiwyg-content">
 I want to insert a file ex. &quot;c:\123.doc&quot;, in a automatic way, in i a bound object frame.<br />
I have a record number, example &nbsp;123, where I input various infos, then in this record (table) I need to insert (OLE) a file, but I don't want to use the keyboard or the mouse to do it. I want that this is made automatic.<br />
Can you help me? The dabase picks the file in the positions identified by me and thens inserts it in the object frame.<br />
<br />
Thanks,<br />
<br />
Paulo Marques<br />
<br />

</div>
</div>


 I want to insert a file ex. "c:\123.doc", in a automatic way, in i a bound object frame.
I have a record number, example  123, where I input various infos, then in this record (table) I need to insert (OLE) a file, but I don't want to use the keyboard or the mouse to do it. I want that this is made automatic.
Can you help me? The dabase picks the file in the positions identified by me and thens inserts it in the object frame.

Thanks,

Paulo Marques



Insert a file in a bound object frame

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.