ACCESS FEED: Re: [MS_AccessPros] Re: List of Attachements

Selasa, 27 Mei 2014

Re: [MS_AccessPros] Re: List of Attachements

To add, the fields associated with an attachment recordset are

FileData

FileFlags

FileName

FileTimeStamp

FileType

FileURL

Unfortunately FileFlags, FileTimeStamp, and FileURL do not return any values for me. So you can try adding the FileTimeStamp to your query, it may work. It renders OK for me, but for me no data is returned.

example

SELECT

Products.ID,

Products.Attachments.FileName,

Products.Attachments.FileType,

Products.Attachments.FileTimeStamp

FROM

Products

WHERE

((Not (Products.Attachments.FileName) Is Null));

I am assuming this is for future development. I get the same issue in code, and no data is returned.

On Tue, May 27, 2014 at 1:17 PM, plpoppe@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

A list is simple. Just use a sub report. Something like this

SELECT
Products.ID,
Products.Attachments.FileName,
FROM
Products

WHERE
((Not (Products.Attachments.FileName) Is Null));

I am not sure if the date information is stored.