ACCESS FEED: Re: [MS_AccessPros] Filter for records with attachments

Sabtu, 04 Mei 2013

Re: [MS_AccessPros] Filter for records with attachments

John;
Thanks. I test it and is working fine.

Kind Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Kumar-
>
> If Not IsNull(Me.cboSearchAttachments) Then
> If Me.cboSearchAttachments = "Has attachment" Then
> strWhere = strWhere & "([Attachment].[FileName] Is Not Null) AND
> "
> Else
> strWhere = strWhere & "([Attachment].[FileName] Is Null) AND "
> End If
> End If
>
> Your combo box should have two rows, one that asks for with attachments, and
> the other that asks for without. You can decide the exact values and fix
> the comparison above accordingly.
>
> 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: Saturday, May 04, 2013 2:53 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Filter for records with attachments
>
> Thanks John, but can you help me with exact coding. To filter for other
> fields, I am using the following codes.
>
> If Not IsNull(Me.cboSearchPlant) Then
> strWhere = strWhere & "([Plant] Like """ & Me.[cboSearchPlant] &
> """) AND "
> End If
>
> If Not IsNull(Me.CboSearchTrade) Then
> strWhere = strWhere & "([Trade] Like """ & Me.[CboSearchTrade] &
> """) AND "
> End If
>
> etc.
>
> Kind Regards,
> Kumar
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>