Improve company productivity with a Business Account.Sign Up

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

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

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
Wonderwall99
Asked:
Wonderwall99
  • 2
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
PatHartmanCommented:
Sometimes a picture is worth a thousand words so here is a picture.Click Event
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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