Access 2007 problems 1

[cayden2007]

All,
I recently purchased Office 2007. I have created a Access database using 2003. I have VB code throughout this database.

I installed Office 2007 and tried to bring up my database and it conked out on me.

It gave me some error message, but I could not open the database and I have forgotten the error message.

Has anyone had any problems opening a access database done in an older version in the new access 2007 version?

Does anyone know how this can be fixed?

Any help would be appreciated.

 

[Remou]

It seems likely that you have not 'self certified' your database with a trusted certificate. Access 2007 will not run code that has not been certfied. However, an error message would help: "I have forgotten" is not really satisfactory.

 

[cayden2007]

I will run Office 2007 again and come back with the error message.

Sorry about that.

 

[cayden2007]

I had to load Office 2007 again, because I took it off

Here are my problems:

1. Open the database and I get this: An error occurred while loading 'Form_frm_SearchForm'. Do you want to continue loading the project.

2. I then say Yes

3. It gives me a Security Warning area where I can enable content. I do that, but everytime I reopen the database it is disabled again.

4. If I enable it and try to click on a button that has visual basic behind it. I get the same error above. I then click. I then click yes and I get this error: Invalid procedure call or argument.

5. The code behind the button I am depressing is this:
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click


DoCmd.OpenForm "frm_Invoice"
DoCmd.Close acForm, "frm_MainSwitchboard"

Exit_Command1_Click:
Exit Sub

Err_Command1_Click:
MsgBox Err.DESCRIPTION
Resume Exit_Command1_Click

End Sub

Do you know how I would fix this?

 

[Remou]

Have you tried a compile of the database? It seems likely that there is an error in the code for the Invoice form.

In regard to permitting code to run, you will need to create a certificate for yourself:

http://office.microsoft.com/en-us/access/HP010397921033.aspx

 

[Hap007]

Dear Remou,

Thanks for the tip about Signatures, here is a star for you.

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121