Printing new records

[Noreene Patrick]

I am setting up a new database for work orders. The thought process right now is:

When a new work order is generated, then I would like for the new record (entered in a form) to print to the Safety Director's printer. This way she will be aware of all new work orders as they are entered.

I can make it print to my printer by vb code such as this:

docmd.printout acselection

It will print to my printer but I dont know how to tell it to print to someone else's printer on our network.

The database will be on our server so that anyone can enter a work order.

I know you have the answer....I am so thankful for this forum!!!

Noreene

 

[Travis]

Does it need to be a printout? Have you thought of using email?

In order to have it print to a specific printer you would need to have that printer set up on every machine that uses the database. Add code to select the specific printer (because it most likely would not be the default printer).

Or

Create another utility with a timer that looks for newly created Work Orders (Boolean field set to False when first created and set to true once printed) that spits out a report on an interval basis.

However, the technique that you currently use to print to your printer converted to an email sent to the Safety Director would allow them to analyze it without printing (saving one more tree).

 

[Noreene Patrick]

Thanks, Travis.

No, it doesnt have to be printed...it can be an email but printing it just seemed to be easier of an idea than email.

So, could you at least give me a start on exactly what code? I would need? You said a boolean field, I am not exactly sure how to go about this. Just an example would help.

And thanks again, Travis

Noreene

 

[Travis]

If you use the Email Option you can still use the same method you are currently using the Prints to your machine. The difference is that you would use the SendObjects function.

If you want to set up a system where the Safety Director prints a report of all new Work Orders, you can add a Yes/No(True/False) (Boolean) field to the Work Order Table. The Default is No/False/0. Create a Report that is feed the Work Order Information of all work orders that this field is "False". On the Closing of the Report you set this field to "True" with an Update Query.

 

[Noreene Patrick]

Thanks for your quick reply.

I am going to work on this....but I may have some more questions as I build this....I love Access but I can really get confused on some things...

Thanks,
Noreene

 

[Noreene Patrick]

Okay, I have gotten to the point that I need more help.

This is my code for command button to submit the work order.

Private Sub Command41_Click()
DoCmd.SendObject acSendForm, "workorderentry", ".txt", "noreene_patrick@averydennison.com", , , "New Work Order", , False
MsgBox "Another Work Order?", vbYesNo
If vbYes Then
DoCmd.GoToRecord , , acNewRec
If vbNo Then
DoCmd.Close acForm, "workorderentry", acSaveYes

End If
End If
End Sub

It might work great, but I dont know because it wants to send my email by Outlook but we use Lotus Notes...So, how do I tell it to send thru Lotus Notes?

Thanks for your answer!!

Noreene

 

[Noreene Patrick]

Please HELP!!!!

Could someone please point me in the right direction? I have no clue as to how to write the code for my sendobject to go to Lotus Notes.

Thanks