Solved

Is it possible to do a simple search (Find) in an Access 2007 form on an Attachment field type?

Posted on 2013-11-25
6
294 Views
Last Modified: 2013-11-26
I have an Employee table and want to attach a Word 2007 resume file in an Attachment field type field (Resume).  Is it possible to do a search on this Resume field in the future from within a form for this table?  I would like to be able to do a search using the Find feature on the Resume field from within the Employee form.
0
Comment
Question by:PJ_KD
  • 3
  • 3
6 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39676442
Do you mean search within the item in the attachment field - for example, search a Word document in the attachment field for data in that document? If so, then no, you could not do that directly in Access.

You could find the name of an attachment in the attachment field. For example. if you have 3 attachments named Attach1, Attach2 and Attach3, your could search for "Attach3" and find that.
0
 

Author Comment

by:PJ_KD
ID: 39676476
So if there is only one attachment field in my example I would not be able to search the contents of that attachment like was possible in older  versions of Access?
You said that the search was not directly available in Access. Is there any means to do a search on the attachment content?
In your response of the three attachments, what would be the value in searching for the attachment file name?  Thank you for your help so far.
0
 
LVL 84
ID: 39677603
The Attachment datatype is new in 2007, so I'm not sure what you mean by "older versions of Access". If I've misunderstood, then please provide more details.

You could use the native application to do a search, but that would be a massive effort IMO. For example, if you have Word document, you could get the name/path of that Word document and then automate an instance of Word, and use the search features through that automated instance to search the document. You'd then have to do this for all other attachment types (like Excel, for instance). Of course, you can't search Images and many other types, so I don't know how useful that would be.

Regarding the value in searching for the file name - I have no idea what that value would be to you, but if you're storing attachments that have relevance in the title/name, then it could be of value. For example, if I'm storing scanned Invoices as an attachment, and I have 30 or 40 invoices attached to a single Customer, then perhaps I'd want to search for an invoice named "INV12092012" ...
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Closing Comment

by:PJ_KD
ID: 39677702
Access 97 used to support an OLE type of field that was actually searchable but exploded the size of the DB because the field was embedded in the DB.
Do you know whether an Attachment type field can be attached to an email generated from Access then and if so, do you have a link to how to do this?
0
 
LVL 84
ID: 39679437
2007/2010 still support the OLE field type, but as you mention it's not a good way to store data.

You could attache anything to an email, but you cannot do so directly from an attachment field item. You'd need to output that file somewhere, then create an email and attach it. However, that would really be a separate question, so it would be best to post that as a new question.
0
 

Author Comment

by:PJ_KD
ID: 39679623
Thank you.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now