Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 26th, 2005, 12:31 PM
Registered User
 
Join Date: Jan 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inserting Word Documents into Access

I am trying to write a script (VBA) to mass update an existing table with a Blob field of Word Documents. I have the code setup to compare the document's last update date with the one in the table (a field for last date), then if the dates do not match, copy the document and insert it into the Blob Field. I have tried to copy the document as a OLE embedded source into a unbounded Object Frame, then copy this to the clipboard then paste to a Bound Object Frame. Finally, I set the field equal to the Bound Object Frame. Unfortunately, this doesn't work very well. Any suggestions?
 
Old January 26th, 2005, 12:42 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What is a "blob" field?

You can do these three things:

1. Store all the text from the Word Doc in Access (memo field)
2. Store a link to a Word doc and open it from Access (hyperlink field)
3. Store an image of the Word doc in Access (OLE object)

I don't think you can store an actual Word doc within Access.

I could help with any of the three above, but not with the request as it is.

mmcdonal
 
Old January 26th, 2005, 12:58 PM
Registered User
 
Join Date: Jan 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A BLOB field is a Binary field in Access (OLE Object). To manually insert a Word Document into this field, you copy the Document from Explorer, then highlight the binary field and paste it in. I want to do this programmically.

 
Old March 6th, 2005, 03:56 PM
Authorized User
 
Join Date: Jun 2004
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've never heard of a BLOB field, but I'm open to new ideas. The best that I can suggest is to cut & paste into a richtext field. A richtext field; though, does not have the full formatting capacity of a word processor like MS Word. If you're interested, I have more information on richtext fields.

PC

 
Old December 14th, 2005, 02:02 PM
Registered User
 
Join Date: Dec 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

I am new to this forum and while browsing I noticed this reply to a question on inserting Word docs into Access. I have been trying to do this for an employees database I am developing. I would like to display CV's from Word in my database and, if possible, search them for specific skills or experience. I would love to know how to store the text in a memo field and any other hints you might have.

Thanks in advance.



Quote:
quote:Originally posted by mmcdonal
 What is a "blob" field?

You can do these three things:

1. Store all the text from the Word Doc in Access (memo field)
2. Store a link to a Word doc and open it from Access (hyperlink field)
3. Store an image of the Word doc in Access (OLE object)

I don't think you can store an actual Word doc within Access.

I could help with any of the three above, but not with the request as it is.

mmcdonal
Riccardo





Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract embedded documents in the word document ayyanarj General .NET 0 August 31st, 2007 12:32 AM
Scanning documents and inserting them into Access DebT37 Access 3 January 3rd, 2007 09:32 AM
Inserting Excel pivot chart into Word documents jfejsa Word VBA 1 January 23rd, 2006 09:16 PM
ASP and word documents Nicky2k Classic ASP Databases 1 August 11th, 2005 04:11 PM
comparision of two word documents anuradhad VB How-To 1 July 24th, 2004 04:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.