View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Access to Excel: Identify attachment field in access database

Hi All,

How do I query a database field of type attachment?

For eg:

I have a database field of type attachment and I want to run a query in
excel that identifies columns with no attachments and some other criterias
and populates it.

here is the query I have so far:

If rst.fields("7") Is Null and rst.fields("5") = "Chicago" Then
Me.File.Value = "NO"
End If

Hope I made it clear

Thanks in advance