Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blank attendance form with variable number of rows? 1

Status
Not open for further replies.

greg32246

Technical User
May 21, 2009
19
US
I have been asked to provide a blank attendance form for my users in an application. This is just supposed to be a form that they can print off and write on manually. So, I figured I would just create a Report with some rectangles and column headers, etc, to give the appearance of an attendance form. I was just going to have a report that had maybe 25 spaces or whatever would fit nicely on a standard page. Then I was asked if I could make the form dynamic, so that the user could select the number of blank rows that would be printed on the attendance form.

Can anyone offer suggestions for doing this? I can't think of anything that wouldn't involve a table with records that would contain zero length strings and a report based on the table that would be allowed to grow and/or shrink. Does anyone have any better ideas?



 
I would use a digit table

Create a report with one detail line with boxes and rectangles ect
and in the report record source

Code:
Select Digitid 
from digits
where digitid<=DynamicAmountWanted
 
Thanks Pwise,

I kind of thought it would involve a table, but I was somehow thinking I would have to dynamically append records into it. I don't know why I didn't think of your solution.

Thanks again!

greg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top