QR Code-Integration of Microsoft Access and Microsoft Word

Question

QR Code-Integration of Microsoft Access and Microsoft Word

sasansamani

SSC Eights!

Points: 937
More actions
December 1, 2012 at 4:06 pm

#265599

What is the easiest way to integrate Microsoft Access and Microsoft Word?
We are converting permit numbers to QR code. 00000 – V / C 0000 – AT – YR
Is this the easiest way?
http://www.youtube.com/watch?v=ciPcmNv5rCw
http://strokescribe.com/en/qr-code-excel-word-csharp-javascript.html

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

WendellB SSCrazy Eights Points: 8678 More actions · Answer 1

If you are looking to export records or reports to Word, the simplest way is to use the Export function to RTF. There are several limitations in doing that however. For more sophisticated requirements you probably want to use Automation. It's a relatively complex subject requiring that you understand both the Access object model and the Word object model, in addition to being reasonably proficient in VBA. If you want to learn some of the basics, take a look at Automation 101. You might also find the Word mail merge capabilities useful, and that can also be automated - see Managing Merges with Access.

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!

ProofOfLife Ten Centuries Points: 1332 More actions · Answer 2

Hi

From the posts you have been making, you are having "fun" with Access at the moment 🙂

I agree with Wendell's comments about sharing data with other Office apps not being a straight forward topic. I have used Automation to get data into, and to manipulate, Excel spreadsheets, and it does require a bit of extra reading, not to mention the mandatory banging of one's head against brick walls.

But the methods Wendell mentions are all what I would call "push" methods. Don't forget that the other possiblity is to use a "pull" method, which may offer a simpler solution. This could be something simple like using the Word merge function and a query into your database, or something more complex like a macro in Word - creating a data connection to your database, a recordset and a procedure for dealing with the resulting data.

Again, my experience of this method lies more with Excel, and whether or not a "pull" method is suitable is a topic on its own, with its own set of issues to be considered. But nonetheless it is a valid method and worthy of a look.

Cheers

Rowan

royce.bacon SSC Eights! Points: 990 More actions · Answer 3

You might want to try the Office Watch Access section - There have been some articles on working with Word from Access and the other direction. There is at least one e-book available there on the topic.

Chris Quinn-821458 Hall of Fame Points: 3192 More actions · Answer 4

Easiest way is to use the mailmerge facilities within Word, connecting to your Access database

imageat Valued Member Points: 63 More actions · Answer 5

thanks for sharing, for someone like me only know how to create qr code in excel, have no idea in Microsoft Word. any suggestion will be greatly appreciated.