ptw78,
Part of your issue may be incorrect element id's if you're still struggling with it. I found this code http://www.tek-tips.com/faqs.cfm?fid=6399 invaluable. Just copy the code into an excel document's vba and go to the developer tab (if running 07) and hit macros and assuming you have...
JoeAtWork,
I've thanked you for your posts on here and wanted to say your help was invaluable. I have read about concatenating but I had completely forgot about it. With some minor adjustments with the formatting I was able to finish this aspect of my database and learned some invaluable...
JoeAtWork, I appreciate the quick response! It definitely gave me some more ideas as it didn't work 100% and since I'm new to VBA (halfway through the dummies book right now for vba for access)and while some of it is coming to me pretty fast, I still struggle with things I've never dealt with...
I may be on to something but still need help.
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM tblCE_QBTest", CurrentProject.Connection, adOpenForwardOnly, _
adLockReadOnly, adCmdText
Do While i < 50 And Not rs.EOF
For j = 0 To rs.Fields.count - 1
Debug.Print...
Instead of completely hijacking another thread I figured I'd start my own.
I have a database (access 2007) that tracks training information for my site and to expedite some of the processes we have to follow I've incorporated IE automation in my db. The website I'm connecting to is a third...
ptw78, Did you ever get a response to this? I too am trying to take data from an access table and via vba and Microsoft Internet Controls/Microsoft HTML Object Library trying to paste into a text box on a website I do not have full control over and am trying to avoid the use of sendkeys or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.