John Bartow
john at winhaven.net
Thu Dec 18 11:24:38 CST 2003
Hi Rocky, I had a wierd problem with a form (A97) this year. It would try to load a shortcut menu for the section that wasn't designated. This would generate a wierd error. (It took me quite a while to figure out what was even doing it.) Eventually, after trying eveything under the sun to figure the problem out, I had to cut and paste all controls and code into a new form. It was a fairly complicated form but that actually only took about a half an hour or so to do. (Because I like to know the reason behind problems I had spent at least two hours trying to figure it out before that-to no avail.) So, in short, my advice is to try this. If you haven't tried it yet, rename the original form, copy and paste everything into a completely new form and try it out as normal. If you have sub forms you may have to do the same thing with them. If it doesn't jump around then you probably have some undetectable baggage hanging around. Another issue that doesn't make any sense (to me anyway) is that sometimes if I go in and manually set the subforms links (for static subforms) in the property sheet it clears up issues. It doesn't make any sense to me because I don't seem to ever have a problem changing subforms and linking via code. You might also try opening the db with the decompile switch, closing the db, reopen it in normal mode, compact the db and then create an mde without first compiling the mdb. HTH John B. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of A.D.Tejpal > Sent: Thursday, December 18, 2003 10:35 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Jumping Forms > > > Rocky, > > Can it now be said that the design & code of this form does > no longer have any obvious distinguishing feature as compared to > other forms in your database, which do not jump. > > If so, could you kindly experiment by reducing the design > height & width of this form significantly and check the outcome? > > If still no success, are you in a position to send zipped > extracts of mdb & mde files containing the problem form? > > Regards, > A.D.Tejpal > adtp at touchtelindia.net > ---------------------------- > ----- Original Message ----- > From: Rocky Smolin - Beach Access Software > To: Access Developers discussion and problem solving > Sent: Thursday, December 18, 2003 21:30 > Subject: Re: [AccessD] Jumping Forms > > > Mark; > > I took all of the code out of one of the menus except for the > .close and a > .OpenForm to another form. When I return to that menu from the > form I get > the 'jump'. So it appears that it's not due to any code. > > Another clue: It doesn't happen in the MDB, only in the MDE. > > Any other ideas? > > TIA > > Rocky Smolin > Beach Access Software > > ----- Original Message ----- > From: "MarkH" <lists at theopg.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Wednesday, December 17, 2003 11:25 AM > Subject: RE: [AccessD] Jumping Forms > > > > try putting a break in the start of the forms got focus event and step > > through to see what happens... Does it jumpt befor the got focus event > > starts for example? > > > > hth > > > > mark > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin > > - Beach Access Software > > Sent: 17 December 2003 19:12 > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Jumping Forms > > > > > > Dear List: > > > > Further testing shows that when I comment out the two lines: > > > > Call adhScaleForm(Me, 640, 480, 96, 96, rctOriginal) > > DoCmd.Maximize > > > > I still get the 'jump' when the form gets the focus. So it > doesn't have > > to do with ScaleForm or Maximize. > > > > Rocky > > > > ----- Original Message ----- > > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > > To: <AccessD at databaseadvisors.com> > > Sent: Wednesday, December 17, 2003 9:08 AM > > Subject: [AccessD] Jumping Forms > > > > > > Dear List: > > > > I have an app which uses the form resizing from the ADH and > > DoCmd.Maximize in the _Open event: > > > > Call adhScaleForm(Me, 640, 480, 96, 96, rctOriginal) > > DoCmd.Maximize > > > > As an MDB - no problem. But when I make an MDE the form > 'jumps' if it's > > already open and gets the focus. IOW, if I'm at a menu and > go to a form > > from the menu, the target form does not jump, but I leave the > menu open. > > Then when the user closes the target form and the menu, which > is already > > open gets the focus (Activate event is triggered but not Open > event, and > > I have no suspicious code in my activate event), I get that extra > > 'jump'. > > > > Doesn't disrupt the operation of the program but it's irritating. > > > > Has anyone seen this behavior? Any known fix? > > > > MTIA, > > > > Rocky Smolin > > Beach Access Software > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >