asked on

fill forms automatically from MS Access

Hi,

I'm wondering if it's possible to create some small program that will automatically fill out forms online with MS Access using VB. Basically, I'd like something like formautofill.com but updating the data from a table rather than a csv file. If I can select the record and the table that would be great. If it's possible then are there any tutorials on how to do this? I'm a newbie at VB.

Thanks,
Victor

gbanik

Are you looking for an autofill application for a "specific" website? If yes, it is doable. If no, then u are better off using some available application... it would be too much of an effort.

Victor Kimura

ASKER

Well, I have a few sites but I'd like to see something that will fill out forms like, for instance, ezinearticles.com. I submit a lot of articles to various article directories. If I have a sample I can modify them to different sites. Do you have anything I can use to get me started? I would really appreciated it. I'd like to learn vb as well. I've done minor things in excel but not so much in access.

Thank you,
Victor

ASKER CERTIFIED SOLUTION

gbanik

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Victor Kimura

ASKER

Hi ganik,

Thanks for the script. I ran the script and it seems to work well. But I can't see the code. I see this:
http://tutorialref.com/images/excel-lookup.png

When I try and click on lookup.xlam then it asks for a password. I don't really know what it's retrieving and it would be nice to look at the code so I can try and use for the forms I'm trying to submit to with my own data. May I view the code? I'd also like to use it as a learning experience too. =)

Much thanks,
Victor

SOLUTION

gbanik

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Victor Kimura

ASKER

Thanks.