Alerting connected users

[NigelShaw]

I can see easy solutions.

I have a module that will minimize a form. That can be called from the timer and actionef if a new record is found.

Why don't you count the records on your timer and store then in a public variable. When the timer runs, recount the recordset and check it against the public variable. If the recount is greater than the last count, you have a new message. Reset the count and move on.

You have a module in outlook that passes the email to access? If so why can't the module just pass the record to the SQL be directly and then let the other pc's query direct?

Nidge

 

[stillnew2vb]

Hi,

Why don't you count the records on your timer and store then in a public variable. When the timer runs, recount the recordset and check it against the public variable

That's kind of what I am doing by querying whether the Username is "" or Recordset doesn't exist. Seemed simpler that way.

I have a module that will minimize a form. That can be called from the timer and actionef if a new record is found

I have got the minimise effect to work without requiring a module, if forms part of the action if a record is not found.

You have a module in outlook that passes the email to access? If so why can't the module just pass the record to the SQL be directly and then let the other pc's query direct?

I didn't write the code. Darbid ended up doing it for me because I couldn't get my code to work. I also like the idea of being able to manipulate the incoming email in Access VB instead of SQL. I'm lousy at VB. I absolutely suck at SQL.