[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