[AccessD] View PDF in Unbound Object Control

Darren darren at activebilling.com.au
Wed Dec 12 15:32:07 CST 2012


Sample sent off-line
Darren


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
Sent: Wednesday, 12 December 2012 12:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] View PDF in Unbound Object Control

Darren, what is a browser control. Sorry, I am a little thick. And is this
control available to all Microsoft Office forms, like Excel userforms too?
It soulds great.

I have to generate some invoices / reports to someone from Excel and I would
really like to spin them out to PDFs then let them be viewable in PDF
through a browser all in one command button but and I am *pretty* sure I
will find the stuff I need on the web to figure this out, unfortunately I
have a deadline of tomorrow.

/:-{

On Mon, Dec 10, 2012 at 11:35 PM, Darren <darren at activebilling.com.au>wrote:

> Yep.
> Drop a browser control onto a form.
> Call it say...actXMyBrowser.
> view the PDF file in the browser with code like this...
> Me.actXMYBrowser.navigate "c:\SomeFolder\SomePDFFile.pdf"
>
> D
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert 
> Stewart
> Sent: Tuesday, 11 December 2012 8:02 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] View PDF in Unbound Object Control
>
> All,
>
> I really need some input on this.  If it is not possible, please let 
> me know.
>
> I think I can do it with a .Net project and view the document in a 
> browser window using the different MIME format stuff the browser makes
available.
>
> But, is using a browser control also the answer here?
>
>
> At 08:03 AM 12/7/2012, you wrote:
> >Date: Tue, 04 Dec 2012 11:01:47 -0600
> >From: Robert Stewart <rls at WeBeDb.com>
> >To: accessd at databaseadvisors.com
> >Subject: [AccessD] View PDF in Unbound Object Control
> >Message-ID: <9D9D5636-0C88-4FA5-B7D2-0A99F7480EE6 at holly.arvixe.com>
> >Content-Type: text/plain; charset="us-ascii"; format=flowed
> >
> >
> > >All,
> >
> >
> >I would like to be able to view different document types in the 
> >unbound object control.
> >I have a table that gives me the UNC path to the file.  I have the 
> >extension of the file as a separate field in the table where the UNC 
> >path is.  I have limited the query to only PDF files.  In this case, 
> >there are only 2.  I want to be able to preview them in the control 
> >and double click them to open them in a PDF reader.
> >
> >The problem is that the SourceDoc property is being changed, but not 
> >refreshed.
> >Well, not to the point that the document is display in the object
> container.
> >
> >Below is the code I am using:
> >
> >Private Sub Form_Current()
> >      Me.OLEUnbound4.SourceDoc = ""
> >      Me.OLEUnbound4.SourceDoc = Me.txtFullPath
> >      Me.txtSourceDoc = Me.OLEUnbound4.SourceDoc
> >      Me.OLEUnbound4.Requery
> >      Me.Refresh
> >      Me.Repaint
> >End Sub
> >
> >When I am on the first row, the value in SourceDoc is:
> >\\sithou-sqldev\ssis_working\PhotoSamples\Data_Mart_Extracts_Rpt.pdf
> >When I move to the second record, it is:
> >\\sithou-sqldev\ssis_working\PhotoSamples\RT-201208-18101-49113240.pd
> >f
> >
> >I am getting this from the third line of code where I get the value 
> >of SourceDoc and display it on the screen.
> >
> >I still see the first document in the object container and when i 
> >double-click on it, I get the first document.
> >
> >Any one have any ideas on how to make this work?
> >
> >
> >
> >
> >
> >Robert L. Stewart
>
> Robert L. Stewart
>
> Any fool can write code that a computer can understand. Good 
> programmers write code that humans can understand. --Martin Fowler
>
> www.WeBeDb.com
> www.DBGUIDesign.com
> www.RLStewartPhotography.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
*Regards,*
**
**
*Bill Benson*
*VBACreations*
**
PS:  You've gotten this e-mail *because you matter to me!*
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list