Share via

VBA Code to Unbound Object Frame

Anonymous
2019-02-08T19:09:19+00:00

Hi friends,

How can I Assign a VBA Macro Code to click event pertaining to a picture Copy Pasted on an Access Database Form so as to work like a button?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2019-02-08T19:18:32+00:00

    Hi InAction,

    If this is an unbound object frame (as well as most other controls) you should be able to view its properties and find the On Click event property where you can add code or a macro.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-02-09T06:17:11+00:00

    Finally did find out the trouble. It was simply the property Enabled which was set as No and upon being turned to Yes the object started to work.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-02-08T19:35:57+00:00

    That's what I did buddy but was shocked I couldn't select / click the said image that I had copied and pasted. Despite of clicking the same no code runs even a simple msgbox

    Was this answer helpful?

    0 comments