need help modifying access program

**FDibbins** · 03-22-2013, 04:04 PM

Hi

1 of the members of my department has made a nice little daily reporting system, it works pretty well. 1 of the options he has built into it, is a button to send the report to a number of managers here.

Here's my problem...1 of the managers has resigned and his name needs to be removed from the auto-email button, but the guy that did the programming is now in the army and wont be available for quite some time

To make things even worse, I an not able to share the program because of confidential data that it contains.

I know this is a bit like taking your car to the workshop and saying...its making a noise, but I cant explain what it sounds like, I dont know where its coming from, and I dont know when it happens...

Can any-one offer any guidance on how I could start searching through this thing to try and find where he put the email addresses?

**alansidman** · 03-22-2013, 08:49 PM

Are you able to post the code (VBA) that sits behind the command button for this event. To get to the code, open the form in design view. Right click on the button and select properties. On the Events tab, click on the ellipsis (...) for the on click event to open the VBA window. You should see the code there. It is probably a case of either the email address being hard coded into this vba or it is pulling from a table. Without seeing the code, it will be hard to determine where the code is pulling the email address. This should get you started. Post back with any issues.

Alan

**FDibbins** · 03-22-2013, 10:08 PM

Thanks for the input Alan.

What actually happens is that you run the program (from a desktop shortcut icon). Once this is open, there is an option (button) to create a new daily report. When this option is selected, a whole new window opens, this is where the data for the day's report is entered, and this is where the option to "save and email" the report is located. However, when this window opens there are no menu options.

Hmm I think you got me to where I needed to be without even knowing all the details. I opened the "new report" window, and muddled my way to where (I think) the hard coded email addy's are. I removed the addy, I will be able to check when I do my report tonight

Thanks

**alansidman** · 03-22-2013, 10:14 PM

Good News. Post back if there are issues. If the Access db does not appear to let you get to some of the behind the scenes, then open the db in this manner. Highlight the file in Windows Explorer (this is important). Hold down the Shift key while you click on the Enter key. This disables all the "hidden features" and allows you to see all the Objects. Clicking on the F11 key by itself opens the navigation pane where you can see the different objects.