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 » VBA Procedures

	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

VBA Procedures

Resolved · Low Priority · Version 2007

Reply Thu 16 Dec 2010, 15:50Delegate Manjot said...

Manjot has attended:
Excel VBA Intro Intermediate course

VBA Procedures

What is the difference between a sub procedure and a function procedure?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Dec 2010, 12:07Trainer Stephen said...

RE: VBA Procedures

Hi Manjot

Thanks for your question

In general there are two types of procedure. A function procedure carries out a series of calculations and returns a specific value. Sub Procedures are more general and while they can carry out calculations, they do not return a value

Regards

Stephen

Thu 23 Dec 2010: Automatically marked as resolved.

Access articles

· Manage Your Macros With Access 2010
· Get To Know The 3 As: Access Accuracy Achievement
· An Essential Guide To Using The Northwind Database In Access 2010
· Why consider Access Visual Basic training?
· Data validation in MS Access

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

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips