Create custom functions in Access using VBA

See how easy it is to write your own custom functions in Microsoft Access using VBA. If you can create a complex expression, then you also have the logic to create user-defined function, or UDF.

Insert a module and write VBA code to get get the maximum number or date. Learn how to write a function and return a value. Use this new function in a query.

Explore how dates are handled. See why dates are numbers.

Use the Immediate window (Debug) to get answers to mathematical questions.

Convert a date to a double-precision number and see how date and time are related by multiplying fractional days by 24 to get Hours, and then fractional hours by 60 to get minutes.

Understand how declaring a data type as the variant can be useful

Get on the road to greater productivity by re-using your logic, and utilizing custom functions in VBA.

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!

I look forward to hearing from you ~

have an awesome day,
crystal

[satyabanukil]

Wonderful presentation Madam. Can you make a tutorial on how to build a SUM module or function to get the sum of a column with a given condition. Regards

[dawishes]

thank you very much, helped me with what I needed and showed me syntax for additions I needed to previously found function.

[georgetomeh]

Hello Crystal, have you a web site or e-mail