Interesting problem: looking for Access solution. Can you help?

  • Thread starter Thread starter Michelle M
  • Start date Start date
M

Michelle M

Hi

Using Access2003 with a Front End on each machine (all running Windows XP
Pro) with a backend placed on the server of the peer to peer server.

Situation: Taking information from an outlook message and storing it in
temporary back-end table for user to manually select when to process the
temporary records. Process will empty temporary table.

Only one machine gets the outlook messages and therefore the initial
processing of putting info into temp Access tables happens at this point.

I want to :
1. do XXX to notify all users that there are temporary records to be
processed. XXX - some action which I am looking for answers for.
2. Once the temporary records have been processed, turn OFF/ change state /
something on each users machine to know that processing has been done. I
don't want the notification to be too annoying, but something that when they
open / re-activate their front end, if the processing has been done the old
messages / whatever are not there.

Suggestions please:
I have thought that disabling/enabling a menu option from their customised
menu would be handy, but it has to be quite noticeable. I'm not sure if
this is possible even.

TIA for your help

Michelle
**Please only reply to newsgroup**
 
Create a table in your BE with a Boolean True/False field,
you could add an autonumber ID might be usefull later.

When the FE starts, in your initialisation code check to see
if this is the Outlook machine. If so then do whatever and
set the value in the new table True if stuff awaits
processing. Always check to see there is only one record in
the table, DCount() in an If Then would do that.

Now check the table and if it's true use a MsgBox or open a
small form with only an OK button on to tell users that
there are messages awaiting processing.

When messages have been processed set the table value to
False.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/ Download Free Copy

In Michelle M typed:
 
Thanks Nick for your suggestion, looks good!

I have a question: when the BE table value read TRUE, a message alerting all
the users that there is stuff to process. Will the message still be present
on the other machines if someone goes ahead and processes those records. Is
there a way of removing that previous message to the other users as now the
processing has already been carried out?

Thanks
Michelle
**Please only reply to newsgroup**
 
Back
Top