MS Access 2007 on XP (I know) SP3

[jimlee20]

I am having extreme difficulties and I should not. Simple code that will not work. I can get a call to work or a simple MsgBox to work. If I couple either of them with error code, they will not work. Any ideas? I went into VB, tools and set the error trapping there so it only errors in the object. Here are the two codes:

Private Sub Command16_Click()

On Error GoTo ErrorHandler

MsgBox ("You are here!!!")

ErrorHandler:

MsgBox ("An error has occurred.") & Err.Number & ", " & Err.Description
Resume Next

End Sub

So this code works with just the MsgBox, but as soon as I add the On Error it will not. The code below will not work either:

Private Sub Command16_Click()

MsgBox ("You are here!!!")

Call GetFile

End Sub

As soon as I put the Call function in there my msgbox will not show. I also can not debug the program whatsoever.

There is one issues that may be the cause but I do not know how to get around it. I am on hi security computers what do not allow activex controls to function. I enable the activex feature in Options, but something is telling me that I have to do something else. Anyideas?

Thanks. Jim

 

[jimlee20]

HA! After days of trying to figure this out I finally found the resolution. I had to digitally sign the database with a certificate. Just saying that the application was good to go was not good enough.

 

[jimlee20]

Well, even after digitally signing the program I am still having issues. How many people have heard of SANDBOX configuration in MSOffice? Well that is what they did here. I have to be able to run this program but still having issues. If anyone has any idea about how to get around them without the REGEDIT routine please let me know. I am trying to import an excel file into Access and the flippen import routine that comes with Access will not work for me, I have to write the code. I still cannot get it to work.