I have an OLE field in a table (an excel worksheet.) I am looking for a way to automate selection of that field (based on other criteria (with a query??)and have it open in its native application. You can do this by double clicking on the field contents in the table but I need a way to select it and open it -- propbably with code. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open a Excel ws in its native application
- Thread starter RDS2
- Start date
I looked at this when you posted yesterday
Open OLE object in its native application
thread181-1264382
And decided I was not quite sure what you wanted. It may be best to post some code as it is often easier to understand what a person wants from that.
It is much better to bump a post that re-post in another Access forum, as re-posting in these cases is usually frowned upon.
Open OLE object in its native application
thread181-1264382
And decided I was not quite sure what you wanted. It may be best to post some code as it is often easier to understand what a person wants from that.
It is much better to bump a post that re-post in another Access forum, as re-posting in these cases is usually frowned upon.
- Thread starter
- #3
I have a table with an OLE object as the data type.
Incidentally the follwing code attached to a command button which executes on dblclk creates the original worksheet:
OLEBound25.Class = "Excel.Sheet"
OLEBound25.OLETypeAllowed = acOLEEither
OLEBound25.Action = acOLECreateEmbed
OLEBound25.Action = acOLEActivate
This works to create the worksheet and you can enter your data as you normally would. This is then saved in the aforementioned field in the table.
If you open the table and doubleclick the field contents Excel will load and you can edit the sheet with all the Excel formating tools.
What I'm looking for is a way, after the original save to that field, to let a user open the created worksheet in EXCEL by somehow selecting it.
Incidentally the follwing code attached to a command button which executes on dblclk creates the original worksheet:
OLEBound25.Class = "Excel.Sheet"
OLEBound25.OLETypeAllowed = acOLEEither
OLEBound25.Action = acOLECreateEmbed
OLEBound25.Action = acOLEActivate
This works to create the worksheet and you can enter your data as you normally would. This is then saved in the aforementioned field in the table.
If you open the table and doubleclick the field contents Excel will load and you can edit the sheet with all the Excel formating tools.
What I'm looking for is a way, after the original save to that field, to let a user open the created worksheet in EXCEL by somehow selecting it.
traingamer
Programmer
One way:
After creating the spreadsheet with the command button, you could update a label on your form with a hyperlink to the newly created spreadsheet.
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
After creating the spreadsheet with the command button, you could update a label on your form with a hyperlink to the newly created spreadsheet.
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question