Saving the file to different formats

[Jamesstrange]

Hi,
I have created a database in office 2007, however i need to be able to use
it on a computer with an older version (office xp). However whenever i save
it in the format all the buttons in the forms don't work.

 

[John W. Vinson]

Hi,
I have created a database in office 2007, however i need to be able to use
it on a computer with an older version (office xp). However whenever i save
it in the format all the buttons in the forms don't work.

A2007 has a new macro engine that did not exist in AccessXP. If you build
buttons using the wizard, they'll use the new macros... about which AccessXP
knows nothing.

You'll need to rebuild the buttons to use VBA code rather than macros.

 

[Jamesstrange]

Hi, is there a quick or fairly simple way of doing this

 

[John W. Vinson]

Hi, is there a quick or fairly simple way of doing this

I'm not sure, since I don't have 2007 installed. In 2003 and earlier there was
an option on the Macro window to convert a macro to code. It didn't generate
very GOOD code but it at least ran and AFAIK performed the same operations.
Check to see if that conversion is still available in 2007.

 

[Linq Adams via AccessMonster.com]

I don't run 2007 either, but I read yesterday that if you place the file in a
"trusted" location, as you need to if you want to run VBA code in 2007, that
the button wizard then creates buttons using code rather than the embedded
macros. Don't remember who posted this, but at the time I recognized them as
being someone whom I trusted in making the statement.