By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

How do I populate a Word form with info from Acces?

P: 1
I have a database that nees to print using standard forms. I've created the forms via Word but cannot figure out how to populate the forms with the info in Access.
May 11 '10 #1
Share this Question
Share on Google+
2 Replies


Jerry Maiapu
100+
P: 259
You need to create tables to store the info in access. and using these tables you'll create the forms so that the form pick the infos from the tables.

You can also select certain info (termed records in access) from the table using query and display those in the form..

That is how Access forms are created and and I have never seen a word form converted to access forms impossible as far as I am concern..

You supply/export formated info (called Report in Access) from access to MS Word but Word and Access cannot work side by side as Word is not databse oriented..

JM
May 11 '10 #2

Jim Doherty
Expert 100+
P: 897
@Tiny563
Tiny563

I see you are new and I suspect you are also new to Access so welcome to Bytes.

What you should consider is this:-

Where are you more comfortable working mostly? in Access? or in Word.

1) If you merely want to extract data from an Access table or query to Word then consider mail merge FROM Word. It is completely capable of doing that and can create fillin fields you define in the mail merging process. You do need to learn that mechanism and will be working essentially in Word on the Word side.

2) If the forms you have already created are not immensely complex documents having all the sophisticated formatting facilities available in Word then you could consider recreating your forms as REPORTS in Access but it really depends on your needs on this

3) If you need to interact with 'Word' from the 'Access' side where data is passed to 'Word' to populate sections of a document then this is where 'Office Automation' comes into it. This is an advanced level of Access useage where one technique enables interaction by passing data to areas of your document you have defined as 'bookmarks' within word

Access and Word can interact with one another perfectly however, the level of success you achieve depends largely on your skill level with VBA language
May 12 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.