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

    Surpress subreport and report fields

    Since Column headings did not show up in the subreport, I placed them in the report. If no children the subreport does not show, but I need to hide the column headings in the report.
  2. kronar

    Surpress subreport and report fields

    How would I surpress a subform and some report labels if there are no records in a subquerry? And what module would I insert the code??
  3. kronar

    seek on indexed table

    I have a table called JB_Jobs, The key field is JB_JobBibNo a text field, it has the key symbol in front of it and in its index property is Yes (no duplicates). Code to use seek: Set db = CurrentDb() Set JBrec = db.OpenRecordset("JB_Jobs", dbOpenTable) If Not JBrec.BOF And Not JBrec.EOF then...
  4. kronar

    module not found

    NEVER MIND Seems I had a private variable string definition that I hadn't moved. Looks as if it ignored all procedures prior to the variable definition.
  5. kronar

    module not found

    In an effort to make my code more usable, I shuffeled the order of the procedures in the code module. Now it looks as if code is not finding any of the code modules. I put 'stop' and toggled breakpoints in the formload procedure (formload is now the first procedure after variable declarations)...
  6. kronar

    refresh data in subform

    Thanks - worked great. I was accessing the subform from the form's update rec button.
  7. kronar

    refresh data in subform

    I am trying to update data in a subform by modifying the query it is based upon. The query updates however the subform data displayed won't refresh until next time I open the form? main form = [frmEnter Times] subform control = TimebyDate source = EmpTimebyDate a form EmpTimebyDate record...
  8. kronar

    test for no records found

    Thanks that worked, guess I needed the = in front of it.
  9. kronar

    test for no records found

    the Form JobForm contains a subform JobTimesubform which is based on a query. In the footer of JobTimeSubform is a field 'TotalHrs' which has source =Sum(HbE)which is field in query. On the JobForm I have afield whose source is [Form].[JobTimeSubfield]![TotalHrs] If no records are found - I get...
  10. kronar

    test for no records found

    I have a form that displays JobTime records in a subform. In the subform I total HbE from the query. How can I use '=iif(iserror(sum(HbE), 0, sum(HbE))' as the Control Source of the field in the form footer?
  11. kronar

    No records on subreport

    ...table? SELECT J.JB_JobBidNo, J.JB_JoborBid, J.JBT_EmpNum, E.EM_FirstName, E.EM_LastName, Sum(J.JBT_WorkHrs) AS HbE, E.EM_Wage, (Sum(J.JBT_WorkHrs)*E.EM_Wage) AS Tot FROM EM_Emp AS E INNER JOIN JBT_EmpTime AS J ON E.EM_EmpNumber = J.JBT_EmpNum WHERE J.JB_JobBidNo=[Forms]![frmMenu]![txtJobNum]...
  12. kronar

    No records on subreport

    ...is: SELECT J.JB_JobBidNo, J.JB_JoborBid, J.JBT_EmpNum, E.EM_FirstName, E.EM_LastName, Sum(J.JBT_WorkHrs) AS HbE, E.EM_Wage, (Sum(J.JBT_WorkHrs)*E.EM_Wage) AS Tot FROM EM_Emp AS E INNER JOIN JBT_EmpTime AS J ON E.EM_EmpNumber = J.JBT_EmpNum WHERE J.JB_JobBidNo=[Forms]![frmMenu]![txtJobNum] and...
  13. kronar

    Fill Field in a report

    Thanks, I finally got that one figured out. Got the Dlookup working too.
  14. kronar

    Fill Field in a report

    How do I add this new query? I tried adding it after the ; on the SQL view of the query, but got an error "chars found after end of query. I removed the ; - got error. I changed it to , - got error.??
  15. kronar

    Fill Field in a report

    Thanks Duane. Yes, TR_Tax table contains just one record with one field. 1)I am not familier with DLookup function, other than one of my books says that this includes a lot of overhead? 2)Don't know how to do this. The report source is a query in the query tab. 3)I had tried this as a...
  16. kronar

    Fill Field in a report

    How can I fill a text box in a report with data from a secondary table. This doesn't work: Private Sub Report_Open(Cancel As Integer) Dim selstr As String Dim db As Database Dim TRrec As Recordset MsgBox "Load Tax Rate" Set db = CurrentDb() selstr = "Select DistinctRow...
  17. kronar

    Using form query in report

    Good call... I just found in my book that page footers don't support agregate functions so I moved the text box to the report footer - now it WORKS...
  18. kronar

    Using form query in report

    In JobReport there is subreport timesubreport timesubreport source is timequery timequery sums time by employee field called HbE in footer of subreport Field TotalHrs source is =Sum([Hbe]) this is where I keep getting #error when I run timesubreport by itself
  19. kronar

    Using form query in report

    Text box is in subreport HbE is name of the Summed field in the query that the subreport is based on HbE displays as numeric field summed for each employee in the subreport Text box is named TotalHrs and is sum(HbE) Text box is in the report footer (which doesn't normally display) This works...
  20. kronar

    Using form query in report

    OK, but why do I always get an error instead of total in the footer where source is "=Sum([HbE])

Part and Inventory Search

Back
Top