Re: Converting from 2003 to 2007
- From: "Jeanette Cunningham" <nnn@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 24 Sep 2009 06:59:15 +1000
1. One is when I double click the database file it opens in the mode for
making changes to the structure of the database, like I would see in 2003
holding
the shift key down when double clicking the file. I figure there is a
setting somewhere to take care of that, can you tell me what it is?
Office button | Access options | Current database | Navigation
Uncheck the check box for Display Navigation Pane
2. The other is the switchboard opens to be full screen in size rather than
the
nice little form that encompasses the fields and that's about it. How do I
get this form to come up with the desired size?
Office button | Access options | Current database | Document Window Options
Choose Overlapping windows instead of tabbed windows.
On the form's property sheet, format tab, find the property called Fit to
screen and set it to No.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Linda" <Linda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5EE20CBA-58FA-4F5F-BD40-FAD480579773@xxxxxxxxxxxxxxxx
I had to drill down into your recovery sequence and do the import of the
2003
database to the blank 2007 database. That worked great! Two of the three
databases I did work as always. However, the third (which is the one with
the errors initially) has a couple of quirks.
One is when I double click the database file it opens in the mode for
making
changes to the structure of the database, like I would see in 2003 holding
the shift key down when double clicking the file. I figure there is a
setting somewhere to take care of that, can you tell me what it is?
The other is the switchboard opens to be full screen in size rather than
the
nice little form that encompasses the fields and that's about it. How do
I
get this form to come up with the desired size?
Thanks so much for all your help.
--
Linda
"Allen Browne" wrote:
To locate the VBA errors:
1. Open the code window (Ctrl+G.)
2. Choose Compile from the Debug menu.
This will highlight the first error.
3. Fix the error, and repeat until there are no more errors.
If there are other problems with the database, it may help to walk
through
the steps of this recovery sequence:
http://allenbrowne.com/recover.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Linda" <Linda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F99DF56C-C2D7-485D-9A74-9046ADC34C4E@xxxxxxxxxxxxxxxx
I was trying to follow the Help and How to article from Microsoft
Office
Online to convert my 2003 database to Access 2007. When I Open the
database
I get a message that says an error occurred while loading the form and
asks
if I want to continue loading the project. When I select Yes I get a
message
that says "Invalid procedure call or argument." Selecting OK puts me
in
the
debugger on a line that says:
Private Sub Form_Open(Cancel As Integer)
This is a database that I inherited and must now convert to 2007. I
suspect
there will be a number of VBA errors to work through. Can anyone help
me
get
started with this particular error and can anyone point me in the
direction
of some documentation that might help me get through the migration?
Thanks in advance.
--
Linda
.
- Follow-Ups:
- Re: Converting from 2003 to 2007
- From: Linda
- Re: Converting from 2003 to 2007
- References:
- Converting from 2003 to 2007
- From: Linda
- Re: Converting from 2003 to 2007
- From: Allen Browne
- Re: Converting from 2003 to 2007
- From: Linda
- Converting from 2003 to 2007
- Prev by Date: Write Conflict error (Access 2007)
- Next by Date: Re: Check Box
- Previous by thread: Re: Converting from 2003 to 2007
- Next by thread: Re: Converting from 2003 to 2007
- Index(es):
Relevant Pages
|
