[AccessD] Two Questions

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






More information about the AccessD mailing list