[mso] Re: Access 2002: Relative Table Links?
- From: Cathy.Evans@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 17 Aug 2004 16:58:02 -0400
Thanks, Ray, here's a couple more links, for what they're worth:
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
http://www.4guysfromrolla.com/webtech/063099-1.shtml
I found some Word sample templates today (can you tell I have been
googling!) and one opened up a form, I filled in the information, then it
sent it to appropriate spots in document. Finally found how to get to the
actual form design, but it's really different than Access, in that when you
select a tool from the menu and drop it on the form, then what???!!!
Access guides you through a wizard so you can figure it out! :)
Anyway, I also found the code in there and hope to try to make some sense
of it, so any help you can provide will be great. Hopefully this will tell
you where I'm at in Word form design (nowhere!). I don't mind taking this
template I found and once I figure out how to rename these data boxes to
something meaningful for the user and put the data back into the form (in
more than one place, if needed), then I can transpose all that to my
contract document. Is that how the custom properties will work - a pop up
form opens first that the user fills out? Also found a sample template
with same pop up box idea that used fields, so hoping the custom properties
will do the same.
Am greatly looking forward to any help you can send my way, thank you so
much for taking the time, Cathy
"Ray Blake"
<ray@xxxxxxxxx> To: <mso@xxxxxxxxxxxxx>
Sent by:
mso-bounce@freelist cc:
s.org
08/17/2004 03:38 PM Subject: [mso] Re: Access 2002:
Relative Table Links?
Please respond to
mso
.....
Thanks, Cathy. I really appreciate you taking the time to link to those
sources (as it were!) and will spend some time there researching it
tomorrow. The custom properties thing takes a little setting up but it's
pretty robust. I'll try and dig out some code on it.
Ray
------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Cathy.Evans@xxxxxxxxx
Sent: 17 August 2004 14:43
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access 2002: Relative Table Links?
Thanks, I have seen some things on writing to the custom properties of
the word doc, I haven't really had much success with adapting any of the
samples, though I have not been able to spend the time needed these past
few weeks on getting this right. Ideally I want to have several options
once a user has completed basic vendor/purchase data for them to be able
to open up a purchase or contract form with that basic data completed.
I'm almost leaning towards converting the word docs to access forms, I
converted one and it works pretty well.
Are you saying you want the data source to be automatically linked when
a new user/system opens one of the merge templates? I don't think I had
a
good understanding when I first replied. Is your mail merge doc
connected
directly to the access database or via ODBC? Here is a fascinating
discussion of ODBC/dsn_less connections, with sample database and many
good links including the 2nd below:
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=402012&page
=&view=&sb=5&o=&fpart=all&vc=1
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBC
DriverForMySQL
We also purchased several licenses and are testing ActiveDocs (
http://www.keylogix.com/), it has a data manager that handles the data
sources. They also have a set up where you can put your forms on your
web server or theirs and the users access the forms through the web.
They are linked to your main data source, and the user goes through the
queries to gather their data, then once they finish the merge, it opens
a word document.
hth, Cathy
-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material. If you are not the intended recipient
of this message you are hereby notified that any use, review,
retransmission, dissemination, distribution, reproduction or any
action taken in reliance upon this message is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer. Any views expressed in this message
are those of the individual sender and may not necessarily reflect
the views of the company.
-------------------------------------------------------------------------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
