On Aug 6, 2:00=A0pm, Carol Grismore
<CarolGrism...@[EMAIL PROTECTED]
> wrote:
> Thank you for your suggestion!
>
> I appreciate (and steal) others' code, and I'm sure this works just
great=
.. =A0
> Actually I think I already have it.
>
> What I'm really trying to find out, though, is how to work the
TransferTe=
xt
> command -- or that it doesn't work, and maybe why.
>
> My bad for not making that clear in my first post.
>
> Thanks again!
> --
> Carol
>
> "pietlin...@[EMAIL PROTECTED]
" wrote:
> > On Aug 6, 12:45 pm, Carol Grismore
> > <CarolGrism...@[EMAIL PROTECTED]
> wrote:
> > > I'm trying to run a very simple TransferText to put data from an
Acce=
ss query
> > > into a Word template. =A0I get the message, "Cannot update.
=A0Databa=
se or object
> > > is read only." =A0
>
> > > To the best of my ability to tell, nothing is read only. =A0Any
debug=
or
> > > repair suggestions would be deeply appreciated.
>
> > > --
> > > Carol
>
> > use Albert Kallal's "Super Easy Word Merge" code. =A0So easy, even *I*
> > can use it.
>
> >http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
Not sure you can stuff data from Access directly to a Word template
using TransferText. I have stuffed data from Access to Word Bookmarks
using VBA, though. I would use Albert's solution unless you need to
transfer both data from the "many" side of a relation****p and the
"one" side. The example from the Developers Handbook is an invoice.
They grab the "header" info from an invoice query (customer/Invoice
header) and then the line items from an invoice query. Then they
transfer the invoice header info using bookmarks.
post your code that's failing and highlight the line(s) where it fails.
|
