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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Dontremb

  1. Dontremb

    Using a Query for 2 tables

    Union query seems the way to go, from what I understand. It puts all the data from one table first, then the second table AFTER the fields from the first. I have no idea how to actually DO one of these, but I'm sure it's easy to find.
  2. Dontremb

    Creating individual page files from an access report.

    Have you tried this? http://www.lebans.com/reporttopdf.htm ? I'm not sure if it will solve ALL your problems, but it's another avenue.
  3. Dontremb

    Automate printing of report

    Is there a specific reason that you have to send it in PDF form?
  4. Dontremb

    Subreport has no data - Print 'No data available' if empty

    DAmoss, you might be better off using the Label as Samyers said, Have you tried this? Also, make sure you're selecting the subreport control on your main form, and NOT the subreport's properties itself.
  5. Dontremb

    Isolate records with numbers

    Ok, I don't have the entire answer. I'll keep looking. But a good starting point MIGHT be this. In the criteria of a query, you could put, Like "[A-Z]*" That way you can at least SEE the separation. This might not help you, but I'll keep researching.
  6. Dontremb

    Query Too Complex

    Wow, MajP. Thank you so much for going into depth and explaining it all to me. I believe I actually understand everything now. I still don't think I can use grouping to limit the number of queries effectively, but at least I understand how it's used. Thanks again. I'm archiving this thread...
  7. Dontremb

    Query Too Complex

    Also, MajP, how does each know what query or table you're getting the information from? val1 = strVal("Count of Employees") val2 = DCount("EmployeeID", "Employees") val3 = strVal("Employees") Call insertVals(val1, val2, val3) I see what Val1 equals, But val2? It's obviously counting...
  8. Dontremb

    Query Too Complex

    Hrm, MajP. That certainly looks interesting, and I may play around with that. I enjoy working in code better anyway. I have two questions: 1) Where do you put that code? Link it to a button or something? a) Where does the output go? tblOutput? 2) I HAVE used VBasic for years, but...
  9. Dontremb

    Pull a field from a Subreport to the Main Report

    Ok. I finally got it. It was a mix between finding the right syntax to call a subreport field, and not knowing that the subreport name could be different than the source report name (thanks, dhookom) It works perfectly now, this is what the text box on the main report has as a control source...
  10. Dontremb

    Text Box in Master Report from a SubReport

    Just to finish this thread up. I DID find a way around, still using subreports, but pulling the info from the subreport to my main report.
  11. Dontremb

    Pull a field from a Subreport to the Main Report

    This isn't exactly the same question. By asking the other questions, I have found out other things I might be able to do, so I'm trying to figure out how to do those specific things. I need to pull a control or a field from the subreport. My main problem is that everything I have tried to do...
  12. Dontremb

    Text Box in Master Report from a SubReport

    Ok, so now, I've run into the problem where you can only have 32 queries linked to a query. I'm pretty sure there's no way around this "Query too complex" error, so I've been looking at other, more complicated, and more annoying ways of doing this.
  13. Dontremb

    Pull a field from a Subreport to the Main Report

    Ok, hopefully, this is a simple problem. I have a report, with a subreport on it. This subreport has a field on it, and all I want to do, is reference that field in the main report. That's it. From what I've been able to research, (which is nothing) this is completely impossible in every...
  14. Dontremb

    Use a Query to Make a Table

    Ok, here's the problem I'm running into. (Some of you may remember part of the problem from other posts.) I've got a lot of queries that count other queries. All of these queries need to be displayed on one report. I don't want to use subreports because they're very annoying. I originally...
  15. Dontremb

    Query Too Complex

    lespaul, I did not know you could do that, actually... I'm going to try to mess around with this right now. This may be one of the MANY problems that arises from me being self-taught in Access. There is a bunch of stuff that I'm just not aware of. Hrm... I run that, and just get this error...
See more

Part and Inventory Search

Back
Top