>I created an inhouse e-mail system for my office. All the email goes to the server into the database. Now I need to create a reply button. When message is read, it's located in a cursor. I need to be able to copy all the info in that cursor and place it into the called form's memo field.
>
>Also, another thing I could use help on is a method that allows the system to check at intervals to see if new messages are present. And if there are new messages to popup a form/messagebox to indicate there are new messages in the system. Please help. Thanks!
The first part of your question should be easy enough to do. YOu create a reply cursor and populate the fields with data from the email cursor. The crsEMail.FROM data goes in the crsReply.TO field. You copy the subject plus tack on a "RE:" to the beginning for the crsReply Subject field, etc.
You would need a timer on the EMail manager form to check for new messages. Then you have a User option to set how often to check for new messages.
How would this work? I certainly would not have the app scan the entire table of messages looking for new email for a specific user. I would have a flag in your EMail users table [1 record per user] that indicates if new mail is available. When a user sends a new message or a reply to someone, I would set the flag for the RECIPIENT user to TRUE when the other user clicks the SEND button. It would then be up to the user to click a GET NEW MAIL button.
You would also need a flag field in the email table to indicate which messages are new and which ones have been retrieved by the user.
Mark McCasland
Midlothian, TX USA