Reply to NeoPa

I'm wanting to be able to keep track of an employee's location in our department. Sometimes employees move to different teams, sometimes they move because of a temporary assignment. I'm wanting to be able keep track of their location for emergencies, reports, etc...I have Microsoft tables set up (i.e. tblEmployees, tblEquipment) where I keep track of employees and equipment. The tblemployee table has two fields (i.e....

Hello: I'm wanting to update a Microsoft Access Table automatically with the network computer name and user name as soon as a user logs onto his/her computer. I would like this to happen with minimal disruption to the user. I have read about possibly using the Windows Scheduler or autoexec.bat to open an access database, run an autoexec macro, etc...I already know how to get the network computer name and user name. I'm looking for assistance...

I have created a table driven email notification system which sends emails using outlook to employees depending on if a boolean field (blnEmail) in the email notification table is set to TRUE. I'm wanting to create a tabbed panel with a control that displays all records in the email notification table so that managers can check/uncheck the boolean field (blnEmail) depending on whether an employee should receive email notifications. I'm not sure...

Please see my pseudocode below. I'm attempting to read a text file and find specific text in each string of text that is read. When a string of text is read that has the specific text I'm looking for the Case Statement will not evaluate to True. Is what I am doing possible with the Case Statement? Any Help will be appreciated.

dim strL as String

While not tso.eof

strL = tso.readline

...