By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

save files into an OLE object data type

P: 6
guys, please help. =(

how can I save files into a field in a table with data type OLE object?
May 9 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,619
guys, please help. =(

how can I save files into a field in a table with data type OLE object?
'Code to Programmatically Embed or Link an Object in a Form
Expand|Select|Wrap|Line Numbers
  1. 'Specify what type of Object can appear in the Field
  2. Me![OLE_Field].OLETypeAllowed = acOLELinked
  3. 'Me![OLE_Field].OLETypeAllowed = acOLEEmbedded
  4. 'Me![OLE_Field].OLETypeAllowed = acOLEEither
  5.  
  6. 'Specify the File to be Linked
  7. Me![OLE_Field].SourceDoc = "C:\Dell\Pivot Table.xls"
  8.  
  9. 'Specify the (optional) Cell Range to link to
  10. 'Me![OLE_Field].SourceItem = "R1C1:R5C5"
  11.  
  12. 'Create the Linked Object. Thare are 11 possible
  13. 'Action Arguments
  14. Me![OLE_Field].Action = acOLECreateLink
May 9 '07 #2

P: 6
Thank a lot :)
May 10 '07 #3

ADezii
Expert 5K+
P: 8,619
Thank a lot :)
You're welcome.
May 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.