Dear everyone,

I just need to understand exactly what web browser contol is.

As far as I understand it can be used to automate web forms that are frequently used to enter the same information...is this correct? This is the main reason I would like to use it - for forms.

If it is what is required during design of the web page and also what is required by the user?

I imagine the designer needs to make the forms compatible with Visual Basic and the user needs to use visual basic to automate the forms - is this correct?

Can you also provide brief notes as to how I would go about getting the forms to work both in terms of how I should design the page and how I can begin to use VB to automate them...

...hope I explained myself reasonably enough to get my ideas forward and I look forward to your guiding comments,

internationally

[dexmix]

the web browser control merely displays/hosts a web page right on a form.
a web browser control doesnt automate anything, to do with forms.
technically the web page it displays could have an input form, and use dhtml to automate things on its own input form.

basically the web browser control is used to only display web pages.
if you really wanted to, you can add scripting to the displayed page, and even assign VB code respond to events from the browser control. Im still not sure what your looking.

I am looking to automate a form - I type in the same thing in the in put boxes frequently - so anything that enables me to automate or use a key board short cut to achieve would be very useful.

If you do not think Web Browser Control is most useful then can you suggest a different type of macro/VB process that will speed up the process of completing the form?

Internationally

[dexmix]

what are you using? VB or VBA in Access or Excel

I am using VB in Excel but I am prepared to learn new software to sort this issue with automating forms,

internationally

[dexmix]

I still dont get why this is a problem... if you keep the same form open, it shouldnt be a big deal, to keep the last entered values in the fields/textboxes even after you save the current record. If need be, you can keep the last entered values in a variable, or even a fixed cell on a fixed sheet if you must close the form

So how do I go about keeping "the last entered values in a variable, or even a fixed cell on a fixed sheet"? - to ensure the form is complete when opened?

[dexmix]

first of all, what are you trying to accomplish? If theres repetetive data entry, than your probably keeping records of some type, and you are better off using access instead of excel. If you would like, i can make a mockup database file, with a form that persists the last entered values.

If it is not too much trouble for you - then a mock up would be very useful.

Can you link the database to a form? A short explanation as to how that is done would be very useful

Thanks,

internationally