Actually, you can do some filtering on the FileName - for example, LIKE
"*.pdf" to find all records that have PDF attachments.
Note also that when you include FileName in the query, you'll get one record
for each attachment in a record. For example, a record that has three
attachments will generate three rows in the recordset.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Saturday, May 04, 2013 9:51 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Filter for records with attachments
Kumar-
You cannot filter Attachments directly. To find out if a record *does* have
an attachment, test for:
[Attachments].[FileName] Is Not Null
Conversely, to test to see if a record does not have any attachment, test
for IS NULL.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Friday, May 03, 2013 8:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Filter for records with attachments
Dear All,
I am having a continuous form where I display Attachments using
attachment control. I use various unbound comboboxes to search for the
records meeting the specified criteria. I want to filter for records having
attachements. Please help me with proper VBA coding to accomplish this. My
unbound combobox is named cboSearchAttachments and Attachment field is named
Attachments.
Also, when I right click on the attachments field of form, it does not
have filter option.
Thanks and Regards,
Kumar Iyer
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar