Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. uscctechnician

    If subreport has no data on report...

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

    If subreport has no data on report...

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

    If subreport has no data on report...

    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!
  4. uscctechnician

    If subreport has no data on report...

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

    If subreport has no data on report...

    Thank you Duane!!
  6. uscctechnician

    If subreport has no data on report...

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

    Query select question...

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

    looking for suggestions for particular scenario

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

    looking for suggestions for particular scenario

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

    Me.AllowAdditions in a subform based on count in that very subform

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

    Me.AllowAdditions in a subform based on count in that very subform

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

    Me.AllowAdditions in a subform based on count in that very subform

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

    Count(IIF... not working

    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?
  14. uscctechnician

    Count(IIF... not working

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

    Count(IIF... not working

    Hey PHV, Thanks for the quick reply.
  16. uscctechnician

    Count(IIF... not working

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

    page on form, w/memo fields from one table, but multiple employee data using same memo field??

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

    page on form, w/memo fields from one table, but multiple employee data using same memo field??

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

Part and Inventory Search

Back
Top