Prev: MS Access Table Design Look Up???
Next: Help... .. Deciding one to many or many to many.. Type..
From: Flopbot on 24 Apr 2010 11:12
I know this might seem technically wrong and therefore, I haven't found
advice on how to do it on these postings. I have an Access 03 table
“EventTable1” with fields “StartTime” and “EndTime”. These times are the
actual times of our events. I have another table “StaffTable1” with fields
”ActualStartTime” and “ActualEndTime”. I want to track all these times in
the table and want the actual start/end time fields to default to the
start/end time fields. Many times they'll be the same, but sometimes they
won't. Any simple ways of doing this using the default value in table design?

Thank you!
From: PieterLinden via AccessMonster.com on 24 Apr 2010 13:15
Flopbot wrote:
>I know this might seem technically wrong and therefore, I haven't found
>advice on how to do it on these postings. I have an Access 03 table
>“EventTable1” with fields “StartTime” and “EndTime”. These times are the
>actual times of our events. I have another table “StaffTable1” with fields
>”ActualStartTime” and “ActualEndTime”. I want to track all these times in
>the table and want the actual start/end time fields to default to the
>start/end time fields. Many times they'll be the same, but sometimes they
>won't. Any simple ways of doing this using the default value in table design?
>
>Thank you!

Do it in the form. You can set the defaults using a function or dlookup.

--
Message posted via http://www.accessmonster.com

From: Flopbot on 29 Apr 2010 19:53
Thank you for your suggestion about DLookUp! In case anyone else has this
problem and is following along, I asked a related question called “DLookUp
Format” posted on 4/28/2010 at:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access.forms&mid=7ffd8a5a-24f4-4087-aa4f-a979f6c51058

So far, I'm still looking for an answer, but this post got me closer!


"PieterLinden via AccessMonster.com" wrote:

> Flopbot wrote:
> >I know this might seem technically wrong and therefore, I haven't found
> >advice on how to do it on these postings. I have an Access 03 table
> >“EventTable1” with fields “StartTime” and “EndTime”. These times are the
> >actual times of our events. I have another table “StaffTable1” with fields
> >”ActualStartTime” and “ActualEndTime”. I want to track all these times in
> >the table and want the actual start/end time fields to default to the
> >start/end time fields. Many times they'll be the same, but sometimes they
> >won't. Any simple ways of doing this using the default value in table design?
> >
> >Thank you!
>
> Do it in the form. You can set the defaults using a function or dlookup.
>
> --
> Message posted via http://www.accessmonster.com
>
> .
>
 | 
Pages: 1
Prev: MS Access Table Design Look Up???
Next: Help... .. Deciding one to many or many to many.. Type..