Karen Rosenstiel
karenr7 at oz.net
Mon Jun 12 20:08:43 CDT 2006
Wow, thank you very much! Regards, Karen Rosenstiel Seattle WA USA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Sunday, June 11, 2006 10:13 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Two Questions Hi Karen, 1. It sounds as if you're starting from scratch so here's my suggestions. Create a structure as follows (based on limited info): tblRecord tblDictation tblPhone tlkPhoneType (if needed) Eventually relationships would be: tblRecord 1-2-1 (or 1-2-n) tblDictation tblRecord 1-2-1 tblPhone tlkPhoneType 1-2-n tblPhone tblRecord: fldRecordID;primary key (autonumber) and other general record information tblDictation: fldDictationID;primary key (autonumber), fldRecordID;indexed (foreign key to tblRecord), fldDictation;memo tblPhone: fldPhoneID;primary key field (autonumber), fldRecordID;indexed (foreign key to tblRecord), fldPhoneNumber, fldPhoneExt, and fldPhoneType (foreign key to tblPhoneType) tlkPhoneType: fldPhoneTypeID;primary key (autonumber), fldPhoneType; text. 2. To form the tables from an imported spreadsheet you could: - import the spreadsheet including all fields in the spreadsheet. Then add fldRecordID;primary key (autonumber) and save. Rename the other fields as necessary. - create the structure of the child tables that you want and then use an Append Query to place the data from the main table into each table. Once done you can delete the fields from the main table. It will retain all of the old dictation ID code numbers and start incrementing the new ones that are added. HTH John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Karen Rosenstiel Sent: Saturday, June 10, 2006 9:47 AM To: accessd at databaseadvisors.com Subject: [AccessD] Two Questions 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com