AutoFill SignIn&Passwords from Access records to IE

D

DaaAgent

Registered User.
Local time
Yesterday, 21:36
Joined
Dec 5, 2005
Messages
49
Hello everybody

We have a Suppliers table which contains fields
[SUPWEBID]
[SUPID]
[AccountNo] (Our AccountNo) [Acco...w a fed up wife I alas emit defeat Help!!!!!
 
Had a little play with this on a local file and seems to be the way to go.
Code: 
Dim i As Integer
Echo (False)
With Me.ctlBrowser
    .Navigate "H:\workbench\html\formTest.html"
    For i = 1 To 2
        DoEvents
    Next i
    .Document.getElementById("MyText").appendChild (.Document.createTextNode(" This text was added to the TextBox."))
End With
Echo (True)
the do events are needed to give the form a chance to load before writing to it, you may need more loops working on the internet.

Peter
 
a neater line
.Document.getElementById("MyText").Value = " This text was added to the TextBox."
 
Hello Peter

Sorry Peter what a TUBE I am, didn’t even subscribe to my own post

Will have a look tonight

I hope you don’t think bad of me. I think its very rude when posters don’t do a end reply and just take the help and run

Speak to you soon

Stewart
 
Evening Peter

Surprise Surprise stupid me couldn’t get your code to work with my test db

After you helped me on my last post I have tried to think a bit more logically

I think there will be 4 main Cases I will have to get over (dare I say we)

Issue 1 Just a URL no AccountNo
Some of our Suppliers have multiple sites that may or may not require sign-in details
If the selected URL has no AccountNo just load the URL

Issue 2 URL AccountNo & Password no UserInitials
One the girls kindly went through the suppliers list today and it appears 70% of the suppliers Sites require User Initials. So hopefully to get round the issue I added a Yes/No field [EmployeeRefReq] and the records have been all updated

Issue 3 URL AccountNo & Password & User Initials
Since my original post I found out about adding the browser control to a frm so rather than using the FollowHyperlink command I now have a frm that contains the browser along with a lot of additional fields 1 of them being a required field [DoneBy] which holds the Employees Initials. Also added and updated was a UserNameLabel like before to store the term used by the supplier

Issue 4 Input Order of AccountNo & Password & User Initials
Not all website follow the input pattern of AccountNo + Password + UserInitials some use UserInitials + AccountNo + Password and all the other combinations in between. Unfortunately I was a wee bit pushed for time and said person from issue 2 was about to lose their will to live after having to update the table so many times. So I punted for a text field named [Order] where the first letter in each appropriate field has been inserted followed by a coma then a space. so to clarify if the order is Account + Password + Employee then it has been inserted as A, P, E,

Taking all of the Cases into account I made up a wee test db PasswordsBrowser.mdb I have removed the Suppliers & Passwords data, I am sure you have some you could use for your own testing

Any question just fire away, has I have now subscribed to my own post!!!!


Stewart
 

Attachments

Last edited:
You must log in or register to reply here.

Similar threads

Isaac
Chrome setting to fix this? (don't autofill passwords outside signed-in Chrome)
Replies
14
Views
2,803
Isaac
Isaac
Papa_Bear1
How do I allow a new record to be created (by button push) on a form, while requiring the user change one value from its default?
Replies
16
Views
1,013
Pat Hartman
P
monheimx9
Solved Dynamics365 connector for Access is broken (Dataverse as well)
Replies
12
Views
1,751
isladogs
isladogs
S
How to get match user’s input password from the records
Replies
2
Views
641
SachAccess
S
Z
Record value from 3rd open form to table bound to 1st form
2 3
Replies
55
Views
2,345
Zydeceltico
Z

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom