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
|
|||
|
|||
Button to print current record only
I have a data-entry form that saves the data into a main table. Once
the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris |
#2
|
|||
|
|||
Button to print current record only
You just need to set up your report to filter out by
whatever you're using for a recordID. Add a where clause to your macro or VBA code that searches your control source for the current record number of the open form when the report queries. Something like: MyTable.RecordID=MyOpenForm.RecordID(this is the control name...not the field name) -----Original Message----- I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris . |
#3
|
|||
|
|||
Button to print current record only
Could this example be set up to send via Email?
Brook -----Original Message----- You just need to set up your report to filter out by whatever you're using for a recordID. Add a where clause to your macro or VBA code that searches your control source for the current record number of the open form when the report queries. Something like: MyTable.RecordID=MyOpenForm.RecordID(this is the control name...not the field name) -----Original Message----- I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris . . |
#4
|
|||
|
|||
Button to print current record only
There's no reason that it couldn't. We use it here in one
of our databases to email call documentation across the company. We have a form that we fill out that summarizes all calls to customers, vendors...etc. When we want other people in the company to be informed immediately of the subject matter we have a button on the form that puts the record into report format and sends the report to the chosen recipients. -----Original Message----- Could this example be set up to send via Email? Brook -----Original Message----- You just need to set up your report to filter out by whatever you're using for a recordID. Add a where clause to your macro or VBA code that searches your control source for the current record number of the open form when the report queries. Something like: MyTable.RecordID=MyOpenForm.RecordID(this is the control name...not the field name) -----Original Message----- I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris . . . |
#5
|
|||
|
|||
Button to print current record only
That is exactly what I need to do, how do I accomplish
this? And is there a way that have a select box of some sort to choose my email address from (If I have a tblEmail, set up?)? Thanks for your help! Brook -----Original Message----- There's no reason that it couldn't. We use it here in one of our databases to email call documentation across the company. We have a form that we fill out that summarizes all calls to customers, vendors...etc. When we want other people in the company to be informed immediately of the subject matter we have a button on the form that puts the record into report format and sends the report to the chosen recipients. -----Original Message----- Could this example be set up to send via Email? Brook -----Original Message----- You just need to set up your report to filter out by whatever you're using for a recordID. Add a where clause to your macro or VBA code that searches your control source for the current record number of the open form when the report queries. Something like: MyTable.RecordID=MyOpenForm.RecordID(this is the control name...not the field name) -----Original Message----- I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris . . . . |
#6
|
|||
|
|||
Button to print current record only
In the Click event of the command button set me.Dirty=False. That will save
the record if it has been modified. Then DoCmd.OpenReport "rptName", A_NORMAL, , "MyTable.[ShopID] = " & Me![ShopID] HTH -- -Larry- -- "Fatz" wrote in message om... I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris |
#7
|
|||
|
|||
Button to print current record only
So in turn, can this report be set up to Send Email, by
allowing the user to choose the email receiptiant from a Table? Brook -----Original Message----- In the Click event of the command button set me.Dirty=False. That will save the record if it has been modified. Then DoCmd.OpenReport "rptName", A_NORMAL, , "MyTable.[ShopID] = " & Me![ShopID] HTH -- -Larry- -- "Fatz" wrote in message . com... I have a data-entry form that saves the data into a main table. Once the user pushes "Enter", the "Print Record" button enables so the user can print the current record. The way I have it set now is that it takes you to a form where the user manually selects the record to print. I need to make it so that when the button is clicked only the current record is selected and automatically printed. I don't even want the user to see the report...just click the button...teh record is printed...and they move on to the next entry. Any thoughts on the best way to do this?? My initial thought was to append the record to a new table and then run the report off that table. Once the user prints the record and clicks the "Add New Record" button a delete query would clear that table and then append the new record that was added...print it...and so on... Am I on the right track here?? I appreciate all help and suggestions! -Chris . |
Thread Tools | |
Display Modes | |
|
|