Senin, 08 Februari 2016

[MS_AccessPros] Re: Type mismatch error running reports with conditionally formatted fields



Does it work if you remove the barcode stuff? Maybe that addition corrupted the report. You could try saving the report as text, deleting the existing report and then loading the report from text back into the database. Sometimes that clears up object corruption.

Example: type in Immediate window:
SaveAsText, acreport, "myReportName", "fullFilePath"
LoadFromText acreport, "myReportName", "fullFilePath"


---In, <> wrote :

Hi Bill,

Sorry I didn't mention earlier, but that's part of the problem.  I've used a test range of two consecutive orders, and both have images.  I've used the "print single order" option and can print each order individually and see the images.  There is an expression in the query associated with the report that looks for in field in one of the SQL tables which denotes the path the image file on a server (the same server as the front end db).  That's what the [DWG] on the right side of the expression on the second screenshot refers to.  I thought that was a bound control but maybe I'm wrong.  This report worked fine before the proposed bar code changes, and even after removing the "alternate" bar code, it still throws that error (except on the previously mentioned single order option).

Thanks again,


Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)



Tidak ada komentar:

Posting Komentar