Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

I would like to be able to handle Buttons on an Access2013 Forms with a few lines of VBA code. Can anyone there show me how?A

I saw Briefly, someone Write  VBA code that completely handled the Buttons that opened up new forms, instead of by Wizard. It was far easier to maintain.
0
Frank Vertin
Asked:
Frank Vertin
1 Solution
 
Rey Obrero (Capricorn1)Commented:
place this code in the click event of the button

docmd.openform "nameofForm"
0
 
PatHartmanCommented:
Here's a simplified switchboard with code that you can maintain.  It is based on the original Access Switchboard but has some modifications.  I have other, more extensive versions that use the additional columns in the Switchboard Items table and come with a Switchboard Items table maintenance form but this is a start.

Unlike the original Switchboard, it is not limited to 8 items per page.

It uses themes so if you change the theme of your app, the Switchboard form should adapt or you can colorize it yourself or add a background image.
Switchboard-Simple141022.zip
0
 
Frank VertinAuthor Commented:
This is the solution that is closest to what I wanted. I may have more questions on this, later
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now