The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Document Linking

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Document Linking

Resolved · Medium Priority · Version 2003

ReplyWed 20 May 2009, 14:07Delegate Kwesi said...

Document Linking

How do you link a document to a record?

For upcoming training course dates see: Pricing & availability

ReplyFri 22 May 2009, 09:25Trainer Rajeev said...

RE: Document Linking

Dear Kwesi

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

There is a data type called Hyperlink. You assign the field as Hyperlink and then when you are in eth datasheet view you click on the field and then simply choose Insert > Hyperlink...

You can hyperlink the data value to any web address, Document such as Word, Excel , etc.. or even e-mail.

I have gone through the steps with your colleague, Tara, who attended the course with you so please ask her if there are any queries!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Thu 28 May 2009: Automatically marked as resolved.

Access articles

· Manage Your Macros With Access 2010
· Understanding The Components Of Access
· How To Make Access 2010 Databases Compatible With Access 2007
· It Is Important To Take Care Over Primary Key Assignment
· Understanding Primary And Foreign Keys In Microsoft Access

Please browse our web site to find out more about
microsoft access advanced training and other Microsoft training courses.

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips

I am using the following excel formula in one of my cells:

="USD Balance as at "&DAY(TODAY()) & " " &MONTH(TODAY()) & " " &YEAR(TODAY())

Is it possible to create a function that will fill in the mon..

» Forum post: Date formats in Functions

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions