Solved

fill forms automatically from MS Access

Posted on 2010-11-25
6
399 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Victor Kimura
  • 3
  • 3
6 Comments
 
LVL 13

Expert Comment

by:gbanik
ID: 34215640
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.
0
 

Author Comment

by:Victor Kimura
ID: 34216692
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
0
 
LVL 13

Accepted Solution

by:
gbanik earned 500 total points
ID: 34217191
Here is a sample I had created for someone else. This code connects to a website, fills some forms and collects the results. This maybe the direction you want.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26575800.html#a34013763
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:Victor Kimura
ID: 34227725
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
0
 
LVL 13

Assisted Solution

by:gbanik
gbanik earned 500 total points
ID: 34228408
The complete code is written inside the Form. Please open the form and see the code.

The lookup.xlam is NOT a part of this project but an addin that you may have installed on your machine. I am ignoring that for my post.

Right click on the form and "View Code".

Hope it resolves your query.
0
 

Author Closing Comment

by:Victor Kimura
ID: 34228482
Thanks.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now