Search results for query: *

Thanks Duane. I figured that the subreports will probably be the best way to redo this report when I have time. But for now, I actually got it to work by moving that code to the report's "Print" event section. Not sure why but it will get me buy until I can redo each subreport since there's...

Ok, I am having an issue with this again. Here's the code i am using in the report's Load properties: If Me.[Repairs subform].Form.RecordsetClone.RecordCount = 0 Then Me.PageBreak260.Visible = False End If On Access 2007 this works fine - if there is no data in this subform, I do not get a...

Duane, Thank you again. That all makes sense now. Now I have to go through and redo some of my report because I don;t know how I did it, but I have subforms in there as well, and the hasdata will not work with subforms. Thanks again!

Duane, Stupid question - where exactly do I place this code?

Thank you Duane!!

Hello everyone, I have checked and found some posts relating to this but I am unclear on the content and therfore am hoping someone could point me in the right direction. I am in Access 2003, and have a report set up. In this report, there are multiple subreports, each having a page break so...

Hey everyone, I am wondering what would be the best way to try and accomplish this. I have a query, which selects data based on what employee name I select in a ComboBox. I have 4 employees and each one is assigned to 6 or 7 locations. Depending on the employee I select on the ComboBox, the...

PHV, Thanks. I tried the subreport, and it works great except for one thing. For some reason, when displaying the first record of data, the sub form is page breaking at a certain location even though the Main report and the sub report do not have any page breaks. Ive checked the keep together...

Good evening, I am looking for some advice on what is the best approach for this particular situation. I have a main form, with a subform called "Observation Subform". While my main form will enter into a main table as one record, the subform may have 3 or 4 records stored within its table. I...

The other thing I noticed is this. I put in the code above and when I accessed the subform, the sub form will not allow me to add a record. However, the Allow Addition field under the sub form properties still shows Yes. I now wonder if this whole thing is caused by it counting everything in...

PHV, I saw that in one of the other postings on here when I did a search and tried it as well, and It did the same exact thing. When I accessed the page with the sub form, it wouldnt let me add a record. I even went into my table, deleted 3 records to make my record count 6, and it still...

I have a form, which has a sub form on it that allows me to enter in records for a table. What I would like to do, is max the amount of entries in this sub form to 10. I have a text box with the data source "=Count(CTN)" and it is accurate. I added this into the sub form's On Current event...

Ahhh, I see what you are saying... will it work if the field in the table is a text field with a value list of Yes/No or does this only work if the field is a yes/No type in the table?

Dhookom, Thanks for the reply. But doesn't that actually give me the total number of entries for that field name? If I have 5 yes records, and 4 no records, I am looking for the answer of "4", not a sum of the field which would be 9. Either way, I finally got it to work after playing with it...

Hey PHV, Thanks for the quick reply.

I am stumped on this. I have a Table with a few fields that are set up as yes/No and I am using a value list of Yes and No. On my form, I am using a combobox and the person using the form can select either Yes or No. In the footer of the form, I have a text box set up to give me the count of...

hey all, I think I figured it out so thank you anyways. Sorry to have bothered everyone.

Good evening, I am running into a situation where I know I can solve my delema by creating multiple text fields in one table, but I think that would be so inefficient. So let me explain what I am trying to do and if anyone has a suggestion on how best to accomplish this, I would very much...