Search results for query: *

I need to do the same thing, but with a PDF as the OLE. Did you have any luck finding a solution??

You might try this method if you are still looking, Create form Create control that references OLE object, obj Create an event procedure for form_open that contains the following obj.action = acOLEActivate Have your code open the form to the record containing the pdf you wish to view, and it...

I have several text boxes set to CanGrow/CanShrink in a report. I want to be able to resize all text boxes at runtime to be the same size as the largest text box. Any ideas on how to accomplish

RickSpr, I would be interested in your procedure for manually securing a database.

Thanks for the idea, unfortunately it did not seem to work. Still got a "could not find file" error. If I give the shell the directory path the a separate PDF file, F:\Temp\Test.PDF, the program launches and displays the PDF just fine. If I use a double click or VBA oleActivate...

I use a db that has a number of PDF files stored as OLE. I can launch the Adobe Reader by double clicking on the control in form view, but would like to be able to launch using VB. I can get Adobe to launch using the "Shell" command, but have not been able to specify which PDf I want...

Thanks

I have a Access database that stores PDF documents by name. This database serves as the recordsource for a table on an ASP. I would like to launch the Adobe reader by selecting the record name from the ASP table. Anyone have a good method for accomplishing?

I have not yet resolved the questions of how to control the window size of launched applications. Kicker

Your use of the timer event to close forms sounds useful. Any chance of sharing some of the code to those of us who are trying to learn more techniques.

You may be able to launch the OLE by using the following, [objectname].action = acOLEActivate I have used this for embedded objects, but not Word documents. Good luck

I would like to be able to control the size of an application window that is launched from Access. Specifically, I am viewing PDF documents attached as OLE in my database using the acOLEActivate command. The Adobe window opens up as reduced. I would like to be able to maximize the Adobe...

Depending upon your final objective, you may be able to accomplish your goal by using VBA to, 1. Create a copy of the original table 2. Create a new column in the copied table 3. Add numbers to the new column that reflect your desired sort order, ie. for every...

I would like to know how to control item (command button) colors from VBA. I can do it using the GetSysColors/SetSysColors route, but lose control if the user clicks out of the application. I would prefer to do it using code that is confined to the app itself. Any ideas