Senin, 08 Februari 2016

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

 

Michael


When your code breaks are you checking that there is a value in DWG. Can you create a testing report with a that record and see the image?

I imagine there is a reason why you are assigning a picture on the fly, but why not use a bound control for that?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <mbentfeld@yahoo.com> wrote :

Hello all,


I have a database consisting of an Access 2003 front end with a SQL 2008 back end (actually our ERP database), used to print factory production orders.  The database form allows users to print single orders or a range of orders based on a planner code, a simple numerical range, or a combination of these.  


Recently, I have modified the reports to print a bar code to allow orders to be received using a scanner tool.  Per user requests, I am modifying the orders again to allow the bar code to appear in an alternate location for orders with a certain commodity or flow code which should not be received immediately.  To accomplish this, I decided to print the bar code field twice, and use conditional formatting on both fields.  Here's the criterion expression I'm using for the conditional formatting:


Expression is [COMCDE_01] like "*Z*"


In the primary location, the conditional formatting is set so that the font color changes from black to white when this expression is triggered.  In the alternate location, I use the same expression, but have the colors reversed.


When I use this for the report with single orders, it works correctly.  However, when I use this formatting in other reports with the other selection criteria mentioned in the beginning, I get a "Run-time error 13 - type mismatch."  When I look at the vb debugger, the error indicates a problem with a image control used on the reports (I will upload a Word document with screenshots). In the past, has indicated an order for a part that is  missing a bitmap drawing, but none of the parts in my range of test orders is missing a drawing.  I wonder what could be causing this.


I also have PDF samples of what the two bar code variations should look like if anyone thinks it might help.


Thanks in advance,

Michael

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar