Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you attach a VBA procedure to the click of a toolbutton?

Status
Not open for further replies.

ChemistZ

Programmer
Oct 30, 2001
70
US
I was wondering if you can attach a VBA procedure of any type to the click of one of the standard toolbuttons such as Filter By Form? If you can, how?
 
Hi,
If I remeber correctly you can link a button to a function of access. You only have to create your VBA function into a code module and then link this function name to the button you want to use.

Hope that helps!!

Just in case declare your function like :
"Public Function FunctionName()"
Where FunctionName is your function's name. ;)

Salvatore
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top