Application CreateForm method

Application CreateForm method and VBA Access

Microsoft Access , on the other hand, is made to store and manage vast quantities of data in a form that makes it easy to retrieve and use in different applications. While Excel user’s type directly into their spreadsheets, Access databases are manipulated with pre-made forms and queries. Most businesses also connect Access to other applications, so when those other apps generate data, it is automatically ported over to Access

Forms: Database developers often create forms that allow users to enter information into the database without using a spreadsheet. By avoiding the need to enter data in a spreadsheet-like table, there is much less chance for data entry error

What is VBA-Microsoft Access?

VBA stands for Visual Basic for Applications (the application being of course Microsoft Access) and is the technology and tools used to program and automate this application

It’s not only used just within the framework of Microsoft Access Database but other applications too including Microsoft Excel, Microsoft Word, Microsoft Outlook to name a few.It has the power to communicate with other applications beyond the Microsoft range and even the Microsoft Windows operating system across other platforms.So, learning the principles of VBA using Access as the tool environment will stand you in good stead for the other applications should you wish to program and code them in the future.The only difference between other applications when wanting to use VBA will simply be learning to load and work with different libraries.Typical reasons why you would use Microsoft Access VBA include being able to:

1.Manage smaller re-usable procedures (globally).

2.Create you own defined functions

3.Hold variables in memory (globally).

4.Attach code to an event i.e. a button on a form.

5.Manage more powerful procedures that an Access macro lacks

6.Communicate with other applications and platforms

7.Gracefully handle errors (when they happen).

Application.CreateForm method

The CreateForm method creates a form and returns a Form object.

Syntax

expression.CreateForm

Name	Required/Optional	Data/Type	Description
Database	Optional	Variant	The name of the database contains the form template that you want to use to create a form. If you want the current database, omit this argument. If you want to use an open library database, specify the library database with this argument.
form template	Optional	Variant	The name of the form that you want to use as a template to create a new form.

You can use the MousePointer property together with the Screen object to specify or determine the type of mouse pointer currently displayed.

style

expression.MousePoint

Settings	Description
0	(Default) The shape is determined by Microsoft Access
1	Normal Select (Arrow)
3	Text Select (I-Beam)
7	Vertical Resize (Size N, S)
9	Horizontal Resize (Size E, W)
11	Busy (Hourglass)

Please Watching My Video is Below

Design by Vannak Vannaro