Diaplying HTML

[Alex]

I need to display html info on an Access form. To do this I am using
the Micorsoft Web Browser control which uses shdocvw.dll

The problem with this is that

a. the control is not resizable. Once it has been position on the form
it cannot be resized and needs to be deleted and then reinserted. but
more importantly if the user resizes a form the control cannot be
resized accordingly

b. there is no way of printing the contents of the html on a report

Does anyone know of an alternative compenent (dll or ocx) that I could
use to solve either of these issues.
Alex

[Lyle Fairfield]

Alex wrote:

I need to display html info on an Access form. To do this I am using
the Micorsoft Web Browser control which uses shdocvw.dll

The problem with this is that

a. the control is not resizable. Once it has been position on the form
it cannot be resized and needs to be deleted and then reinserted. but
more importantly if the user resizes a form the control cannot be
resized accordingly

b. there is no way of printing the contents of the html on a report

Does anyone know of an alternative compenent (dll or ocx) that I could
use to solve either of these issues.
Alex

I resize as:

Private Sub Form_Open(Cancel As Integer)
Me.wbHDSBHelp.Width = 480
End Sub

where wbHDSBHelp points to the Web Browser Control.

I'm not sure what you mean by "no way of printing the contents of the
html on a report" ... but you can print the html on the browser control
by right clicking and choosing print from the pop up menu.

I expect that with a little dickering one could grab the innerText or
innerHTML of the control and do whatever you wanted with it.

For any report you need a record source, ... or you can manipulate the
various methods of the report or even, in later versions of Access, its
recordset ... these last two do not seem to be extensively documented
and they can be tedious.

--
--
Lyle
--
From ADO28.chm

Deprecated Components
Each of the following components is considered obsolete. While these
components are still supported in this release of the Microsoft® Data
Access Components (MDAC), they may be removed in the future. When
writing new applications, you should avoid using these deprecated
components. When modifying existing applications, you are strongly
encouraged to remove any dependency on these components.

ODBC Provider (MSDASQL)
You are strongly encouraged to use one of the native OLE DB Providers
instead of the Microsoft Open Database Connectivity (ODBC) Provider.
Native OLE DB Providers provide better application stability and
performance. Furthermore, native OLE DB Providers will be supported in
the future, whereas MSDASQL will not have any new features added to it,
will not be available on 64-bit, and will not be accessible from the OLE
DB NET Data Provider.

Remote Data Services (RDS)
Remote Data Services (RDS) is a proprietary Microsoft mechanism for
accessing remote data across the Internet or intranet. Microsoft is now
shipping the Microsoft Simple Object Access Protocol (SOAP) Toolkit 2.0
that enables you to access remote data using an open, XML-based
standard. Given the availability of the SOAP Toolkit 2.0, you should
migrate from RDS to SOAP. The SOAP 2.0 Toolkit 2.0 also includes sample
code for remotely accessing Microsoft ActiveX® Data Objects (ADO)
Recordsets.

Jet and Replication Objects (JRO)
The Microsoft Jet OLE DB Provider and other related components were
removed from MDAC 2.6. Microsoft has deprecated the Microsoft Jet
Engine, and plans no new releases or service packs for this component.
As a result, the Jet and Replication Objects (JRO) is being deprecated
in this release and will not be available in any future MDAC releases.

.....

[Tom van Stiphout]

On 23 Feb 2005 05:17:33 -0800, al********@hotmail.com (Alex) wrote:

Be grateful that it works at all.

You could automate a browser window, but of course not inside a form.

-Tom.

I need to display html info on an Access form. To do this I am using
the Micorsoft Web Browser control which uses shdocvw.dll

The problem with this is that

a. the control is not resizable. Once it has been position on the form
it cannot be resized and needs to be deleted and then reinserted. but
more importantly if the user resizes a form the control cannot be
resized accordingly

b. there is no way of printing the contents of the html on a report

Does anyone know of an alternative compenent (dll or ocx) that I could
use to solve either of these issues.
Alex

[Paradigm]

The resize code does not work. The browser control stays at the size it was
inserted on the form. Have you tried it?

The printing issue relates to printing the html info on a report that also
contains other info. i.e. not just the html
Alex

"Lyle Fairfield" <ly******@yahoo.ca> wrote in message
news:%L*******************@read2.cgocable.net...

Alex wrote:

I need to display html info on an Access form. To do this I am using
the Micorsoft Web Browser control which uses shdocvw.dll

The problem with this is that

a. the control is not resizable. Once it has been position on the form
it cannot be resized and needs to be deleted and then reinserted. but
more importantly if the user resizes a form the control cannot be
resized accordingly

b. there is no way of printing the contents of the html on a report

Does anyone know of an alternative compenent (dll or ocx) that I could
use to solve either of these issues.
Alex

I resize as:

Private Sub Form_Open(Cancel As Integer)
Me.wbHDSBHelp.Width = 480
End Sub

where wbHDSBHelp points to the Web Browser Control.

I'm not sure what you mean by "no way of printing the contents of the
html on a report" ... but you can print the html on the browser control
by right clicking and choosing print from the pop up menu.

I expect that with a little dickering one could grab the innerText or
innerHTML of the control and do whatever you wanted with it.

For any report you need a record source, ... or you can manipulate the
various methods of the report or even, in later versions of Access, its
recordset ... these last two do not seem to be extensively documented
and they can be tedious.

--
--
Lyle
--
From ADO28.chm

Deprecated Components
Each of the following components is considered obsolete. While these
components are still supported in this release of the Microsoft® Data
Access Components (MDAC), they may be removed in the future. When
writing new applications, you should avoid using these deprecated
components. When modifying existing applications, you are strongly
encouraged to remove any dependency on these components.

ODBC Provider (MSDASQL)
You are strongly encouraged to use one of the native OLE DB Providers
instead of the Microsoft Open Database Connectivity (ODBC) Provider.
Native OLE DB Providers provide better application stability and
performance. Furthermore, native OLE DB Providers will be supported in
the future, whereas MSDASQL will not have any new features added to it,
will not be available on 64-bit, and will not be accessible from the OLE
DB NET Data Provider.

Remote Data Services (RDS)
Remote Data Services (RDS) is a proprietary Microsoft mechanism for
accessing remote data across the Internet or intranet. Microsoft is now
shipping the Microsoft Simple Object Access Protocol (SOAP) Toolkit 2.0
that enables you to access remote data using an open, XML-based
standard. Given the availability of the SOAP Toolkit 2.0, you should
migrate from RDS to SOAP. The SOAP 2.0 Toolkit 2.0 also includes sample
code for remotely accessing Microsoft ActiveX® Data Objects (ADO)
Recordsets.

Jet and Replication Objects (JRO)
The Microsoft Jet OLE DB Provider and other related components were
removed from MDAC 2.6. Microsoft has deprecated the Microsoft Jet
Engine, and plans no new releases or service packs for this component.
As a result, the Jet and Replication Objects (JRO) is being deprecated
in this release and will not be available in any future MDAC releases.

....

[Stephen Lebans]

You cannot use the WebBrowser control on a report. I have not seen any
other HTML compatible ActiveX control that will work on an Access
Report.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Paradigm" <al********@hotmail.com> wrote in message
news:Bc*************@newsfe1-gui.ntli.net...

The resize code does not work. The browser control stays at the size it was inserted on the form. Have you tried it?

The printing issue relates to printing the html info on a report that also contains other info. i.e. not just the html
Alex

"Lyle Fairfield" <ly******@yahoo.ca> wrote in message
news:%L*******************@read2.cgocable.net...

Alex wrote:

I need to display html info on an Access form. To do this I am using the Micorsoft Web Browser control which uses shdocvw.dll

The problem with this is that

a. the control is not resizable. Once it has been position on the form it cannot be resized and needs to be deleted and then reinserted. but more importantly if the user resizes a form the control cannot be
resized accordingly

b. there is no way of printing the contents of the html on a report
Does anyone know of an alternative compenent (dll or ocx) that I could use to solve either of these issues.
Alex

I resize as:

Private Sub Form_Open(Cancel As Integer)
Me.wbHDSBHelp.Width = 480
End Sub

where wbHDSBHelp points to the Web Browser Control.

I'm not sure what you mean by "no way of printing the contents of the html on a report" ... but you can print the html on the browser control by right clicking and choosing print from the pop up menu.

I expect that with a little dickering one could grab the innerText or innerHTML of the control and do whatever you wanted with it.

For any report you need a record source, ... or you can manipulate the various methods of the report or even, in later versions of Access, its recordset ... these last two do not seem to be extensively documented and they can be tedious.

--
--
Lyle
--
From ADO28.chm

Deprecated Components
Each of the following components is considered obsolete. While these
components are still supported in this release of the Microsoft® Data Access Components (MDAC), they may be removed in the future. When
writing new applications, you should avoid using these deprecated
components. When modifying existing applications, you are strongly
encouraged to remove any dependency on these components.

ODBC Provider (MSDASQL)
You are strongly encouraged to use one of the native OLE DB Providers instead of the Microsoft Open Database Connectivity (ODBC) Provider.
Native OLE DB Providers provide better application stability and
performance. Furthermore, native OLE DB Providers will be supported in the future, whereas MSDASQL will not have any new features added to it, will not be available on 64-bit, and will not be accessible from the OLE DB NET Data Provider.

Remote Data Services (RDS)
Remote Data Services (RDS) is a proprietary Microsoft mechanism for
accessing remote data across the Internet or intranet. Microsoft is now shipping the Microsoft Simple Object Access Protocol (SOAP) Toolkit 2.0 that enables you to access remote data using an open, XML-based
standard. Given the availability of the SOAP Toolkit 2.0, you should
migrate from RDS to SOAP. The SOAP 2.0 Toolkit 2.0 also includes sample code for remotely accessing Microsoft ActiveX® Data Objects (ADO)
Recordsets.

Jet and Replication Objects (JRO)
The Microsoft Jet OLE DB Provider and other related components were
removed from MDAC 2.6. Microsoft has deprecated the Microsoft Jet
Engine, and plans no new releases or service packs for this component. As a result, the Jet and Replication Objects (JRO) is being deprecated in this release and will not be available in any future MDAC releases.
....