Command button problem

[pjk2008]

Hello all

I have created a form and on that form are 2 command buttons. I have created the VB coding for each of the command buttons, depending on 4 option groups within the form. One button exports the selected option groups to excel and the other into a pivot chart.

This works fine on my PC, however when my colleague attempted to use this the command button to export the data (depending on the 4 selected option group) to excel did not work, ie nothing happended. The pivot chart command button worked fine, but not this command button.

I asked my colleague to check the VB coding via event procedure and this was all correct. We both use MS Access 2003, I have asked her to lower
the macro security settings to low and checked the references window in VB to mirror mine, but still this problem with the command button not firing.

Is there anything else that I need to check or amend?

thanks in advance for your help.

cheers
Phil

 

[KenHigg]

What happens at that line when you step through the code?

 

[boblarson]

If you are using Access 2007, make sure to set a trusted location:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[pjk2008]

Hi Ken

Nowt!! Nothing....

no run time errors, nothing that kicks in the debug facility in VB. Excel does not execute.

I'm stuck.

Phil

 

[pjk2008]

Hi Bob

My colleague and I are both using MS Access 2003.

Would you recommend upgrading to MS Access 2007?

 

[KenHigg]

I would create a blank db with only the code (and other stuff) required to perform this single action and see if it runs. This could narrow things down a bit...

 

[boblarson]

Sorry, I missed the part about you using 2003. See what Ken's suggestion does.

 

[pjk2008]

thanks chaps, will do