Word Word merge from Access 2007 to Word 2007 brings over PK value and not text value.

K

Kellyzeroes

Joined
Jul 13, 2011
Messages
1
Reaction score
0
Hello,

Can someone help me please. I have a word merge running from an Access 2007 form to word (Mr Kallals' great code). The problem is that I set up certain underlying tables with numeric primary keys and then their second field contained the text I wanted to show on the form.

e.g. Column 1 Primary key
Column 2 Location

So PK 11 shows as 'Anywhere UK' on subsequent forms and queries. The problem is that my merge with the VBA module mentioned above and the word merge operation in Access' export facility only show '11' instead of ' Anywhere UK'.

I'm really stuck and very weak with vba. But surely this is something that might be fixed from within Word as much as Access

Can someone help.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007/Word 2007 Mail Merge Opens Second Instance 2
Access/Word 2007 Mail Merge Question 1
Merge Access OLE Photo to Word 2
IF function results to include both text and cell value 2
From Access - Automating Word - Mail Merge - plus Inserting text. 2
importing tables in proper format from word 2007 into access 2007 2
Mail merge to Word from Access 2000 1
Migrating from Word mail merge to Access Reports 4

Top