Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

QR Code-Integration of Microsoft Access and Microsoft Word Expand / Collapse
Author
Message
Posted Saturday, December 1, 2012 4:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Saturday, December 1, 2012 6:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:17 PM
Points: 164, Visits: 605
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!
Post #1391682
Posted Sunday, December 2, 2012 3:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:34 PM
Points: 48, Visits: 9,470
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
Post #1391749
Posted Monday, December 3, 2012 11:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:36 AM
Points: 38, Visits: 770
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
Posted Tuesday, December 18, 2012 4:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:56 AM
Points: 188, Visits: 775
Easiest way is to use the mailmerge facilities within Word, connecting to your Access database
Post #1397690
Posted Tuesday, June 3, 2014 8:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:11 PM
Points: 1, Visits: 0
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.
Post #1577199
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse