[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Web Browser Control/Continuous Forms in Access 2000

Posted on 2006-06-12
3
Medium Priority
?
476 Views
Last Modified: 2008-02-26
Hello,

I have a Microsoft Access 2000 web form which needs to display images which are referenced by a fieldname in my table called URL. I've imbedded the Microsoft Web Browser activex control (calling it WebBrowser) and I've set the Form_Current() event as follows:

Private Sub Form_Current()
Me.WebBrowser.Navigate URL
End Sub

When the form's default view is "Single View", the form works perfectly. As I navigate to different records, the Form_Current event is fired and the WebBrowser control updates accordingly.

My Problem: when I set the form to "Continuous Forms", several detail records appear, but only the top one navigates to the URL. If I scroll down, the WebBrowser control is not refreshed.

Is there a way to have all the detail records WebBrowser controls navigate properly on startup and have them refresh when I scroll up/down?

TIA,
Bitwelder
0
Comment
Question by:bitwelder
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 500 total points
ID: 16889902
Hello bitwelder

In a nutshell: No.

To have different information displayed in different rows of a continuous form, you need to use bound information. If a control is unbound, it will have only one single instance, and although you will see it several times (once in each row), it wll always be the same control. Single WebBrowser, single display.

Sorry.

(°v°)
0
 

Author Comment

by:bitwelder
ID: 16896890
Thanks for the reply.

If anyone has any suggested workarounds, I would appreciate it!

Thanks,
Bitwelder
0
 
LVL 58

Expert Comment

by:harfang
ID: 16899359
Bitwelder

A workaround that works in a continuous form? That would be tough.

However, you can perhaps write a local HTML frame page and load your different URL's in each frame. This could be displayed in the WebBrowser object.

It will be quite hard to synchronize this with a continuous form next to it, though...

On the other hand, if this is a web form, you might be able to use other tricks. I'm not even sure you need a WebBrowser control. Can't you generate HTML tags dynamically on a web form?

(Sorry, no working experience with those...)

(°v°)
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question