This is a major problem as I am unable to open other related forms or reports. I am updating a database with a new design. The old database works fine until I try to redesign it and then all links, navigation buttons cease to function. I have tried most things including re-installing Access 2007 but I am unable to get the wizard to work. With forms it only displays the form I want to open in the right pane. The left hand pane is blank. With reports no list is displayed. Can somebody assist?
Hi
I have the same problem. Removing and reloading Access 2007 … been there… done that… to no avail.
My solution is to edit the VBA created by the wizard … view all records …and add the link criteria myself to the VBA
stLinkCriteria = “[FieldName]=” & “” & Me![FieldName] & “”
I stay away from the 2007 macros.
Hope this helps if you continue to have the problem.
Regards
Anne
@Mike (tuquet), I am a middle of the roader with regard to Access 2007 wizards. Some of the wizards are not as good as they were in Access 2003 and so I have copied code created by A2003 wizards into my A2007 environment. A2003 not only placed the right ‘actions’ in code it also added ‘good’ error handling.
I have found that certain other code created by A2007 wizards is OK.
My point is that you may need to change some of the code created by A2007 wizards in order to make them as good as they were in A2003 while other wizards will do the job. For me, this has been a bit of trial and error.
Once you figure out the best code then reuse it and avoid the wizards as Michael Black and Graham Mandeno advise.
BTW, although the macros in A2007 are better than they were in earlier versions of Access I would stay away from them. In the past three years, I have experienced corruption only in A2007 macros. Other things probably caused the corruptions but the macros persist them.
David
I do not know which Michael you are talk to, but my name is Black.
And when one uses wizards, one has to remember that in most instances they are designed to generate a foundation in the simplest format as well as provide rapid development of a application. Personally, I avoid them except in situations where I need a quick prototype to demonstrate a process flow to a user or customer during the requirements and or design phase. And another advantage of these things it to allow someone without any experience to develop an application for self.
Michael B.
Hi Mike
You’re not Michael Browning, are you? If so, you have posted the same question twice on Microsoft Answers. I answered the latest one yesterday and you have not responded except to award the “Answer” to one of my colleagues who basically said “I agree”.
http://answers.microsoft.com/en-us/office/forum/office_2007-access/the-command-button-wizard-does-not-allow-for-a/61862763-4cf6-479a-b7b2-4d7da50d7a67
If you are someone else, then I humbly apologize!
In any case, if your form has a RecordSource with one or more bound controls, then the wizard should work.
If it does not, but the same database conjures up a well-behaved wizard on another computer, then I suggest you uninstall and reinstall Access/Office.
However, this reinforces my notion that Access wizards (particularly the code-generating ones) cannot be trusted and should be avoided - not least because when they DO work, they generate bad code.
Best wishes,
Graham Mandeno [Access MVP 1996-2013]
Further to the earlier e-mail. I have now tried designing this database on another computer without any problem so the problem is something to do with the first computer only which is a bind.
Best wishes,
Mike
Thanks for the reply.
.accdb is the file and yes I have checked “Show hidden objects”.
I have been using access - 2003 version for over 10 years without this problem.
Have you got any other ideas that will work?
Best wishes,
Mike
Are you trying to alter an accde or accdb? Accdb needs to be the answer.
Have you tried to Right Click on the Objects Navigation and then select “Navigation Objects” the check the “Show hidden objects”?
You have been developing MS Access for how long?
