General Question about Access 2007

[jukus]

I have a database that works fine on access 2000. The problem is that when I open it in Access 2007 the switchboard does not display correctly and my command buttons do not work. Also, my field that autofill from a combo box do not fill in. I am assuming that access 2007 does not recognize the code for all of these. If this is the problem does anyone know of a reference that can be used to change the code to work.

Also, thought I would mention that I opened it in Windows Vista. I have read about problems with Vista. I have not tried opening the database on a computer running XP.

Just wanting to get working now in case my company changes over to Office 2007 in the future.

Thanks for any info.

 

[boblarson]

You need to do this:

http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[jukus]

Worked like a charm. Thanks. I never noticed that button before.

Does that have to be clicked every time or just once. Thanks again

 

[boblarson]

Worked like a charm. Thanks. I never noticed that button before.

Does that have to be clicked every time or just once. Thanks again

If you follow the rest of the instructions for setting up a trusted location you won't need to do that each time.

 

[jukus]

Got it working. Thanks a lot. Greatly appreciate the help.

 

[Jethro]

Thanks. That worked for me too. But Im still having a problem with the switchboard. I tried to create a second switchboard. The main one has my data entry keys and I wanted to create a separate one for my reports. When I click on the reports button on the main page it opens a blank switchboard. If I make the reports switchboard the default one, it works fine on its own. Any idea what Im doing wrong?
Thanks

 

[Jethro]

Anyone have any ideas on this?