-
September 8th, 2008, 04:19 PM #1Banned
- Join Date
- May 2004
- Location
- Fort Walton Beach
- Posts
- 647
Code for VBA 2003 for viewing an OLE that resides in a Table Cell
Here is my problem:
I am using Access and VBA 2003. I have been successful using hyperlinks to a document's original location on our O:\ drive to display it when I click a button on a Form but want to try the embedded method instead. (i.e. OLE)
I have some Word documents with which I have associated Names. I have listed these Names and embedded the documents into 2 columns in an Access Table. The Access Form has a field that displays the Name for a given embedded document. I want to be able to click on the Button for the Name Field on the Access Form and have it display the Word Doc by reading the location as the cell containing the embedded doc in the Table.
I know that sounds confusing. Forget the "why I want to do this". It is someone else's project and I am just helping him figure it out. I say just hyperlink it but, whatever.
Is there code that can let you, basically, open what is in a Table cell? I know the DoCmd.OpenForm "SomeForm" and I know DoCmd.OpenTable "SomeTable" but I essentially need equivalent code for DoCmd.OpenCell "SomeCell".
Anyone?
-
September 8th, 2008, 10:16 PM #2Junior Member
- Join Date
- Sep 2008
- Posts
- 18
So you're trying to grab data from table on an Access database?
-
September 9th, 2008, 09:38 AM #3Banned
- Join Date
- May 2004
- Location
- Fort Walton Beach
- Posts
- 647
The documents are embedded in a table on an Access DB. Which document I need to see depends on what is in the Names field on the Access Form.
I compare the displayed name from the form to the name in the table and then I want to select and open the document that is associated with it.
???
-
September 18th, 2008, 03:40 PM #4Banned
- Join Date
- May 2004
- Location
- Fort Walton Beach
- Posts
- 647
Nevermind.....it can't be done that way. The solution was to embed all the documents into a Form instead of a table. The file size ends up to be ginormous but, whatever.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
VBA code to run an Excel Query
By bwolive in forum Applications and Operating SystemsReplies: 0Last Post: March 30th, 2005, 04:18 PM -
Excel "Undo" in VBA code??
By jjst34 in forum Applications and Operating SystemsReplies: 2Last Post: November 26th, 2003, 09:14 AM -
Table borders are killin me, image and code inside....
By Master Chief in forum Webmastering and ProgrammingReplies: 8Last Post: July 11th, 2003, 02:34 PM -
Email VBA Code
By jaypatel in forum Webmastering and ProgrammingReplies: 2Last Post: February 8th, 2003, 08:25 PM -
VBA viewing code for navigation button generated by wizard
By Turnip12 in forum Webmastering and ProgrammingReplies: 3Last Post: November 28th, 2002, 03:40 PM



LinkBack URL
About LinkBacks



Reply With Quote

I used to get some bad connection ALL the time. Turns out the problem was because I had a Netgear router and a D-LINK USB stick. I bought a D-LINK router and it works fantastic. Netgear sucks.
signal enhancer?