data shows up only after debugging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 07 Sep 2005 01:13 GMT

I create a form and a button on the form. When I click the button, the code
would send information to the report to be printed out. However, data show up
on the report only when I debug line-by-line (there are no erro at all. I
open connection to the database and recordsets). Otherwise, it prints out
blank pages.
Do you know why?
Thanks,

Reply to this Message

Alex Dybenko - 07 Sep 2005 07:57 GMT

Hi,
can you post your code here?

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I create a form and a button on the form. When I click the button, the
>code
[quoted text clipped - 5 lines]
> Do you know why?
> Thanks,

Reply to this Message

Tim - 07 Sep 2005 21:13 GMT

Hi,
The code is very long and involves to the business law that you won't bother
to read. I still can not figure out why I have to trace line by line for the
report to print the data. If I don't do that, the report would print the
blank page :=(

Here is some sample of code:
rsSample.AddNew
rsSample.Fields(0) = strID
rsSample.Fields(1) = rsS.Fields(2)
rsSample.Fields(2) = rsS.Fields(3)
rsSample.Update
rsSample.MoveNext

If rsSample.EOF Then
Exit Do
End If

Loop

DoCmd.OpenReport "rptTGrader", acViewNormal

If you find out something, please let me know,
Thanks, Tim

> Hi,
> can you post your code here?
[quoted text clipped - 8 lines]
> > Do you know why?
> > Thanks,

Reply to this Message

Alex Dybenko - 08 Sep 2005 07:04 GMT

hi,
So you modify tables, report based on, before printing?
try to calcultate record count before printing in both case, maybe this will
give an idea

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi,
> The code is very long and involves to the business law that you won't
[quoted text clipped - 38 lines]
>> > Do you know why?
>> > Thanks,

Reply to this Message

Tim - 08 Sep 2005 21:01 GMT

Hi again,
I use the record count as you advice, and yes, it does show up that there
are records in the table before printing out the report. But why it does not
show up in the report???
Do you have any idea about it?
Thank you,

> hi,
> So you modify tables, report based on, before printing?
[quoted text clipped - 43 lines]
> >> > Do you know why?
> >> > Thanks,

Reply to this Message

Alex Dybenko - 09 Sep 2005 13:16 GMT

Hmm, looks like a miracle.
so reprot you get - only blank pages? no report header?
Maybe you have some code in report's class module?

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi again,
> I use the record count as you advice, and yes, it does show up that there
[quoted text clipped - 58 lines]
>> >> > Do you know why?
>> >> > Thanks,

Reply to this Message

Tim - 09 Sep 2005 13:42 GMT

No, it's not a miracle, it's a nightmare to me :). No, I don't have any code
in the report's class module. The program is to get data from a table and
put it in the second table with some calculations. And then the second table
is the record source for the report. That's it!

> Hmm, looks like a miracle.
> so reprot you get - only blank pages? no report header?
[quoted text clipped - 62 lines]
> >> >> > Do you know why?
> >> >> > Thanks,

Reply to this Message

Alex Dybenko - 10 Sep 2005 06:16 GMT

Maybe try to decompile a project, if you didn't make so yet, details you can
find at www.mvps.org/access, search for decompile

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> No, it's not a miracle, it's a nightmare to me :). No, I don't have any
> code
[quoted text clipped - 75 lines]
>> >> >> > Do you know why?
>> >> >> > Thanks,

Reply to this Message