SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


QR Code-Integration of Microsoft Access and Microsoft Word


QR Code-Integration of Microsoft Access and Microsoft Word

Author
Message
sasansamani
sasansamani
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 66
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
WendellB
WendellB
Right there with Babe
Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)Right there with Babe (782 reputation)

Group: General Forum Members
Points: 782 Visits: 1761
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
ProofOfLife
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
Points: 110 Visits: 9474
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
royce.bacon
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 1044
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.
Chris Quinn-821458
Chris Quinn-821458
Old Hand
Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)

Group: General Forum Members
Points: 334 Visits: 846
Easiest way is to use the mailmerge facilities within Word, connecting to your Access database
imageat
imageat
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search