[AccessD] Two Questions

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




More information about the AccessD mailing list