Recent content by rmm13

Found it. Troubleshooting and investigating further suddenly got this odd error message to come up. "You can't use a pass-through query or non-fixed-column crosstab query as a record source for a subform or a subreport." Went in the Crosstab query, declared the locations in the column...

Appreciate your help and pointers, so here's what I tried. Using the form with the Form controls in the Query and declared in the query parameters. The Form is already modal so I commented out the me.visible=false so the form is always visible. Tried running main report with the subreports in...

Yeah I am using the me.visible =False code below for all these reports. It seems to be working for the weekly report as I am not being asked for parameters in any pop ups - but the report is just blank. Me.Visible = False DoCmd.OpenReport "WkFMSRep", acViewPreview, "", "", acNormal While...

I am hoping some of the expert help on this forum can again help me solve a problem. In advance, sorry for the length of this. I have a set of reports which display data in different grids primarily by location and date. They are complicated by the fact that the monthly and yearly (by month)...

I've been finding this a lot creating reports in Access 2007 - I found that for some reason when the Record Source was added in the reportWizard - it was also picking up a set of Parameters in the "Order By" field. Check out the Data tab in the Property Sheet for the Report, they maybe in the...

By sorting do you mean the order across the report Jan, Feb, Mar etc? I put "Jan", "Feb","Mar" etc. in the Column Heading properties - and it added a Pivot to the SQL in the crosstab and it displays the months in order.

Thanks Paul That seems to work really well with a crosstab - still testing with all different data. I had to develop this all for Monthly reports then extend it - missed the simple date grouping. I am using MonthName(DatePart("m",[DistDate])).

Just to test I made LCount = Me!fmFamilies.Form.Recordset.RecordCount Works great - I'm clean up the rest now Thanks

I have a search form for last and first names which populates a subform Me!fmFamilies.Form.RecordSource = my query on the subform I have a count in the footer to do a subcount LCount = Me!fmFamilies.Form.SubCount this determines if any records were returned, and if not, opens a message box...

I have query working for a report - it's a 3 layer thing. Based on http://www.techonthenet.com/access/queries/max_query2.php Identify max value data by location and month Select the unique max records Sum the max number of people by location However I can only get the data for each of the...

Thanks so much Bob - than fixed the issue on both subforms - really appreciate your help in this - knew it was something I overlooked like several of the other issues your replies on this forum have helped me solve.

I am having problems requerying two subforms from one main form but not the second. I have two intake forms - one for entering New family information and a second for Updating family Information. They both use the same subforms, family members and pickup family, no data is entered directly in...