Where to find list of Method and functions for ACCESS

Question

Hello everyone,

I'm currently tring to create a ACCESS database for my own home.

I would like to find a list of methods and functions in order to learn how to program in VBA, for several little functionswhat i would like to do.

For exemple, i was watching a youtube tuto explaining how to create a calendar and whanted to find documentations according to the method : calendar.MonthNameByDate()

I spent several hours and was not able to find anything. Imagine doing it for every methods ...

I can't understand why there a not any ressourses made to permit others to program from scratch VBA for ACCESS.

I know the basis in C, Mathlab and JAVA. Its always the same, you can learn the basis, and when you have to learn more about functions, objects, methodes, you stay stucked facing the lack of ressourses ...

Do you have this kind of list available ?

Thank-you, Sincerely

Answer 1

The objects and functions can be found here: https://learn.microsoft.com/en-us/office/vba/api/overview/access. See "Object model" from left menu.

The MonthNameByDate is probably a custom function.

Answer 2

Thank-you for your answer,

That is a list of the diffrent visual objects you can use in ACCESS.

I already found it but don't understand in which way it can help using VBA functions.

Thoses visual objects are support for VBA code, so they are linked each other but they are useless alone.

For exemple, placing a button linked to anything have exacly the same function as a remote unpluged to a PS1.

I think it is a big problem, informatic leaguages are made to be loggical, you can find ground objects, methods, functions and keep on learning from ground to the late functions, the more usefulls.

So, if we can't find a list of methods, functions, objects, you can't learn alone, and that means that there is a big big problem.

Microsoft is selling somthing useless, somthing you can't learn how to use. And as you must know, the Office pack is keeping growing and growing in selling price but with little new functions.

So in addition to being uselss, it also keep on being wealthfull... don't you think there is a little probem ???

Thank-you, Sincerely

Answer 3

MonthNameByDate is a custom function. You can't expect Microsoft to document that.

The secret video, you watched, probably also carries some links - to code or a demo, or at least to the author.

That said, the function is so simple, that you don't need; it holds this expression only:

MonthName = Format(TheCalendarDate, "mmmm")