Attachment in Query error

zozew

Registered User.
Local time
Today, 19:22
Joined
Nov 18, 2010
Messages
199
I have a Form with a Query record source and all is fine :) adding an attachment field to the Query and then opening the form works fine but running a filter on the form i get.

"search key was not found in any records"

I've debugged it down to:

I have two of my fields in the Query with a "Last" option in the Totals, if i remove the Totals line in the Query i can filter it with an attachment field in the Query..but if there is an attachment field with its Total line set to "Expression" i get the error. when i add the attachment field it automatically adds the "Expression" to the Totals line...any way to get around it?

Any solution to this?
 
do you really need the field containing the attachment in the query? Is it really important to see its value or do you only want to see if there is an attachment at all?

My advice would be to show that there is indeed an attachment by displaying 'Yes' or 'No' and when clicked upon, do a lookup and retrieve the actual attachment.

HTH:D
 

Users who are viewing this thread

Back
Top Bottom