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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: programmerchick
- Order by date
-
Record Source for reports and SQL Statements
If you are calling the same report from different places with different data, I would use a select case statement based on a variable that I passed to the on open event. Ex... sub report_open(i as integer) Select Case i case 1 me.recordsource = ("Select * from .....") case 2...- programmerchick
- Post #5
- Forum: Microsoft: Access Reports
-
Record Source for reports and SQL Statements
Are you saying your db creates a new report everytime you click the command button? Sharon Mihal smihal@mpea.com- programmerchick
- Post #2
- Forum: Microsoft: Access Reports
-
continuing report/label formatting to end of page
My database has an access 97 front end and an Oracle 8 backend. I'm trying to print a label-like report with 3 columns and 17 rows per page. I have been able to get the specific data I need, but when I run out of data, the formatting stops. I have tried dumping the data into a table first...- programmerchick
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
