Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Tue Feb 3 09:19:55 CST 2004
thanks a lot Jim , it seems to be working :--) > I've done it for A97 and A2K. > Put it directly into the Control Source of the Object in the report. For > example: > I have a form with three date fields. Begin Date, End Date and Annual > (picks the entire year) > I have one control at the top of the report for dates. Below is what's > in the control source: > > =IIf(IsNull([Forms]![frmRosterDatesSelect].[BeginDate]),"Calendar Year: > "+Str([Forms]![frmRosterDatesSelect].[AnnualYear]),"Between: > "+Str([Forms]![frmRosterDatesSelect].[BeginDate])+" - > "+Str([Forms]![frmRosterDatesSelect].[EndDate])) > > HTH > Jim > > -----Original Message----- > From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] > Sent: Monday, February 02, 2004 3:59 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] passing a value from report to form > > > what version are we talking about ? and where should I put it. OpenArgs > is not available.. > > stDocName = "Carol2" > strSQL = "[employee number] = '" & Me!employeenumber & "'" > ddd = "[namee] = " & Me!Combo14.Value > > DoCmd.OpenReport stDocName, acPreview, , strSQL > > > > > > > >> >> Perry is correct. >> I do this all the time. >> This is especially useful to put the "To" and "From" dates for the >> report. >> >> Jim >> >> -----Original Message----- >> From: Perry Harold [mailto:pharold at proftesting.com] >> Sent: Monday, February 02, 2004 2:34 PM >> To: 'Access Developers discussion and problem solving' >> Subject: RE: [AccessD] passing a value from report to form >> >> >> How about ReportField=Forms![FormName]![FormField] >> >> Perry >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> Oleg_123 at xuppa.com >> Sent: Monday, February 02, 2004 2:18 PM >> To: accessd at databaseadvisors.com >> Subject: [AccessD] passing a value from report to form >> >> >> Still can't figure out how to pass a value (not related to any table) >> user selects on a form to a report. Any suggestions ? >> >> >> ----------------------------------------- >> Get Breaking News from CNN, ABC, NBC, CBS Now. >> http://www.xuppa.com/news/?link=webmail >> >> >> _______________________________________________ >> 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 > > > > ----------------------------------------- > Get Breaking News from CNN, ABC, NBC, CBS Now. > http://www.xuppa.com/news/?link=webmail > > > _______________________________________________ > 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 ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail