Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Dragon Naturally Speaking

	98.1 % recommend us
	More live stats...

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Dragon Naturally Speaking

Resolved · Low Priority · Version 2007

Reply Tue 7 Dec 2010, 15:43Delegate Jo said...

Jo has attended:
Access VBA course

Dragon Naturally Speaking

does Dragon work with Access VBA

For upcoming training course dates see: Pricing & availability

Reply Mon 13 Dec 2010, 10:35Trainer Simon said...

RE: Dragon Naturally Speaking

Hi Jo,

Thank you for your question and welcome to the forum.

As far as I can determine, Dragon Naturally Speaking works with all Office 2007 products.

I have read through a few forums and there does seem to be a few issues.

I hope this helps.

Regards

Simon

Access articles

· How To Understand Access As A Relational Database
· Repetitive Tasks? Let Access Do The Hard Work For You
· How Access Can Provide The Key To Successful Stock Management
· How To Use The New Total Feature In Microsoft Access 2007/10
· Want to Become the Office Hero? MS Project Training Could be the Answer

Please browse our web site to find out more about
access courses 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