Access to Excel: Identify attachment field in access database

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

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
 
Thanks for your help joel,

I understand the choices you gave me, But I am not getting the query wright
with tha attachment field in it. It doesnt give me the right results when I
use it in Excel

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

I tried creating the query in access and running it and it works fine, But
when I do it in excel it doesnt show me the right results.
Do I need to user any specific property of the attachment field in the query
when I am testing if its null? such as rst.fields("7.FileURL") ,
rst.fields("7.FileType") etc?

Basically I am having issues with running the query with attachement field
in the query.

Thanks in advance
 
I tried doing that, But the query generator in excel is giving me an error
when I try generating query with access 2007 that is accdb format. and I
cannot do this by converting it to access 2002-2003 which is mdb format
because that version of access didnt allow attachments.
 
Back
Top