How can I create new forms or any other objects only from code?
I have seen somewhere, that this can be done by using New keyword, but I don't know how exactly it works.
This is what I have so far:
Dim form2 As New Form1
This creates new form which looks like form1, but I want to create completely new and empty form.
Can I create an array of forms? form(0), form(1), form(2) . . .
How do I change properties of new forms? My example gives 'Object Required' error when I try: form2.caption = "abcdefg"
If possible, can you give me code example that would do the following:
- create 2 new empty forms, and display them
- change caption for first form
- create button on second form
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.
What are they?
An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…