zeppe
Aug 5th, 1999, 06:25 AM
I'm having difficuty generating a simple (maybe not so simple) report. I'm
working on a database application. The application has forms with 100 or so textboxes
which are saved as records in each appropriate table. I was going to simply create a form
with the necessary text boxes, format them and print the form. I just found out that you
can only print what you can see. Is there a way of tricking it in thinking that your veiwing
area is larger? Out of desparation I was forced into using the data report designer with the
data environment. It's printing all the records in the table. I've tried quering it to give only
one record, but could not. All the sample queries I've come across have been hard coded
queries i.e. Select * from table where field in table = constant , where would use such a
query!! How do I query with a textbox on a form
i.e. select * from table where field in table = frmAsr.txtASR
working on a database application. The application has forms with 100 or so textboxes
which are saved as records in each appropriate table. I was going to simply create a form
with the necessary text boxes, format them and print the form. I just found out that you
can only print what you can see. Is there a way of tricking it in thinking that your veiwing
area is larger? Out of desparation I was forced into using the data report designer with the
data environment. It's printing all the records in the table. I've tried quering it to give only
one record, but could not. All the sample queries I've come across have been hard coded
queries i.e. Select * from table where field in table = constant , where would use such a
query!! How do I query with a textbox on a form
i.e. select * from table where field in table = frmAsr.txtASR