Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Access - VBA
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - Access - VBA
Resolved · Low Priority · Version Standard
Reply
Access - VBA
How do you use VBA that willWhen you click a button it will open another form and close the form you currently have open?
For upcoming training course dates see: Pricing & availability
RE: Access - VBA
LouiseLets say you have a Button called cmdOpenSalesForm on the form called frmProductForm. When you click this button you close the Product form and open the Sales form (frmSalesForm).
The code will be
Private Sub cmdOpenSalesForm_Click()
Unload Me
frmSalesForm.Show
End Sub
Regards
Carlos
RE: Access - VBA
Thank you for your reply. I tried it and it didn't work however after trying a couple of options I have it working by using the following:Private Sub cmdOpenSalesForm_Click()
DoCmd.Close
DoCmd.OpenForm "frmSalesForm"
End Sub
Many thanks
Louise
|
 |
|
» Forum post: Macro recording in Excel |
I have a worksheet with data for the last 12 weeks (this data is grabbed from another worksheet within the same workbook) and charts (which references to the data in this worksheet) that I update weekly. I tried to record a macro so data and charts would ..
