[AccessD] Re: An Easy Fix . . .

Robert L. Stewart rl_stewart at highstream.net
Tue Jan 20 12:48:26 CST 2004


Personally, I hate reinventing the wheel when the one we have works 
perfectly well.

The problem is that the new version switchboard uses ADO and the older one 
uses DAO.  That is why renaming the menu items table and the current 
switchboard form allows it to be recreated with the ADO code.  Then you can 
either delete all of the code from the old form and paste in the new or 
modify the new form.  Deleting the table and renaming the original back 
allows you to keep all the previous menu options.  That is why Charlotte's 
method of handling it works.

Robert

At 12:00 PM 1/20/2004 -0600, you wrote:
>Message: 11
>Date: Tue, 20 Jan 2004 12:00:03 -0500
>From: "Heenan, Lambert" <Lambert.Heenan at AIG.com>
>Subject: RE: [AccessD] An Easy Fix . . .
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <8B98F8EA48F8BA47A2F24E0D0AF40CF407AD7CFD at xlivmbx12.aig.com>
>Content-Type: text/plain
>
>Is this another example of why I find switchboards a PITA. I never use the
>stupid things myself. I prefer to create my own "opening form" with all the
>buttons on it put there by me, so I know (at least in theory) what the
>stupid code behind the form is doing.
>
>Lambert
>
> > -----Original Message-----
> > From: Charlotte Foust [SMTP:cfoust at infostatsystems.com]
> > Sent: Tuesday, January 20, 2004 11:39 AM
> > To:   Access Developers discussion and problem solving
> > Subject:      RE: [AccessD] An Easy Fix . . .
> >
> > If this was a wizard-created switchboard, you would be better off
> > renaming Switchboard Items, saving the code to text from the existing
> > switchboard, and deleting the switchboard form.  Then if you start the
> > switchboard manager, it will discover you have no switchboard and create
> > a new one.  If you then delete the newly created Switchboard Items table
> > and rename the old one back to Switchboard Items, you'll have a working
> > switchboard with current code.  At that point, you can add back any
> > specializations you made in the old switchboard, assuming you still need
> > them.
> >
> > Charlotte Foust
> >




More information about the AccessD mailing list