Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sat Jun 10 13:13:30 CDT 2006
Wait 'til it works...:)
Rocky
Karen Rosenstiel wrote:
> Thank you Rocky!
>
>
> 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 10:15 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Two Questions
>
> Karen:
>
> The domain function would be I think:
>
> lngNewIDCode=Dmax("fldDictationID","tblTableWhereTheDictationIDIs") +1
>
> That would generate a new ID one more than the greatest current Dictation ID
> number and it would end up in lngNewIDCode which you'd have to define as Dim
> lngNewIDCode as Long.
>
> If it's a bound form where they're adding the record I'd try it in the
> Before Insert event setting the DMax value to the bound field on your form
> in the table where this dictation ID goes.
>
> Actually, what I'd do is make it a message box first and see if it's
> generating the right number.
>
> Re: the two tables - could you just put in a phone number field and a pager
> field and keep it in one table??
>
> Rocky
>
>
>
>
> Karen Rosenstiel wrote:
>
>> 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
>>
>>
>>
>>
>
> --
> 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
>
>
>
>
--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com