JGravesNBS
Programmer
I'm using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2
I’m opening/running a Access 2000 FE.mdb with Access 2007 with Custom Menus (no Ribbons) in legacy mode.
I have a Custom Menu Bar, when I select:
Tools, Compact and Repair Database…
It runs:
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database Utilities"). _
Controls("Compact and Repair Database..."). _
AccDoDefaultAction
I’m getting the following error:
Microsoft Office Access
Error: Invalid procedure call or argument (5) OK
This same code has worked OK for years with no error messages on a2k thru a2k3 computers
What does the (5) represent?
How do I recode this so it will run on Access 2000 and Access 2007?
Any thoughts?
Thanks, John
PS: AutoCorrect is off
Reviewed all suggestion and processed all SP1 and all Hotfixes mentioned on:
Allen Brown Tony Toews
11397335
I’m opening/running a Access 2000 FE.mdb with Access 2007 with Custom Menus (no Ribbons) in legacy mode.
I have a Custom Menu Bar, when I select:
Tools, Compact and Repair Database…
It runs:
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database Utilities"). _
Controls("Compact and Repair Database..."). _
AccDoDefaultAction
I’m getting the following error:
Microsoft Office Access
Error: Invalid procedure call or argument (5) OK
This same code has worked OK for years with no error messages on a2k thru a2k3 computers
What does the (5) represent?
How do I recode this so it will run on Access 2000 and Access 2007?
Any thoughts?
Thanks, John
PS: AutoCorrect is off
Reviewed all suggestion and processed all SP1 and all Hotfixes mentioned on:
Allen Brown Tony Toews
11397335