ACCESS FEED: Re: [MS_AccessPros] CrossTab Query in 2010 [ report extremely slow on watermark image]

Selasa, 14 Agustus 2012

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

Thank you Duane

Best,
Ozair

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> I don't care much for that "expensive" solution for creating crosstab reports. I use the solution at http://www.rogersaccesslibrary.com/forum/cross-tab_topic11.html which is more flexible and efficient.
>
> "This Access 97 mdb demonstrates how to create a report from a crosstab query where the column headings will not be known until run-time. The report will accomodate any number of columns with extra columns "wrapping" under the first set of columns.
> This type of report could be used to display salesperson orders and dates as row headings and customers as column headings. The method I developed will dynamically create columns to match each different salesperson. If a salesperson has 2 or 20, the report will accommodate them all. This method runs fairly quickly and requires only about 20 lines of code."
>
> I haven't tried this with Access 2010 but it should work just as well. If you need me to convert the file and post it in the files section.
>
> Duane Hookom
> MS Access MVP
>
>
>
> > To: MS_Access_Professionals@yahoogroups.com
> > From: ozairkhalid@...
> > Date: Mon, 13 Aug 2012 06:18:20 +0000
> > Subject: [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
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>