Gustav Brock
Gustav at cactus.dk
Fri Nov 19 09:33:27 CST 2004
Hi Bobby Always use the syntax stated here (one line): http://www.databaseadvisors.com/newletters/newsletter032004/0310ReferenceGuide/SyntaxForSubs.htm Other methods may work (as you have demonstrated) but they are generally not considered good programming practice. "Svar:" is Danish for "Re:". We have moved to a brand new GroupWise 6.5 system (boy, this rocks) and currently I'm running the Danish localisation ... haven't found out yet how to adjust this detail. /gustav >>> bheid at appdevgrp.com 18-11-2004 19:26:38 >>> Gustav, Yes, that works also. Why would I need to put .Report on the end? It already knows it is in the Reports collection? I have never seen anything like that when referencing something on a form either? Is there a .Form for the forms? Also, what is Svar in the subject? Thanks, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, November 18, 2004 12:37 PM To: accessd at databaseadvisors.com Subject: Svar: RE: [AccessD] Control reference question. Hi Bobby What happens if you try? The use of .Report should be the recommended syntax ... /gustav >>> bheid at appdevgrp.com 18-11-2004 17:30:50 >>> I dunno, it works as I have it. I have never used Report on the end like you have it. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, November 18, 2004 11:09 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Control reference question. Hi Bobby Shouldn't it read: With Reports!Closeout!Closeout_GL_sub.Report If !txtSetBold <> 0 Then !txtGLEstPayroll.FONTBOLD = True !txtGLFinalPayroll.FONTBOLD = True Else !txtGLEstPayroll.FONTBOLD = False !txtGLFinalPayroll.FONTBOLD = False End If End With /gustav >>> bheid at appdevgrp.com 18-11-2004 16:53:24 >>> Now this is really weird. I played with it for over an hour yesterday and could not get it to work no matter how I changed it. I went back in a few minutes ago and changed the code from: With Reports!Closeout!Closeout_GL_sub If txtSetBold <> 0 Then !txtGLEstPayroll.FONTBOLD = True !txtGLFinalPayroll.FONTBOLD = True Else !txtGLEstPayroll.FONTBOLD = False !txtGLFinalPayroll.FONTBOLD = False End If End With TO With Reports!Closeout!Closeout_GL_sub If txtSetBold <> 0 Then txtGLEstPayroll.FONTBOLD = True txtGLFinalPayroll.FONTBOLD = True Else txtGLEstPayroll.FONTBOLD = False txtGLFinalPayroll.FONTBOLD = False End If End With And it now works. I hate it when Access does this to me. Thanks all. Bobby