list of all VBA changes

[Willi]

Hi!

I'm looking for a list of all VBA changes made from Access / Office 2003 to
2007. Best would be a list with "old VBA code <-> new VBA code".

Does a list like that exists? Where can I find it?

thank you in advance!

 

[Rick Brandt]

Hi!

I'm looking for a list of all VBA changes made from Access / Office
2003 to 2007. Best would be a list with "old VBA code <-> new VBA
code".

Does a list like that exists? Where can I find it?

thank you in advance!

Generally when there are changes between ANY two versions it is merely that the
newer version has had some new functions added. One almost never sees a
situation where the way you used to do something has been replaced with a new
way to do the same thing except of course where a new function has made
something that was formerly hand-coded no longer necessary.

Even when a new function makes something easier to do than before the old way
would still work.

 

[Willi]

But there are changes. I'm interested in everything, that won't work any more.
Is there a list?

thanks!

 

[Rick Brandt]

But there are changes. I'm interested in everything, that won't work
any more. Is there a list?

As I said. the list of things "that won't work any more" is ZERO length.
Access 2007 still supports some of the code from Access 2.0.

I develop in Access 97 and convert a copy to 2000. I then distribute to
users with 97, 2000, 2002, 2003, and 2007. All of the code works without
modification.

 

[Willi]

"acCmdImport" doesn't work any more. I found an article that said, that using
components of Office 2007 differs as well.

I won't describe that as 'nothing' but don't know if there are any others...

regards

Willi Eggeling

 

[Rick Brandt]

"acCmdImport" doesn't work any more. I found an article that said,
that using components of Office 2007 differs as well.

I won't describe that as 'nothing' but don't know if there are any
others...

Well, I was unaware of that. Apparently now you have to specify the type of
file and use a different RunCommand argument for each type.

Undoubtedly there are various blogs and articels describing boht thge
"What's New?" and the "What's Broken?" aspects of Access 2007, but I don;t
know of any specifically. Googling on the phrase "What's broken" +"Access
2007" brings up a pretty good list of pages that might give you what you are
looking for.