Search results

I resolved this by resizing all of the subreports within the main report. It seems that some were overlapping slightly. Not sure why this would cause extra space - but problem solved. Thank you all!!!

@theDBguy - Can you please elaborate on your last suggestion? There is a property called Show Page Margins. The choices are Yes or No. Is this what you mean? The report itself is right at the edge of all subreports therin.

Thanks Pat. All of the queries used for my subreports have 1 blank field at the bottom (see attached). But not all are problematic. I will check the sorting now. Appreciate your help!

Thanks everyone. I tried all suggestions plus I set the "Can Shrink" property to "Yes" on each subreport. No change. I didn't test changing the data because I need the report to be consistent regardless of what data I'm using. When Access formats the report and sends it to Print Preview there...

I have a report consisting of a few subreports. In certain instances a subreport will appear on the following page (or several spaces down from the sub above it) for no obvious reason. I changed Keep Together to "No" in the report footer and this resolved one occurrance. Does anyone know how I...

Hi Doc_Man - Sorry for the late reply. Yes I understand exactly what you stated. I appreciate your clarity.

Hi Doc_Man -always appreciate your help. I used Table2 because there were two fields in it which I used in the query. However, when I created the test db and pasted the SQL into it those fields were accidently deleted. Sorry about that.

@XPS35 - THANK YOU SIR!! I'm going to take a nap now!

In other words, I would expect this: Payer ClientName Client_ID Therapy SumOfNumber_UnitsBilled Billed_By Res_Out Date_Of_Service Original_UnitsBilled MLTSS Conn, Roy 600145 Structured Day -6 Yashica Walker Residential 01-Dec-23 8 MLTSS Conn, Roy 600145 Structured Day -6 Yashica Walker...

If each table has 4 records that have the same Cust_id, Payer and Therapy (Structured Day) - and the tables are linked on Cust_Id, Payer and Therapy then I would expect 4 records to be returned.

Hi Doc_Man, I just included every other field available and still got 8 records. Also, I can't join Original_UnitsBilled to the other table because it doesn't exist there. I've never seen this happen before when the joins are correct. Is this a bug in Access? Thanks, TS

Okay, I admit I've had a long day and that my eyes and brain need a break. But - If Table1 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and Therapy (Structured Day) : {Total entries = 4} and If Table 2 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and...

See attached example. I would like to have a form that has three command buttons positioned next to each other (side by side) in the uppermost part of my form. They should always be visible. If the first command button is clicked I would like to have another specific form open in the lower part...

Figured it out. The sort has to come before the group. Thanks for your help!

Thanks for your reply pbaldy. The sorting is set up in the Group & Sort from the report's design view. It is also sorted in the query recordsource. So, I have both bases covered. I should mention that the sort issue is contained in a subreport. When I click on the subreport within the main...

I have a report which has a query as its recordsource. The query sorts the "Task_No" field in ascending order. The query works fine but when the report opens the "Task_No" field is not always sorted properly. Sometimes it is and sometimes it isn't. This just started happening after we migrated...

Nevermind. I just replaced "If IsNull(rs2("Number_UnitsBilled")) = True Then" with "If rs2.recordcount = 0 then" Now all is good. Dumb mistake. @Josef P - Thanks for responding.

The code below returns a null string (as it should) in query design. However, in my VBA code the vartype for rs("Number_UnitsBilled") is 9 which indicates that it is returning an object. Therefore, the program crashes with a "No current Record" error in the "Else" statement. How can this be...

Thank you all. Very useful information! I solved my problem after I noticed a syntax error involving parentheses.

I am trying to use a msgbox to debug a query I have written in VBA code. However, the msgbox is not large enough to display the whole query. Is there any way to expand the msgbox so that I can see the whole query? sql1 = "SELECT tbl_Authorizations.ID, [tbl_Authorizations].[client_LName] & ', '...