Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: LAN Network!

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Nick
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •