How do you trace back the code in a Microsoft Access Form or switchboard so that I can see precisely the VB code that made it.

I have some code that was built in Microsoft Access 2007 and VB. I need to know if and how you can select a button or area in a form then see exactly what code in the "back end" of the code made it. Is there a way to make sure that all the code that makes the button switchboard item is highlighted so that I know exactly what makes that button....? Does that make sense. I have to add some similar code and need references  Please advise thank you.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

danishaniCommented:
Are you talking about a Switchboard a la Access 2003 style or a Customized Switchboard based on a Form with buttons on it?

I assume it's the last scenario, then you can go to Form Design and then click on one of the buttons, then go to the property sheet on the right side and click on Tab Event, then go to the On Click event. You will see the [Event procedure] next to it. Then click on the three dots ... and you are in the VBE window.

Hope this helps,
Daniel
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Ooops I must be lythargic from working with no sleep. Here is what I would like to be able to do is click on the object in the form and go straight to the "highlighted code that makes up that object. Can this be done. Please advise thank you.
Switchboard-Buttons.png
Form-Buttons.png
0
danishaniCommented:
Ah ok so that is the legacy switchboard, in that case you can look into this thread on how to modify, add or delete items in it:
http://office.microsoft.com/en-us/access-help/create-and-use-a-switchboard-HA001213876.aspx

Well, If you don't like the design/ the look of it then you can create a Form with buttons, labels, images etc. which you have full control over.

Another option is by creating some custom Ribbon menu:
http://www.databasejournal.com/features/msaccess/article.php/3803996/Making-Your-Own-Access-2007-Ribbon.htm

Check also Gunter Avenius website:
http://www.accessribbon.de/en/

Hope this helps,
Daniel
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

peter57rCommented:
The code that creates a switchboard using Switchboard Manager is contained in a wizard so it is not accessible.

 The code created by the wizard to operate the switchboard is all visible in the switchboard form module.  If you can follow it, you are probably in the wrong job - you should be in the security service decoding enemy messages (:-)

Most developers do not use Switchboard manager because of the difficulties in customising it and it  rarely moves succesfully between Access versions.

Switchboard Manager is not part of the default Access UI after A2003 although it can be invoked through code.
0
Jeffrey CoachmanMIS LiasonCommented:
Can you just post a clear graphical example of what you are after here...
(just posting images of button does not really make this any clearer...)
It is still not clear what you are after...

<he code that makes the button switchboard item is highlighted>
Highlighted where?

<so that I know exactly what makes that button>
What makes a button...? what does this mean?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
If you were having to DeBug a VB coded app deisgned in Access you would click a button and the error debugger would take you straight to the code in question and highlight it in yellow. I would think you could click say for instance my form buttons and be able to go right to the code and see what made the button and what was behind it.......I would think maybe I am dreaming.
0
peter57rCommented:
Yes well this is the 'problem' in customising the switchboard.

All the buttons in the switchboard use the same code, as you will see if you look at the properties of any switchboard button.
The click event just calls a general function and supplies the button number as a parameter value.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
That helped thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.