LAN Network!

[NickUK]

OK, i work in a call center - we have to log all of the calls by putting a tick in the correct box on a piece of paper...then count them up and put the total in an Excel spreadsheet. Is it possible to have so everyone can have Excel open...click the correct send button (as oppose to ticking a sheet) and have it all sent (Real Time) to one main Excel Database? Just wondering if this is possible? If not i'm going to have to write a program to do it (this will be annoying and hard) as it will have to be set up as a database and be linked over a network!

 

[Legacy 98055]

Yes
This should not be a problem at all.
I would duplicate your form on a worksheet,and when the choice is clicked, have the data saved to a common shared folder in a recordset, and have the worksheet refresh automatically for the next call. You would need to have an undo type function for this process.
Tom