No reply? obviously nobody reply yet but I can see all your post.
Regarding your question, putting an expression on the control source is just
for viewing purpose and it will not save to your table not unless you will
reference the value to the actual field when saving.
What you can is, put the expression on the after update event of DateServed.
if not isnull([DateServed]) then
me.DateDue=DateAdd("d",+21,[DateServed])
else
me.datedue=null
end if
hth,
george
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of hvadney
Sent: Wednesday, October 25, 2006 3:58 PM
To: [email protected]
Subject: [ms_access] Expression Results to Table
Hi, everyone:
I was wondering why I had received NO responses to my question and I
now see why: my messages are not appearing on the list. Any clues
why that may be?
Anyway, I am still having trouble getting my Expression field
results to enter in my table from the form, where the results appear
fine.
Here's my original question again. Thanks for any help you can
provide!
*********
Hello, everyone:
Small problem in my DATEADD expression in Access.
I have set up the expression:
=DateAdd("d",+21,[DateServed])
Where DateServed is the date to which 21 days is to be added to
obtain the value for DateDue.
When typing the dates into the form the expression works perfecty.
I have another expression DateDiff:
=DateDiff("d",[DateDue],[DateReceived])
which works in the form and returns the difference between the date
due (DateDue) and the date received (DateReceived). It works fine in
the form.
My problem is that it does not appear in the table in the respective
DateDue and DateReceived columns.
Note:
In Properties Data--Control source, the expression appears. When I
click the down arrow to select the field into which the data is to
be stored it shows the expression.
If I select the field, the field appears in the expression builder
window.
In other words, if in Properties--Data--Control Source -- I select
in Control Source (down arrow) the field into which the data is to
be inserted, I lose the expression (the fieldname then appears in
the expression builder as well); if I don't select the field but
insert the expression into the box or use the expression builder, I
lose the field name into which the data is to be inserted and the
data is not inserted into the table but it works in the FORM!
Any ideas why the data is not getting to the Table?
Thanks,
Harold
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
