MS Access + VBA - OnClick() event error: "Method or Data Member not found"

Question

OBJECTIVE

Create a dashboard for the Marketing team to pull in product information (e.g product, customer, inventory, sales forecasts, etc.) for further analysis.

APPROACH

Access Product, Inventory, and Sales databases.
Create Query to join Product, Inventory, and Sales details.
Create a simple UI for the Marketing team to interact with queried results.

CODE

simple script for the Marketing team to review a table, prior to query execution

Public Sub reviewCatalog()
DoCmd.OpenTable "Table - Active Customer Catalog", acViewNormal
DoCmd.OpenTable "Table - Active Product Catalog", acViewNormal
End Sub

call reviewCatalog() script from a button OnClick() event that is presented in a simple UI/Form

Public Sub reviewCatalog_Click()
Call reviewCatalog.reviewCatalog
End Sub

ERROR

Compile Error: Methor or data member not found

NOTES

When the macro is run independently of a button click, the script runs without error.
I've confirmed that the button assigned to the macro (called "reviewCatalog") is handling an "Event Procedure" for an OnClick event.

QUESTIONS

What is the nature of the error being thrown? Why is it only occuring on the reviewCatalog_onClick() event (as opposed to other, similar buttons & scripts)?

jonplaca · Accepted Answer · 2016-12-14 15:53:51Z

1

Nevermind, I am a dummy.

Due to the similar naming convention of the button name and the macro, MS Access was throwing an error.

I've updated the button name to "reviewCatalogs" (from "reviewCatalog"). After updating the button name and the Public Sub to Public Sub reviewCatalogs_Click(), the script worked.

answered Dec 14, 2016 at 15:53

jonplaca

8274 gold badges17 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Access + VBA - OnClick() event error: "Method or Data Member not found"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related