Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013
    Posts
    30

    Unanswered: Report with loop count on textboxes...

    Hi fellow users,

    I'm having problems in creating report where the one textbox sole purpose is to output the calculated loop number.

    For example, I counted how many are there in my data table supposed to be outputted in between the user defined dates (This one's fine, no problem encountered so far!). Next, using FOR LOOP, the mentioned textbox will output the calculations done on the loop.

    The code is written in Detail On_Print() event of the report:

    Dim i as Integer
    For i = 0 To CountedDateByDate Step 1
    txtCNumber = i
    Next i

    What could possibly the problem? Could it be in the FOR LOOP?
    Thanks for any helpful replies and answers...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Is tbe code running?
    ... Put a breakpoint on the code and check it stops there.
    Does counteddatebywhatever have a value
    What is txtcnumber
    Why do you think you need to assign a value to a reports textbx cobttol ibsude a loop on a report
    If you must whynot assign the value of counted....
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2013
    Posts
    30
    The answer is putting "=1" on the textbox control source and set running sum to "Over All". Then it's all good to go!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •