Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Dec 2 09:51:09 CST 2004
I'll bet that reference thing inthe report is what's going on. So I moved the contents of that unbound control from the Control Source into VBA code behind the Format event. As for the formatting, I'm using Arial which is about as plain vanilla as it gets. But it's Access - so who knows what's going on? I'll have to take a close look next time I'm at this client site. In the meantime, I just widened the two fields that had the problem and let it go at that. Regards, Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 ----- Original Message ----- From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, December 02, 2004 1:21 AM Subject: RE: [AccessD] Form flickers like hell in A2K3 > The report thing I can't tell, but I believe I had some simular stuff > with sub forms. > But I rarely use this type of reference, I prefer dooing this from VBA, > for better error control. > I recall an issue with daughter/parent ID with sub forms/reports. > In some access version they changed the way it can be used. > > In the older days you could use a fieldname that was present in the > recordset but not necesarily present as a control on the subform/report. > > Now it needs to be present as a control on the form and the control > needs to have (by preference) the same name as the field. > Sometimes when dooing a copy paste the control name is not the same as > the fieldname, causing a link problem between forms. > > For what concerns the layout, this can be due to a classical font > problem between computers. > If you set a specific font on this control, and you move your app to > another computer, which has not the font, your font will be subsituted > with another one that can have a different length... > This can cause your issue, if you notice this on a different computer. > If on same computer, this is probably an Access version thing... > > Greetz > > Erwin > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > - Beach Access Software > Sent: Wednesday, December 01, 2004 3:27 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Form flickers like hell in A2K3 > > Erwin: > > I had a couple of other problems running an A2K app in A2K3. > > I had the contents of a couple of text boxes on a report quit working. > The Control Source for one of them is > "=[Report].rptRASubRpt!txttotaldailyrate" > (picks up the value from a sub-report) and it works fine in A2K but > shows up blank in A2K3. So I moved it to the format event but that's a > kludge. Is this a known bug? > > I also had a couple of dates (mm/dd/yyyy) get cut off on the right as if > the display in A2K3 is bigger than A2K. Another A2K3 bug? > > Regards, > > Rocky Smolin > Beach Access Software > http://www.e-z-mrp.com > 858-259-4334 > > ----- Original Message ----- > From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Wednesday, December 01, 2004 12:17 AM > Subject: RE: [AccessD] Form flickers like hell in A2K3 > > >>I managed to relate most labels to a textcontrol, but have still two >> labels that are not related. >> It is already an improvement because the (whole) form only flickers > when >> moving over these 2 labels... >> >> Erwin >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin >> - Beach Access Software >> Sent: Wednesday, December 01, 2004 6:07 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Form flickers like hell in A2K3 >> >> Marty: >> >> Thanks for the heads up on this. Just came across this today at two >> customer sites where they put my A2K app on an A2K3 machine and the >> flash was really annoying. I tried a couple of things but no soap. >> I'll walk them through this tomorrow . >> >> Rocky Smolin >> Beach Access Software >> http://www.e-z-mrp.com >> 858-259-4334 >> >> ----- Original Message ----- >> From: "MartyConnelly" <martyconnelly at shaw.ca> >> To: "Access Developers discussion and problem solving" >> <accessd at databaseadvisors.com> >> Sent: Tuesday, November 30, 2004 10:26 AM >> Subject: Re: [AccessD] Form flickers like hell in A2K3 >> >> >>> You ain't gonna believe this but if running WinXP change your theme >> by >>> right-clicking your Windows XP desktop, choosing Properties, and >> setting >>> the Theme to "Windows Classic". >>> If you cannot solve it by deselecting Use Windows Themed Controls on >>> Forms under Tools | Options | Forms/Reports in Access 2003 >>> The flickering or flutter goes away on my machine using Win XP Theme >>> Classic Access 2003 and by deselecting above option >>> The flickering is triggered by unattached labels on the page of a tab >>> control. The workaround is to convert these labels to text boxes. >>> For non english speakers I found this by searching on Screen Flutter >>> rather than Flicker. >>> >>> For full explanation. and code to correct all forms if above tools >> option >>> method doesn't work >>> http://members.iinet.net.au/~allenbrowne/ser-46.html >>> >>> Erwin Craps - IT Helps wrote: >>> >>>>Can anyone tell me why the form in this database flickers like hell >> when >>>>moving over the green zones or labels. >>>>This only in A2K3, same database same form, does not flicker in >> A2K2.... >>>> http://www.ithelps.be/temp/test.mdb >>>> greetz >>>> >>>> >>>>Erwin Craps >>>> >>>>Zaakvoerder >>>>www.ithelps.be/jonathan >>>> >>>> >>>>This E-mail is confidential, may be legally privileged, and is for > the >>>>intended recipient only. Access, disclosure, copying, distribution, > or >>>>reliance on any of it by anyone else is prohibited and may be a >> criminal >>>>offence. Please delete if obtained in error and E-mail confirmation > to >>>>the sender. >>>> >>>>IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg >>>> >>>>www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be >>>><http://www.boxoffice.be/> * www.stadleuven.be >>>><http://www.stadleuven.be/> >>>>IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven >>>> >>>>IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: >>>>Info at ithelps.be >>>>Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: >>>>Staff at boxoffice.be <mailto:figures at boxoffice.be> >>>> >>>> >>> >>> -- >>> Marty Connelly >>> Victoria, B.C. >>> Canada >>> >>> >>> >>> -- >>> _______________________________________________ >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >> >> -- >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> -- >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >