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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by programmerchick

  1. programmerchick

    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...
  2. programmerchick

    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
  3. programmerchick

    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...

Part and Inventory Search

Back
Top