Sabtu, 04 Mei 2013

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

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar