Results 1 to 2 of 2
2007-12-07, 19:52 #1
- Join Date
- Jan 2001
- New England (Connecticut)
- Thanked 0 Times in 0 Posts
ole objects assigned to multple records (office 2003)
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?
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
2007-12-07, 20:22 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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?