Originally Posted by
ssworthi
I am creating a simple timekeeping data base for a farm based company. The customer would like to see employee time by entering the last 6 digits of the SS# in a query with all the fields they'd like to see. Currently I am doing a find/replace in an Excel file with employees data and then importing the file through a macro. Instead of reformatting in Excel, is there a way to replace the ###-##-#### format in Access?
Also, for the life of me I can't remember (it's been a while) how to turn off the security warning messages for this macro. It would be the first action of the macro. The macro is for updating the employee table. It clears the old data, brings in the new through delete and append queries. Thanks so much; this is my first post so please bear with me.