Solved

MS Access:  How to view details behind Form 'button'

Posted on 2016-08-17
4
36 Views
Last Modified: 2016-08-24
Hi,
A Form was created to import an external file.  I'm able to open the form in design view, how can I see what each 'button' on the form does?  Specifically, I'm trying to see what location the external file is picked up from and what table that file creates.
0
Comment
Question by:Wonderwall99
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 41759578
Click on the control.

Open the properties dialog (alt/enter or View from the menu).

Click on the event tab.

Look for the "OnClick" event.

It will either show a macro name, or "[Event Procedure]".   If the later, click the builder button (...) off to the right.  The VBA editor will open and display the associated code.

Jim.
0
 
LVL 57
ID: 41759585
You also might be interested in a series of articles by Techmommy.  This is the first:

https://www.experts-exchange.com/articles/9490/Introduction-to-VBA-Part-1.html

If you check her profile:

https://www.experts-exchange.com/members/TechMommy.html

She has a number of articles and videos on starting to work with VBA and Access in general.

Jim.
1
 
LVL 36

Assisted Solution

by:PatHartman
PatHartman earned 125 total points
ID: 41759713
Sometimes a picture is worth a thousand words so here is a picture.Click Event
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 125 total points
ID: 41760245
There may also be interaction with other "Code", on the form  (not just button code), ...that might be worth knowing about.
(For example, ...your button might "Call" a function)

You can certainly print out/view all the code while the VBA window is open (see Pat's post above)

You can also use the "Database "Documenter" to view, print, or save all the code on a form:

Database Tools-->Analyze-->Database Documenter
Select your form
Click the "Options" button
Under "Include for form", select : "Code"
Under "Include for Sections and Controls", select: "Nothing"

JeffCoachman
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question