By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Map Ext. View Elt. to Conc. View Elt

P: n/a
Hello,
i can't find the way (using Access) to map external view element to a
conceptual view element. I want to have at the ineterface (external
view), the attribute "Age" which should be derived from "Data of
Birth" attribute stored in the Database.

is this done through VB macro? i am not familiar with , could you
explain me the steps to go through or at least a link to a tutorial if
it is the case

Many thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
TonY wrote:
Hello,
i can't find the way (using Access) to map external view element to a
conceptual view element. I want to have at the ineterface (external
view), the attribute "Age" which should be derived from "Data of
Birth" attribute stored in the Database.

is this done through VB macro? i am not familiar with , could you
explain me the steps to go through or at least a link to a tutorial if
it is the case


Wonderful terminology.

If I understand this correctly, you want to display a calculated value.
The calculation should be based on a table field, and you want to see it
in a form.

You can do (at least) two things:

* don't bother with the recordsource of the form; have a calculated
control of which the ControlSource property is set to

=datediff("y",[data of birth],date)

* put this calculation in a query on the table, and base the form on
this query.

Neither way the value is stored (that is good) nor editable (you may be
disappointed--but can you edit a real age, then?)
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.