Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


fill forms automatically from MS Access

Posted on 2010-11-25
Medium Priority
Last Modified: 2012-05-10

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.

Question by:Victor Kimura
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 13

Expert Comment

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.

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,
LVL 13

Accepted Solution

gbanik earned 2000 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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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:

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,
LVL 13

Assisted Solution

gbanik earned 2000 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.

Author Closing Comment

by:Victor Kimura
ID: 34228482

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Suggested Courses

636 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