Search results

I cannot put this under the report footer, the grand total is for the 2nd group. There is another grand total to show all the final result. For the better illustration, click the attachment below which show to u the 2 major group, known as Process and Machine. Process is indicated as 1st...

There are 2 groups in report, I need to have show subtotal and grand total. How to do? Group 1: SubTotal ControlSource : =sum(OutQty) RunningSum: OverGroup Group 2: GrandTotal ControlSource : what key in ? Any advice ? RunningSum: what to choose?

I have 2 questions here a) Control source can link to the variable inside a form , for example strStartDate and strEndDate ? b) How can we write the VBA in stead of through the windows ?

Under Form Under Report How to receive the value send from FORM ?

Thanks above, How to write under the form the VBA to pass the value to report? What you have stated above is code at report right? I am seeking any chance to write under form.

How to write the VBA to pass a value from a control in a form to a control in a report ?

Thanks for the above comment, but I don't quite like to be commented "I'm sorry, I'm not trying to be rude, but is English not your first language?" . You need to understand my VB and VB.Net programming backgound as explained in the earlier post and nothing to do with the LANGUAGE !!! However...

Delay means the syntax you write is correct, because the subform still able to show the data, it is still matter of time. Thus, nothing to do with the syntax. We need to consider other factors/issues like network, RAM, cache, etc As for my case, after several of R&D, it is due to the cache...

In the query, there are 2 important date field which is known as "StartDate" and "EndDate". There is another field showing the duration in hour between the "StartDate" and "EndDate", which is known as "Duration" [example: Duration: datediff("m",StartDate,EndDate) ] To execute the query...

I've detected the root cause. Thanks for your guide above.

How to filter this through query ?

The field is the date/time type. However, I got detect few invalid entries which do not fall in the above query range. For example : 24/12/463 (incorrect value in year). My questions now are as below a) Any method I can filter out those invalid entries through the docmd.openreport or other VBA...

Appreciate your help above. If I would like to filter out the Nulls and any invalid entries, how can I amend the code below ? DoCmd.OpenReport "Report_Machine_Utilisation_Time", acViewPreview, "OpnStartTime Is Not Null" , "OpnStartTime between " & Format(strStartDate, "\#mm/dd/yyyy...

Now in 24hour time, problem remain.

What is the conclusion?

1) When I try run the query, it works. Query.jpg show the example 2) When I run through the code, error prompt as above. Shown in VBA.jpg

Have tried, same error. Thanks strStartDate and strEndDate is the value from textbox, not the control textbox name. Maybe is better for me to include the whole code here. When i run debug.print , both strStartDate and strEndDate carry values.

Code rephrase as below DoCmd.OpenReport "Report_Machine_Utilisation_Time", acViewPreview, , "OpnStartTime between " & Format(strStartDate, "\#mm/dd/yyyy hh:mm:ss\#") & " And " & Format(strEndDate, "\#mm/dd/yyyy hh:mm:ss\#") & "" Error message: data type mismatch in criteria expression

Tested the SQL, it doesn't work. Syntax error, missing operator. Code written as below DoCmd.OpenReport "Report_Machine_Utilisation_Time", acViewPreview, , "OpnStartTime between " & cdate(strStartDate) & " And " & cdate(strEndDate) & ""

Error prompt at below code DoCmd.OpenReport "Report_Machine_Utilisation_Time", acViewPreview, , "OpnStartTime between #" & strStartDate & "# And #" & strEndDate & "#" a) Error message: data type mismatch in criteria expression b) Both strStartDate and strEndDate is value from TextBox c)...