Search results for query: *

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.

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

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

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.

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

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

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

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

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

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?

I have added a field to my job table "JB_JoborBid" with type yes/no. However when I added J.JB_JoborBid = Yes to the query I get a pop up box to enter J.JB_JoborBid value?? Why does this not find the preset value in the table? SELECT J.JB_JobBidNo, J.JB_JoborBid, J.JBT_EmpNum, E.EM_FirstName...

I have a subform that pulls employee time records. The subform record source is the time query. The time query 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...

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

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

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

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

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

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

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

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