Access97 - OLE object in a form

In a subform I'm collecting and displaying OLE objects (usually Word docs) associated with a database record. There can be any number of OLE objects associated with one record.

I've been trying to import OLEs by dragging from Windows Explorer and dropping into the subform. It kind of works in that the file name is displayed however, when I double-click on the file name it doesn't open. If I go to the table behind the form, the file is there and can be opened no problem.

Why can't I open the file from the subform? Any ideas anyone?
AngeAsked:
Who is Participating?
 
nico5038Connect With a Mentor Commented:
Can you drop the compacted database in my nico5038 mailbox "at" yahoo.com, then I'll take a look.

Nic;o)
0
 
nico5038Commented:
Select the object in edit-mode and press properties.
Under the "Other" tab there should be specified behind "Auto activate": Double-Click

Nic;o)
0
 
AngeAuthor Commented:
I've selected the object, then from the Edit menu, Document Object and Edit. All that's happened is the document is highlighted on the form. There was no properties option or 'Other' tab. So now I'm stuck again! Please help :-)



0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
nico5038Commented:
1) Select the form on the database window and press the "Design" button.
2) On the form single-click the OLE oject (squares appear to indicate it's selected)
3) Press button on top with hand and white sheet ("Properties")
This will show the tabs!

Nic;o)
0
 
AngeAuthor Commented:
Nico,
Have done this and the Auto Activate property is already set at Double Click.
?
0
 
AngeAuthor Commented:
Nico,
I'd need to do more than compact the dB in order to send it to you, I'd have to strip out the data (business sensitive)  & I haven't got time. My users can inport the objects they need to OK, it seems only tobe  me that's got the problem so I'm going to park it for now.

Thanks for trying and please have the points with my complements!!!

Cheers

Ange
0
 
nico5038Commented:
Thanks, just drop a comment here when taking the task up again !

Nic;o)
0
All Courses

From novice to tech pro — start learning today.