How to embed a word file / Calculate age ?

[qadir]

Hi

I'm new to access and have been trawling both online help and forums to try and find out how you can embed a word file within a recordset... so far with no success ! I'm guessing that it's something to do with OLE but the "how to" section is not much use.

My database needs to store a number of word or text files for each user. What I anticipate is that a data entry clerk would "attach" the file within a field and I would then see a little icon to show that an attachment is in place for that particular field. Any user could then double click the icon and hey presto... the word document loads !

An easy to follow explanation and instructions would be most appreciated as I'm still new to both access and programming and am slowly learning the ropes. Be gentle with me

Also, does anyone know how to calculate an age if I am given date of birth ?

Thanks !

 

[BLeslie88]

Age easy...

deduct the birth date from current system date.

from there you can format your response...

look up format() on help or searching through threads.

I would spell it all out for you and give you the code, but it is in these forums, and did you try a search first...???

Often you will find various solutions in diferent threads already posted that will give you a better understanding of what it is you want to do.

 

[qadir]

Thanks for the help on calculating age. It seems quite straight forward !

Now, I just need to figure out the embed file functionality... anybody ?

 

[BLeslie88]

if you didn't get date function...

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])


is another function u can look up.