473,414 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

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

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
2 5549
Jerry Maiapu
259 100+
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
897 Expert 512MB
@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

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

Similar topics

1
by: Stephen Witter | last post by:
I have textboxes in a word docment that I would like to populate via an asp.net page. Is this possible? The reason I ask is right now I am using a macro in word and I don't want to have to use...
9
by: starbuck | last post by:
Hi, have a form, with a text input "fieldname". method POST $var = $_POST $var is then used to search in mysql select * from table where jobtype like '$var%'
3
by: intl04 | last post by:
Is it possible to create a Word form as the data entry form for an Access database? I didn't see any reference to this possibility in my Access books, so I'm sorry if this is a question that is...
1
by: John Phelan-Cummings | last post by:
I'm not certain if this made the post. Sorry if it's a repeat: Using a Button to take an autonumber from one form to populate another autonumber field on another form. I have a Mainform "A"...
4
by: Kera | last post by:
Hi, I am working with a template document that has previously been created. I want to be able to populate the fields on the Userform on opening the Word template but before the form is shown. I...
1
by: Daveo | last post by:
Hi there, I have a query that returns a lost of names given certain criteria. The list of names changes as the criteria is changed. I would like to export this list to a Word form table, with a...
5
by: Richard Rosser | last post by:
Greetings. I know not one word of Javascript and wondered if there was an easy way to pre-populate a form field in a similar manner to populating an eMail 'subject' field? - The following...
3
by: wparrott | last post by:
Hello everyone, I'm trying add a print button that opens a Word document and fills in form fields in the document based on the currently displayed record. The code works in a sample that I ran but...
3
by: RamanS | last post by:
Hi, I am trying to populate a form textbox1 using a sql query. The query takes the "where" parameters from another textbox2 located on the form. Please see the syntax below. When i try to run...
13
by: BrokenMachine | last post by:
Hi there, I'm using Access 2003 and Word 2003 and I'm trying to import data from the word form to multiple access tables in a one to many relationship, but I can't seem to figure it out. I have...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.