Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    ole objects assigned to multple records (office 2003)

    Hi all,

    I am using the below code to link an excel spreadsheet to a record in a table and it is working great. My question is that on some occaisions, this object may need to be linked to more than one record. I am not sure if the code below can be used to link the records to the object using a looping structure or if it can be done in an SQL statement. I am able to create a basic loop structure but am not sure how to tackle this one. Can someone provide me with a few pointers?

    Code:

    DoCmd.OpenForm "frmSelectFileXP", acNormal, , , , acDialog
    oleTechnicalReport.Class = "Excel.Sheet" ' Set class name.
    ' Specify type of object.
    oleTechnicalReport.OLETypeAllowed = acOLELinked
    ' Specify source file.
    oleTechnicalReport.SourceDoc = Me.vTARReportName
    ' Create linked object.
    oleTechnicalReport.Action = acOLECreateLink
    oleTechnicalReport.SizeMode = acOLESizeZoom


    Thanks
    Kevin
    Kevin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ole objects assigned to multple records (office 2003)

    Could you provide some more details? How do you determine which records should be used?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •