VBA

Resolved · High Priority · Version 2007

Fri 17 Jul 2009, 16:22 Delegate Herbert said...

Herbert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

VBA

VBA SHORTCUTS

Mon 20 Jul 2009, 09:31 Trainer Stephen said...

RE: VBA

Hi Herbert

Thank you for your question

Could you please expand on your question. Are you looking for quick ways to enter code into your VBE, a guide to the various object models, or best practice for coding in VBA

Thanks

Stephen

Mon 20 Jul 2009, 09:36 Delegate Herbert said...

RE: VBA

Hi Stephen,

I am looking for quick ways to enter code into VBA, a guide to the various object models and best parctice for coding in VBA.

Thanks
Herbert

Mon 20 Jul 2009, 13:46 Trainer Roy said...

RE: VBA

Herbert,
There are lots of online resources, but the Microsoft MSDN library is the place to start.

Here's a link to a VBA Programmer's Guide:
http://msdn.microsoft.com/en-us/library/aa141393 (office.10).aspx

and here's some Access-specific material:
http://msdn.microsoft.com/en-us/library/dd941292.aspx

Basically, have a look around the whole library. Don't worry about which version of Office it relates to - as far as VBA is concerned it's all pretty much the same from 2000 onwards.

There's example code in this library, and much else available out on the web. Just Google "Access VBA" plus something specific, and you'll probably find what you want.

/Roy

Mon 20 Jul 2009, 13:48 Trainer Roy said...

RE: VBA

Note that the first URL hasn't linked properly because of the brackets.

Mon 27 Jul 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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