Printing New Record

[prepella]

What I am trying to do is when a new record is added to a table, it will automatically print it out without any operator intervention.
Is this possible? Is there a way to get the record into a report and just print the new record from the report? Im new to this and it would have to be triggered automatically.

Thanks
Phil

 

[MadMaxx]

How is the data being entered into the database?

 

[prepella]

The data is entered via a form on a web page using asp

 

[MadMaxx]

I have done something similar to that. To do this you will need some sort of ASP e-mail object. I recommend using ASPMail. It's server side so if you are using a web server outside your home or office hopefully they will have it.

Now this code is for ASPMail

What you do is after your insert statement create a recorset that selects the record you just entered via some id number your using.

Set Mail = Server.CreateObject("Persits.MailSender")
      
      Mail.Host = "your smtp server"
      Mail.From = "whoever"
      Mail.FromName = "name of sender you want"
      
      Mail.AddAddress "whoever@youremail.com", "name"
      
      Mail.Subject = "Quote Submitted by: " & rstQuote("Supplier Name")
      
      strBody = "I have submitted details on the quote you have requested for part " & rstQuote("Part Number") & "."
      strBody = strBody & " All the details can be found in the quote file " & rstQuote("ReplyQuoteFile") & "."
      Mail.Body = strBody
      Mail.Send

then you can use the values of the recordset in the body of your e-mail to get whatever you want. Let me know if this is what your after.

 

[prepella]

I am already doing this now, I want to get away from the email and just have it print, instead of emailing it. When our internet connection gets messed up we lose a lot of emails. So just printing would be a better choice.

Thanks
Phil

 

[MadMaxx]

is the system located in the company or on a host?

 

[MadMaxx]

If you think about it I don't think you can actually print using code. I think what you have to do is create a report and have whoever view the report and print it that way.