John Clark
John.Clark at niagaracounty.com
Tue Apr 12 06:51:41 CDT 2005
Thanks Bobby. I'm a dolt...I always forget about the "me" when I am in a form. I don't get to program in Access for months sometimes, and then I get back into it and I keep forgetting the same stuff. The thing I love about my job is the same thing I hate about my job...variety. I'll do Access for a bit, then I'll do some IP telephony for a while, and then we mix in some net admin duties and some other assorted tidbits, and VOILA! you've got confusion ;) But, it doesn't get boring ;) Thanks again! John W Clark >>> bheid at appdevgrp.com 4/11/2005 3:21 PM >>> I use something like (warning - air code): Dim strSQL as string strSQL="SELECT * FROM SomeTable;" me.recordsource=strsql Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Monday, April 11, 2005 3:02 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] One report using alternate sources What is the command to set the record source? As a test I've started typing: If [Forms]![frmrpt_quarterly]![FrameChoices] = 8 Then I'm not sure how to set the recordset...I had thought that I had to use the form name as a control, but it isn't taking it. >>> bheid at appdevgrp.com 4/11/2005 1:55:34 PM >>> Lambert had a neat idea. What I do is to have the different queries (either SQL text or actual queries). I then set the recordsource for the report in the OnOpen event of the report. In your case, I would have a select statement that gets it's values form the calling form. The select statement would then set a variable to the query name or actually set the recordsource. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Monday, April 11, 2005 1:39 PM To: 'Access Developers discussion and problem solving'; 'John Clark' Subject: RE: [AccessD] One report using alternate sources Sure can. Design you single, master report, and all the various versions of the query needed to select the subsets of results. Then bind the report to a copy of one of the queries. You could name the query copy "FinalOutPut_qry", or whatever. Then, when you want to run any one version of the report, your code will check which version of the query is needed and then use... DoCmd.CopyObject ,"FinalOutput_qry",acQuery, "NameOfTheQueryThatSelectsWhatYouWant" i.e. you copy the query that select the records you need to the 'disposable' query named ,"FinalOutput_qry", or whatever, to which the report is bound. The nice thing about this is that it works for MDE as well as MDB files. Lambert > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark > Sent: Monday, April 11, 2005 12:52 PM > To: accessd at databaseadvisors.com > Subject: [AccessD] One report using alternate sources > > I've got this program (A2K) that tracks many of the various programs, > and subsequent "sub-programs," that are provided by our Office for the > Aging department. I have recently been asked to add about 8 or 9 > reports to the program. The reports for these programs are identical > to one another except for a single criteria (i.e. they all have name, > address, age, etc., but one may be specifically for "prog A" and > another "prog B"). I went ahead and whipped up 9 very similar queries > and it occurred to me, because the form is starting to get crowded > w/buttons, that there may be a way to put these together somehow. I > have created an option group, which lists the programs, but now I > would like to click on a button that runs a report based on the option > group choice. I know I can do this, by calling different reports, but > is there a way to actually create one single report that uses the > different queries based on this same option choice? > > Thanks, > > John W Clark > -- > 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