Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 8th, 2004, 08:40 PM
Registered User
Join Date: Aug 2003
Location: , , United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data in Word forms in Access Tables

Hi All,

I am looking for some example code from someone who has done this kind of thing before using Office 2002 apps.

Basically I want to create a form in Word that has inserted data fields (can do that)which can be emailed to users to fill in information. The fields could be numeric, date or text.

Completed form then emailed back to me.

Then want some code to take info. entered in the word form and transfer this to table in access

Not sure whether the best approach is to associate the VBA "transfer" code with the access database or with a "Save Button" macro on the Word form (ie push or pull the information across?)

If anyone has some code snipetts they can post to give me a start that would be great

Reply With Quote
  #2 (permalink)  
Old January 9th, 2004, 09:18 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

As far as whether you want to push the data out of Word or pull the data from Access, it depends on the relability of your staff. Consider this... the Word document is going to go out to all staff. The locations of each copy of the document will be in countless directories on a large number of machines.

If Access is to pull the data, it will have to know where to pull from. If that's the case, all staff will have to place their final copy of the Word document on a shared drive so that Access will know where to look for it. You will have to rely on staff to remember to do that when they're ready.

If you make Word push the data, I'm assuming the one and only Access database resides in one place. Therefore each Word macro will be pushing to the same place. It doesn't matter where the Word document is pushing from. This make it easier. You will have to rely on staff to remember to push the data.

Either way, you must get staff to remember to do a final action. To me, the easiest is to get staff to push a button rather than to copy a file to some directory. Therefore, my vote is to have Word push the data because it's easier to have Word documents located everywhere push to one spot.

For code snippets, I have code from a Word macro that pulls from Access but not that pushes to it. Still interested? If so, send me a private message with your e-mail address.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word tables to access hayk_yer Access VBA 1 June 26th, 2007 10:49 AM
Forms and tables in Access 2003 marclf Access VBA 2 October 24th, 2006 07:10 AM
how do i convert ms word doc to access tables??? carswelljr Javascript How-To 1 August 28th, 2006 03:44 AM
Word E-Mail Merge using Access Tables Richard Lally Access 2 February 7th, 2005 04:48 AM
word data to access treasacrowe Access 1 October 22nd, 2004 03:55 PM

All times are GMT -4. The time now is 05:52 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.