This office is converting to Office 2007. I have been asked to convert a
current Access 2003 Application scheduling volunteers into something
compatible with Office 2007. I have been given a virtual machine with the
application loaded. I do not have any idea how to look at the VBA I wrote,
run diagnostics or step thru the code in Office 2007. Can anyone suggest a
book or web site that covers this topic. I am slightly above beginner
status, so it will have to be fairly basic and step-by-step. As an example,
how do I stop execution at the Current Event for my main page. Something is
not computing there.

EarlCPhillips
Ex-mainframer Learning Access To Improve The
Efficiency Of The Food Bank In Feeding The Hungry
--
Trying To Feed The Hungry

Access 2007 can open/run access 2003 mdb without issue. Simply run your db
and see what happens. In general I have had no issues running older db 2000
& 2003 on 2007.

Just try it. Don't look for work, where there may not be any.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"EarlCPhillips" wrote:

> This office is converting to Office 2007. I have been asked to convert a
> current Access 2003 Application scheduling volunteers into something
> compatible with Office 2007. I have been given a virtual machine with the
> application loaded. I do not have any idea how to look at the VBA I wrote,
> run diagnostics or step thru the code in Office 2007. Can anyone suggest a
> book or web site that covers this topic. I am slightly above beginner
> status, so it will have to be fairly basic and step-by-step. As an example,
> how do I stop execution at the Current Event for my main page. Something is
> not computing there.
>
> EarlCPhillips
> Ex-mainframer Learning Access To Improve The
> Efficiency Of The Food Bank In Feeding The Hungry
> --
> Trying To Feed The Hungry

On Mon, 8 Mar 2010 13:34:01 -0800, EarlCPhillips
<(E-Mail Removed)> wrote:

>This office is converting to Office 2007. I have been asked to convert a
>current Access 2003 Application scheduling volunteers into something
>compatible with Office 2007. I have been given a virtual machine with the
>application loaded. I do not have any idea how to look at the VBA I wrote,
>run diagnostics or step thru the code in Office 2007. Can anyone suggest a
>book or web site that covers this topic. I am slightly above beginner
>status, so it will have to be fairly basic and step-by-step. As an example,
>how do I stop execution at the Current Event for my main page. Something is
>not computing there.
>
>EarlCPhillips
>Ex-mainframer Learning Access To Improve The
>Efficiency Of The Food Bank In Feeding The Hungry

The "Ribbon" is a drastic change to the user interface for us developers, and
it does take some getting used to! But a 2003 application should run just fine
in 2007, if you do the right tweaks. For one thing, the database must be in a
folder which Access recognizes as a "Trusted Location".

Allen Browne has compiled a very useful page on the subject:

http://allenbrowne.com/Access2007.html
--

John W. Vinson [MVP]