Search results

Thank you everyone for your input. Much appreciated. Why would this happen in only one of about 20 cases. It's so intermittent. Could it have to do with a memory issue on the individual person's computer? We have a client-server environment where Access (and everything else) is being served to...

I just read in this article that Adobe no longer support MS Access pdf exports. I have many Access interfaces from which I export reports as PDFs using the following code: DoCmd.OutputTo acOutputReport, "r_Note", acFormatPDF, strFolder & "\" & OutputFileName, False, , , acExportQualityPrint I...

I found the problem. The data, once entered, is stored in an SqlServer table. Each of the fields in this table has a char(1) datatype - except the field with the problem. That field had a char(10) datatype. I changed it to char(1) and now the problem is solved. I appreciate your time GPGeorge...

The data are values in a value list. I just copied this value list from another combo box since they all contain the same values. Problem still exists. I then deleted the entire combo box and recreated it. Problem still exists. This is most definitely an interesting problem.

Yes the properties are identical. As a matter of fact they are copies of each other. They just have different names.

Hi GPGeorge, Thanks for responding. Assuming that the user chose an option originally (which in this case I did) then yes, there would be data when the box is first displayed. There is also data in the other combo boxes as well but there are no problems with them. There is no code in either the...

I have 10 combo boxes on a form. All of them are set to text align = center in the properties box. One of them always loads as left justifed. This only happens on load. If I choose another option in the same combo box the alignment is center as it should be. But on load it becomes left justified...

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...