INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Where have you been all my life! I found the answer I needed in seconds..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

Word/ Access 2007 data merge problem

Read More Threads Like This One

Donaldp1994 (IS/IT--Management)

29 Jun 12 13:51

Hi, My first item on your Forum.
I am doing some work for a client taking a select query (with 81 fields) in Access and feeding it into word, with some VB to populate Check boxes.
Some of the fields are not populating correctly from the query in as much as if field e.g. "c2" (in the query can return a number of different numbers e.g.78 or 35, with the fall back being zero); word is reading zero on each occasion.
Does anyone have any idea as to why this is happening?

SkipVought (Programmer)

29 Jun 12 13:55

Quote (SkipVought)
...please ALSO include the relevent code that addresses the issue at hand.

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

Donaldp1994 (IS/IT--Management)

29 Jun 12 15:09

Hi. I can not show the thread as it is not as simple as that. I can see the data correctly in the Access query, but when I run the debug in the word VB the cell result is showing the exception value rather than than value produced in the query.

SkipVought (Programmer)

29 Jun 12 15:33

Sorry. My crystal ball isn't working either.

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

macropod (TechnicalUser)

29 Jun 12 19:45

FWIW, Checkboxes can only take 1 or 0.

Cheers
Paul Edstein
[MS MVP - Word]

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To VBA Visual Basic for Applications (Microsoft)