A Form is just a Class that you can see. To work with another object, you have to have a reference to that object. Pass a reference to the Form into your class methods. Regards, Phill W.Friday, May 19, 2017 11:00 AMCan you more explain with example ?
TheCloseevent occurs after theUnloadevent, which is triggered after the form is closed but before it is removed from the screen. When you close a form, the following events occur in this order: Unload→Deactivate→Close When theCloseevent occurs, you can open another window or request the user...
my script is not visible anymore in VBA Access I do not have access to my own script anymore which I have made for various Access programs. I have carried out a complete virusscan but nothing detected. When I copy my DB file to another computor I can see my code again. How can I ...
It's seems like a matter of using the right command for doing the right thing or else it creates another instance of the object, so at the end when you close it you're not able to close the second instance. One thing i haven't solved it to sort the worksheet i create from Access...
Perform system-level actionsYou can carry out theRunAppaction in a macro to run another program (such as Microsoft Excel) from within Access, but you can't use a macro to do much else outside of Access. By using VBA, you can check to see whether a file exists on the computer, use...
To open a database object or apply a command to a database object, right-click the object and select a menu item from the context menu. The commands on the context menu vary according to the object type. Open a database object, such as a table, form, or report In the Navigation ...
Close Your Database a Couple of Times a Day VBA dynamically loads code into memory as needed on a module level. If a function is called or a variable is used, the entire module containing that function or variable is loaded into memory. As you are developing your application, you keep lo...
Queries are SQL statements that are saved in an Access database and therefore can be used at any time, either directly from the Access user interface or from the Visual Basic® for Applications (VBA) programming language. Queries can be built with the Access Query Designer, which is a rich...
when a form's Unload event occurs, you can verify that the form should be unloaded or specify actions that should take place when the form is unloaded. You can also open another form or display a dialog box requesting the user's name to make a log entry indicating who used the form....
Same problem. Access is closing whenever I Edit a VBA code. Thanks for your help. It's not clear. Are you thanking the original poster? Or are you asking for help for yourself? If the latter, we need a lot more context before we can offer any suggestions beyond the generic ones. ...