error code 1004, vba trust issues

[interner]

I'm getting a hang up that looks like

macro name...
User Interface : Button_MASTER_NAMES_Sales Data : OnClick : Embedded Macro
action name...
RunCode
error number 1004
arguments...
ExcelExport_MASTER_NAMES(3, [Label_Master Name Output Location].Caption, [Combobox_MASTER NAMES])


From what I've gathered, this is some type of trust issue happening between access and my vba code. I've gone in both access and excel and made pretty much every security setting as low as possible/given all macros the necessary permissions. The "arguments" section above is a little piece of code that runs from an embedded macro via an on-click event. If more information is needed please let me know. This access project was working two days ago grrrrr.

 

[kjv1611]

You can try looking at the trust center settings.

File (2010) or Office Button (2007)
>>Options(2010) or Access Options(2007)
>>Trust Center
>>Trust Center Settings
>>Try looking around in there... I know in Excel, there's an option for trusting the VBA... But I don't see it for Access. You may ned to adjust the other settings in here, though - trusted locations, macro settings, etc..

 

[interner]

problem solved, I changed computers and mapped my network drive to X: instead of Z: and the VBA code didn't reflect this change of location. *Facepalms*

 

[kjv1611]

Yeah, that could do it. Glad you found the issue, and thanks for posting back with the end result, no matter embarrassing or not. We all make embarrassing typos and oversights at times.