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
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar