473,509 Members | 4,901 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Showing web page in database form

Hi Gurus,

I want to incorporate a current web page on my database. How can I
include the output from a web page in my database?

Thanks in advance,
Jake

May 6 '06 #1
5 1474
jake_allen_no_spam wrote:
Hi Gurus,

I want to incorporate a current web page on my database. How can I
include the output from a web page in my database?

Thanks in advance,
Jake

What do you want to do? I didn't know Access displays HTLM in text fields.

A couple of options.

You can save the link to a hyperlink field. That will work.

Save the page to a file. Store the filename to a field in the table and
hyperlink to it.
May 6 '06 #2
You can put a webbrowser control on form.

Try the following, this is a fairly lengthy list as I've tried to be
exhaustive.

Create a blank form
Go to the insert menu and select ActiveX Control
Search in the list for Microsoft Web Browser and select it.
A Webbrowser control (WebBrowser 0) appears on the form
Position and size the control
Cut the control to the clipboard (Select it and press Ctrl-X on the
keyboard)
Paste the control from the clipboard (Pres Ctrl-V on the keyboard)
Position the control.
Place a textbox (Text1) at the top
Place a command button (Command3) at the top
Open the properties for Command 3 and choose the Event tab
In the Click event enter [Event Procedure] and pres Ctrl-F2 on the keyboard.
In the code window put the following code

Private Sub Command3_Click()
Dim wb As SHDocVw.WebBrowser_V1

Set wb = Me.WebBrowser0.Object

With wb
.Navigate Me.Text1
End With
Set wb = Nothing
End Sub

Save the form
Switch the form to form view
Enter a valid URL in the text box and click on the command button.

--

Terry Kreft
"jake_allen_no_spam" <ja**********@hotmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Hi Gurus,

I want to incorporate a current web page on my database. How can I
include the output from a web page in my database?

Thanks in advance,
Jake

May 7 '06 #3
A Hack (not extensively tested)

1. Create a DAP. You don't have to do anything with this DAP except
name it, if you wish. Save it.
2. Close Access.
3. Edit the DAP file (in my case, "Page1.htm") with NotePad or your
favourite htm editor.
4. Select and Replace all the html, script, ms baggage etc in the DAP
and replace it with:

<html>
<head>
<title>
A DAP Hack
</title>
</head>
<body>
<iframe src="http://www.microsoft.com" style="height:100%;width:100%">
</iframe>
</body>
</html>

5. Save the edited DAP.
6. Reopen Access.
7. Open the DAP.

May 7 '06 #4

"Lyle Fairfield" <ly***********@aim.com> schreef in bericht news:11**********************@e56g2000cwe.googlegr oups.com...
A Hack (not extensively tested)

1. Create a DAP. You don't have to do anything with this DAP except
name it, if you wish. Save it.
2. Close Access.
3. Edit the DAP file (in my case, "Page1.htm") with NotePad or your
favourite htm editor.
4. Select and Replace all the html, script, ms baggage etc in the DAP
and replace it with:

<html>
<head>
<title>
A DAP Hack
</title>
</head>
<body>
<iframe src="http://www.microsoft.com" style="height:100%;width:100%">
</iframe>
</body>
</html>

5. Save the edited DAP.
6. Reopen Access.
7. Open the DAP.


Hi Lyle.
Beautiful solution! also by it's simplicity!

BUT: This works with A2003 but NOT with A2k ...
I don't have A2k2 here so I don't know if it works with that version.

Arno R
May 7 '06 #5
"Arno R" <ar***********@tiscali.nl> wrote in
news:44**********************@text.nova.planet.nl:
BUT: This works with A2003 but NOT with A2k ...
I don't have A2k2 here so I don't know if it works with that version.


I tried it in Ac2k2 and it seemed OK. I don't have Ac2k any more so I can't
investigate the problems there.

--
Lyle Fairfield
May 7 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2894
by: Jack | last post by:
Hi, I have a asp input form of a financial report. Here most of the fields are text boxes where the user need to input the values corresponding to an item. However, there are few items which are...
3
2888
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...
1
840
by: Amber | last post by:
The DataGrid allows you to make columns visible or invisible on demand - even edit and other special columns. This article will show you how it is done. Some developers have reported problems...
4
2983
by: dac | last post by:
I am quietly going insane on this project. I've never worked on a project like this one before. All my previous sticky forms were for data entry, not editing. I don't know how to display the form...
7
2936
by: underground | last post by:
I have a problem that I've spent countless hours on and I'm more than certain this is a obviuos issue to an expert but I am still learning. I have a paging script that I have modified to display a...
5
2862
nmm32
by: nmm32 | last post by:
I have a DataGrid which displays data with the aid of a procedure. I have tested the procedure inside the database and it is working fine. I have another procedure which adds another row to the...
0
1763
by: cms3023 | last post by:
I have a DataGrid which displays data with the aid of a procedure. I have tested the procedure inside the database and it is working fine. The table inside the database has data that matches with...
0
1696
by: Iain | last post by:
Hi I am using Borland Developer 2006, C# web application. Fairly new to the .net platform and very new to repeaters. I have 2 repeaters on a page, both of which are filled from a database....
6
4171
by: painkiller | last post by:
language: vb.net environment: windows forms .net : v1.1 i am having a checkedlistbox control that display document category such as text, image, video, audio etc. these values are coming from...
0
7237
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7137
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7506
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5062
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3218
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3207
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1571
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
779
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
443
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.