[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)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___