Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Missing Wizards (Access 2003 SP2)

    I am missing all the form wizards in Access, eg. ComboBox wizard, Option Boxes wizard, etc.

    What do I have to do, is a uninstall / reinstall of Office 2003 required?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    Start by selecting Help | About Microsoft Office Access from within Access, and click the Disabled Items button to see if anything is disabled.
    if that doesn't help. select Help | Detect and Repair.
    If that doesn't help, quit Access and open the Add/Remove Programs control panel. Select Microsoft Office 2003, and click Change.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    Which option under Change should I select?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    First click Add or Remove Components, expand Microsoft Office Access, expand "Default Wizards" (or something similar) and select "Run from My Computer". Then click Update etc.

    If that doesn't help, select the Repair option.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    I go into Control Panel and select Add/Remove programs. I select Microsoft Office 2003, then select Change. There are 3 options then, none of which are Add or Remove Components. Sorry to be a pain about this, I have already tried Repair. and it has not improved it. I have tried Repair from a different location and am about to reboot my machine. I will keep you posted.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    Still no good.

    Where to from here?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    The screenshot below shows the options to select.

    The next step would be a complete uninstall/reinstall of Access 2003, I fear.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    No good again.

    Can you just uninstall/reinstall Access?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    Open the Add or Remove Programs control panel again.
    Select Microsoft Office 2003.
    Click Change.
    Select Add or Remove Features and click Next.
    Clear the check box for Access.
    Click Update.

    To reinstall Access, repeat the above but tick the check box for Access.

    You will need to have the Office 2003 CD available.

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    I did all that and when I reinstalled Access it did not ask for the CD.

    This seems very strange it did not ask for the CD.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    If your PC came with Office 2003 preinstalled, the files needed for installation may have been copied from the Office CD to the hard disk, perhaps in a hidden partition. You can then uninstall and reinstall parts of Office without needing the CD.

    Has your problem been solved now?

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    No, the problem is still here.

    I have no problem with the ComboBoxes as I know how to set these up manually.
    To setup an option group I have copied one from another database.
    To setup a subform or subreport I simply drag it from the database window to the main form or report as required.

    I'm not too worried about the other wizards in form design.

    What is strange is that the other wizards are there, eg query crosstab wizard etc.

    I don't know what else could be done. Thanks for your time and energy Hans.

  13. #13
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    I installed Rick Fisher's Find and Replace at about the same time that the wizards disappeared.

    Could this be a problem. I keep being reminded that I need to pay for this software. Could this be locking them out?

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing Wizards (Access 2003 SP2)

    That is very strange, since the functionality of the Crosstab Query Wizard is provided by the same file (Acwzmain.mde) as that of the forms wizards.
    You might try the following: locate Acwzmain.mde, and rename it to for example Acwzmain.old. Then start Access, and select Help | Detect and Repair. This should install a fresh copy of Acwzmain.mde.
    You could do the same for the other wizard files Acwztool.mde and Acwzlib.mde.

    Sometimes, re-registering DAO helps:
    - In Windows, select Start | Run...
    - Type regsvr32 "C:Program FilesCommon FilesMicrosoft SharedDAODAO360.DLL" and press Enter.

    Probably not relevant, but take a look anyway: You may receive the "Microsoft Access can't find the wizard" error message when you use wizards in Access 2003.

  15. #15
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing Wizards (Access 2003 SP2)

    I could not find acwztool.mde, but I tried everything else but still no go.

    At some stage I will completely uninstall Office 2003 then reinstall it.

    Thanks for your help Hans.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •