Google Community
Latest Forums Rules Resources
Custom Search

Go Back   Google Community > Webmaster Forums > Web Design, Coding & Programming Forum

GoogleCommunity Sponsor

Reply
 
LinkBack Thread Tools Display Modes
Old 04-19-2009, 12:43 PM   #1 (permalink)
Noogle
 
Join Date: Apr 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
ajetrumpet is on a distinguished road
navigating websites through VBA

here is a snippet of my code behind an access form i have:
Code:
 
set ie = createobject("internetexplorer.application")
 
ie.navigate me.website
 
while ie.busy
do events
wend
 
ie.document.forms(me.formnumber).item("username") = me.username
ie.document.forms(me.formnumber).item("password") = me.password
ie.document.forms(me.formnumber).submit
as some may have guessed, i'm trying to automate a login from my database. the problem is, when i click the button on my form to run the ENTIRE code (which is obviously not all here, but it does work), sometimes it is successful and sometimes it is not.

as in, sometimes, i get some of the populations in the textboxes, and sometimes not. when i created a loop to go back through and check for errors in my code, sometimes it bugs at:
Code:
 
ie.document.forms(me.formnumber).item("username") = me.username
with the error of "object variable not set". This cannot be the case, as they are all set in the code. These errors are completely random, as to say that I can run this code 5 times and open up 5 different explorer windows, and the code may be successful the first, last or any other time in between. and I am not sure of the reason why this randomly debugs on ANY of the "populating" lines of code.
Code:
 
(e.g. - website textbox = one of my variables)
Anyone have any ideas on this?
ajetrumpet is offline   Reply With Quote
 
Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Similar Threads
Thread Thread Starter Forum Replies Last Post
BEST WEBSITEs Ahsan1231 Site Reviews & Suggestions Forum 1 05-08-2009 01:06 PM
List of websites which ranks the websites nitheshmelur Introduce Yourself 0 12-22-2008 10:26 PM
Garmin(R) Simplifies Searching, Sending and Navigating to ... - FOXBusiness News Alerts Google in the News 0 03-31-2008 12:34 PM
More Websites escante Web Browsers and Statistics 3 10-01-2006 11:41 AM


All times are GMT -8. The time now is 01:18 AM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© 2004–2007 Google Community