By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Showing web page in database form

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a

"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

P: n/a
"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 discussion thread is closed

Replies have been disabled for this discussion.