PC Review


Reply
Thread Tools Rate Thread

Adding extra field to DB results at display time

 
 
Martin Stabrey
Guest
Posts: n/a
 
      18th Oct 2007
I'm displaying the results of from an input form that writes to an Access
DB.
What I'm wanting to achieve is to add an extra display field which shows the
date that the user completed their form input. I'm obviously wanting to do
this automatically (instead of the user having to enter the date in an extra
input field!), but I'm not sure where (DB or Frontpage) or how. Any help
appreciated.

Tx

Mart

 
Reply With Quote
 
 
 
 
Bob Lehmann
Guest
Posts: n/a
 
      18th Oct 2007
Add a column with a default value of Date() - I think that's what Access
uses - to the table. The user won't have to enter anything.

Bob Lehmann

"Martin Stabrey" <(E-Mail Removed)> wrote in message
news:EBFD68E7-9746-4FE2-9314-(E-Mail Removed)...
> I'm displaying the results of from an input form that writes to an Access
> DB.
> What I'm wanting to achieve is to add an extra display field which shows

the
> date that the user completed their form input. I'm obviously wanting to do
> this automatically (instead of the user having to enter the date in an

extra
> input field!), but I'm not sure where (DB or Frontpage) or how. Any help
> appreciated.
>
> Tx
>
> Mart
>



 
Reply With Quote
 
Martin Stabrey
Guest
Posts: n/a
 
      19th Oct 2007
Thanks Bob. Sorry, I'm completely raw at this - do I do that in Fp or
Access? Where do I enter this value as a default.

Mart


"Bob Lehmann" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Add a column with a default value of Date() - I think that's what Access
> uses - to the table. The user won't have to enter anything.
>
> Bob Lehmann
>
> "Martin Stabrey" <(E-Mail Removed)> wrote in message
> news:EBFD68E7-9746-4FE2-9314-(E-Mail Removed)...
>> I'm displaying the results of from an input form that writes to an Access
>> DB.
>> What I'm wanting to achieve is to add an extra display field which shows

> the
>> date that the user completed their form input. I'm obviously wanting to
>> do
>> this automatically (instead of the user having to enter the date in an

> extra
>> input field!), but I'm not sure where (DB or Frontpage) or how. Any help
>> appreciated.
>>
>> Tx
>>
>> Mart
>>

>
>


 
Reply With Quote
 
Martin Stabrey
Guest
Posts: n/a
 
      19th Oct 2007
Bob - got it! Thanks again, you've been very helpful.

Mart

"Bob Lehmann" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Add a column with a default value of Date() - I think that's what Access
> uses - to the table. The user won't have to enter anything.
>
> Bob Lehmann
>
> "Martin Stabrey" <(E-Mail Removed)> wrote in message
> news:EBFD68E7-9746-4FE2-9314-(E-Mail Removed)...
>> I'm displaying the results of from an input form that writes to an Access
>> DB.
>> What I'm wanting to achieve is to add an extra display field which shows

> the
>> date that the user completed their form input. I'm obviously wanting to
>> do
>> this automatically (instead of the user having to enter the date in an

> extra
>> input field!), but I'm not sure where (DB or Frontpage) or how. Any help
>> appreciated.
>>
>> Tx
>>
>> Mart
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
INCLUDETEXT field adding extra carriage return before and after petersk Microsoft Word Document Management 16 16th Nov 2009 04:51 AM
Adding query results to a table field Leslie Isaacs Microsoft Access Queries 2 30th Mar 2006 04:37 PM
Adding database field to results on list.asp =?Utf-8?B?VGhlcmVzYUI=?= Microsoft Frontpage 0 14th Oct 2005 08:41 PM
Adding Extra Data Field in a Chart =?Utf-8?B?SmF5?= Microsoft Access Form Coding 1 7th Oct 2005 07:54 PM
adding form field to database results =?Utf-8?B?U2hhd25h?= Microsoft Frontpage 1 23rd Apr 2004 09:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:00 AM.