Minggu, 12 Agustus 2012

[MS_AccessPros] CrossTab Query in 2010 [ report extremely slow on watermark image]

 


Hi,

I created a report in Access 2003 which is based on http://support.microsoft.com/kb/328320

The report runs on a reasonably good speed at Access 2003 and Access 2007. But it is stalled when it runs on Access 2010.

Detail...
I need to use an image as watermark. Code from Microsoft's above example shows ZEROS when the current textbox is empty.

I want to hide those ZEROS from the watermark image.

So I wrote this...

Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)

'*** to hide ZEROS on water marked logo starts
If Me("Col1") < 1 Then
Me("Col1").Visible = False
Else
Me("Col1").Visible = True
End If
'*** to hide ZEROS on water marked logo ends

' I have 26 columns -
In short, the report runs good on 2003/2007 but fails in 2010.
it works good if the above code is removed.

Can someone help me with this?

Best,
Ozair

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar