[AccessD] Two Questions

Hi Rocky,
The dictation ID code is up to about 12,386 or something like that. I'm not
at work so don't remember the exact number. So I would want to start
incrementing from there. What's a domain function and where do I put it? Be
gentle -- I'm still pretty much a newbie  ;-)

The reason I wanted to break the table into 2 is because I thought there
might be more than 1 number, but maybe not. The other data is unique, so I
guess this could be too. Basically the provider has an office phone and a
pager that the medical center provides. So all we really need is just 1
number that we could communicate to this provider with. 

I guess I'll just import this table straight across and clean it up. I've
already set up 2 clean tables for their credentials (i.e., MD, Attending;
MD, Resident; Intern etc.)

So thanks on the first part about incrementing.


Regards,

Karen Rosenstiel
Seattle WA USA 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Saturday, June 10, 2006 8:00 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Two Questions

Karen:

For the first one

If a domain function doesn't take too ling to execute can you do

lngNewIDCode=Dmax("fldDictationID","tblTableWhereTheDictationIDIs") +1

Then if you need it to be a 5 digit string:

strNewIDCode=Right("00000" & trim(str(lngNewIdCode),5))

As to the second one that I'd do in code.  Is there more than one phone
number per staff person?  Or will it be one-to-one relationship staff-phone?

HTH

Rocky


Karen Rosenstiel wrote:
>  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
>
>
>
>   

--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com