Results 1 to 2 of 2
  1. #1
    Wasser2021 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jun 2021
    Posts
    10

    Add or copy a wave file to a OLE Field ?

    If you want, just have a look at my help document. I just need some VBA code to copy any file, in this case a wafe file to a certain table in a certain field in this case field name is sound. It is an OLE type field.
    I haven't found a way to do this with macros or VBA editor.

    Please take a look into my attachments that make it clearly. Hopefully...


    It would be very nice if I get a help here. Thank you in advance.
    Attached Files Attached Files

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    OLE is a very old technology and I recommend you don't use OLE for this (nor its 'replacement' - attachment fields).
    Instead save the wave files in a separate subfolder of your Access app and refer to the file path in code to play the file

    You may find the code I used with my countdown timer useful. This includes a library of 20.WAV files together with code to play any selected file.
    You are welcome to make use of the use for your own purposes.

    For more details and the example app, see Countdown Timer - Mendip Data Systems. Hold down the shift key when you open the app to view the code
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Copy text file to Memo Field
    By HDobler in forum Programming
    Replies: 5
    Last Post: 06-25-2021, 02:21 AM
  2. unable to copy file
    By YADAV.DHARMESH in forum Access
    Replies: 7
    Last Post: 09-18-2014, 10:17 AM
  3. Copy Open db file
    By gg80 in forum Programming
    Replies: 4
    Last Post: 04-24-2013, 04:35 PM
  4. Replies: 3
    Last Post: 09-28-2012, 03:05 PM
  5. Copy file to folder
    By tpcervelo in forum Programming
    Replies: 11
    Last Post: 08-31-2010, 10:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums