Login to different websites from clicking access form button

[Db-why-not]

Hello,

I have an access database with Logins table and with fields: UserID, Password, WebAddress. I have a form (Auto_Logins) that displays these 3 text fields, and buttons to scroll through all the individual records in my Logins tables. Then I have a Login button that I want to trigger internet explorer to open, navigate to the webaddress and take my UserId and Password from the form that is displayed and then login to the website. Is this possible with VBA code in access? I have been having trouble finding code or information on how to do this. Thanks.

 

[theDBguy]

Yes, in some cases/websites, that is possible. You would have to know the Form structure of the website though, because you may have to use the names of the controls on the website for your code.

 

[Gasman]

Someone was wanting to exactly the same thing a while ago.?
Try searching the site with some relevant keywords.

Edit: This was the one I was thinking of

Inputting data into a webpage form automatically

Hi all I have a webpage form I need filling out once a button is pressed on the Access form, this then auto populates the information from the access form onto the webpage, at the minute I am using tab stops which is starting to get a little messy as I need to press multiple tabs to get to the...

www.access-programmers.co.uk

 

[Db-why-not]

Yes, in some cases/websites, that is possible. You would have to know the Form structure of the website though, because you may have to use the names of the controls on the website for your code.

So you probably wouldn't be able to do this for several different types of website. Each website can use different names for the userid and password controls?

 

[Gasman]

So you probably wouldn't be able to do this for several different types of website. Each website can use different names for the userid and password controls?

Just store anything you need to log in, in a table
Not sure how you would cope with different element names though? Eval() perhaps?

 

[Gasman]

This might help as well?

UtterAccess.com

www.utteraccess.com

 

[theDBguy]

So you probably wouldn't be able to do this for several different types of website. Each website can use different names for the userid and password controls?

The reason why it might or might not work depends on how the website was designed by the web developer. That's all.

 

[isladogs]

Are you aware that you could do all of this within Access by using a Web browser control

 

[Db-why-not]

Are you aware that you could do all of this within Access by using a Web browser control

I haven't used web browser controls before, thanks, I will have to look into that.

 

[Isaac]

Even if you use a webbrowser control, you will still essentially be automating I.E. object model. (I'm no expert on this, but have dabbled from time to time). I mean, my purpose for saying that is that much of the code will be belonging to the same object models, etc.

A few things that may be relevant:
- Look into GetElementByID for referencing a particular element in a website underlying structure. This is not the only method, but is common.
- In order to know what the ID actually is, right click on a webpage and View Source, or, if you're comfortable, use a browser that provides a more in depth way of slicing and dicing the structure, like Firefox.
- Remember that some webpage functionalities may be a simple call to a hidden Javascript or other function and everything you need may not always be exposed in the HTML that you can view as an end user.
- When it comes to submitting information, sometimes you can get away with just using Forms(1).Submit or Forms(0).submit, for simple pages that don't have anything other than that submittal form on them.

Here is a thread I was in recently that might help?
Automating a webpage inside a Webbrowser control
Note my Post 3 comments about the article I stumbled across, which I think is one of the most comprehensive and useful deep-dive into automatic web content inside Webbrowser controls that I'd ever seen.