Office 2007

[Kenln]

I am having problems running my Access program in Office 2007.

I have included two screen prints that give an error message.

The only Select Object I have is

DoCmd.SelectObject acTable, , True

in my 'Starting_Definitions' code.

This is called from the AutoExec macro.

The file is an MDE file and has been working fine. The IT dept is testing the applications to switch the users to 2007 and this occured.

I would really appreciate any help with this one.

Thank you,

 

[JBurlison]

You are not specifying what table to select

 

[Kenln]

This is part of code I got from this forum.

This part of code reads

'Hide the database window
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

I am hiding the database window with it.

What table would I declare and how?

I have been using this code for a while and it has been working well. The only exception before now is when someone had their Macro Security level too high. Office 2007 does not have that option, rather you can define places to run Access from. This is a be/fe database.

 

[boblarson]

Why are you hiding the database window instead of keeping it from displaying in the first place?

 

[boblarson]

There is a setting you can set in the Startup Options. If you are using Access 2007, go to the Office Button, Access Options, Current Database and find display Navigation Pane and uncheck the box.

 

[Kenln]

Well, I am not really sure.

I believe that

    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

does the same thing as [Tools] -> [Startup] and unchecking [Display Database Window]. Is this true?

I got this code here and have always used it.

Do you think this is my actual problem?

 

[boblarson]

I would just uncheck the checkbox and then you don't need the code at all. It is a per database setting so all you have to do is set it once and it is good to go for that database.

 

[Kenln]

I have to publish a new version this week anyway.

I'll try it then. It is important but at this point only the IT dept is running Office 2007 so that gives me a little time to sort this out.

I'll let you know.

Any idea why it did not work in 2007 but works fine in 2003?

Thanks,

 

[boblarson]

I have to publish a new version this week anyway.

I'll try it then. It is important but at this point only the IT dept is running Office 2007 so that gives me a little time to sort this out.

I'll let you know.

Any idea why it did not work in 2007 but works fine in 2003?

Thanks,

Well, possibly because there is no "database window" anymore. It is now the "navigation pane" and maybe the code doesn't refer to that now.