QR Code-Integration of Microsoft Access and Microsoft Word

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Microsoft Access » Microsoft Access » QR Code-Integration of Microsoft Access and...

QR Code-Integration of Microsoft Access and Microsoft Word

Rate Topic

Display Mode

Topic Options

Author

Message

sasansamani

Posted Saturday, December 01, 2012 4:06 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, January 11, 2013 11:52 AM
Points: 28, Visits: 50

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

Post #1391676

WendellB

Posted Saturday, December 01, 2012 6:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:46 AM
Points: 106, Visits: 405

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

Post #1391682

ProofOfLife

Posted Sunday, December 02, 2012 3:09 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:11 PM
Points: 45, Visits: 9,440

Hi

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

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

Post #1391749

royce.bacon

Posted Monday, December 03, 2012 11:59 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:54 AM
Points: 34, Visits: 641

You might want to try the Office Watch Access section - [url=http://office-watch.com/zd.aspx?30][/url] 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.

Post #1392102

Chris Quinn-821458

Posted Tuesday, December 18, 2012 4:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:24 AM
Points: 175, Visits: 696

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

Post #1397690

charleswoodoof

Posted Monday, May 06, 2013 12:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 9:08 PM
Points: 2, Visits: 8

This is a Word mail-merge qr code integration guide that is able to support qr generation

Post #1449595

« Prev Topic | Next Topic »

Permissions