If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
yet again form and report
i need to be able to do is have a button on a form, where
i can just send all the present data (in the form) to a report, and then open up new data on the form, and be able to send that to the same report (like creating an invoice) and then be able to print off that report with just that data... |
#2
|
|||
|
|||
yet again form and report
"caleb" wrote in message
i need to be able to do is have a button on a form, where i can just send all the present data (in the form) to a report, and then open up new data on the form, and be able to send that to the same report (like creating an invoice) and then be able to print off that report with just that data... You're not going to be able to do that without having some mechanism whereby you record what records are supposed to be included on the report. For example, you could have a Yes/No field, "IsSelected", in the table, initialize this this field to False for all records, then set it to True for each selected record, and ultimately print a report based on a query that selects only those records with IsSelected = True. Or you could have an intermediate table where you stick the data until you print the report. That is, you could have a table named, say "ReportData", run a delete query to empty this table before you begin, and then every time the user clicks a "Select For Report" button you copy the current record to that table. The report could than be based on the ReportData table, rather than the original table. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
yet again form and report
"caleb" , haber iletisinde sunlari ... i need to be able to do is have a button on a form, where i can just send all the present data (in the form) to a report, and then open up new data on the form, and be able to send that to the same report (like creating an invoice) and then be able to print off that report with just that data... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Preview Report in Form | Craig | Using Forms | 1 | June 23rd, 2004 03:57 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
From a report record to the specific record in a form | Sierras | Using Forms | 1 | June 18th, 2004 02:54 PM |
Form with timer is printed instead of report | hernan castro | Using Forms | 3 | June 11th, 2004 11:07 PM |
Query Form: Print Report | Dennis | Running & Setting Up Queries | 1 | June 6th, 2004 01:08 PM |