Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Thu Dec 2 03:21:04 CST 2004
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