Karen Rosenstiel
karenr7 at oz.net
Sat Jun 10 09:47:27 CDT 2006
I am making a database to track the dictation information on about 2,500 medical staff. This is to track and assign dictation ID codes so they can dictate medical records into the online dictation system for transcription. 1. The dictation ID code is 5 digits long. It has to be unique and increment by 1 each time I add a new staff person's data. (And no, it is not the PK -- that much I know!)How to? 2. I have a couple thousand of these records in a really crummy Excel spread sheet that needs a lot of cleanup. I can suck the data right straight into an Access table, but if I want to split off a sub table for the phone numbers and a few other fields, what are the steps to do that? Is there any online documentation about it? TIA Regards, Karen Rosenstiel Seattle WA USA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Reardon-Taylor Sent: Friday, June 09, 2006 10:42 AM To: accessd at databaseadvisors.com Subject: [AccessD] Electronic Signature Hi Everyone Just a general question. I have a deployed database with a back-end on a server in Access and the front end as an executable. My customer uses this application as a Work Order database for my services as well as other work orders for other vedors. The application e-mails me a work order when they want something done, we then get the work order signed when the work is complete. This paperwork drives me nuts. I'd like to take a pda with the e-mailed work order on it, sign it electronically myself, and have them sign it electronically as well, then store an electronic copy on both their system and mine. Has anyone done this? Julie Reardon-Taylor PRO-SOFT OF NY, INC. 44 Public Square Suite #5 Watertown, NY 13601 Phone: 315.785.0319 Fax: 315.785.0323 www.pro-soft.net NYS IT Services Contract CMT026A NYS Certified Woman-Owned Business -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com