Search results

Thank you so much sir , you really is making my work so much easier!!

already it is like this only , I have not added any quotation marks, pls refer the attached file .

hello sir , now it is working only for two specific areas that is "dies" & "fa" , but not for "Blk wire Drawing(fine)" for this particular area again error 3075 is coming, maybe the brackets I am using causing this problem??

now it is giving error 2451, I don't want to open my report after clicking this button (if this sentence helps you).

hello sir , should I do this using expression builder to the filed in my report , because in vba after button click it is not working.

hello sir , now it is giving error 3075 , I have attached the error message for your reference.

no sir , my intention is to open the report only once ,but it should open the report with two filtered fields , that is area (text field) & month of entry(date filed),at the same time. so can you please tell me how to achieve this ??

dear june7, where to apply this ??

dear all, I have a combo box in a form to filter the report filed, my requirement is to only filter the report, but it shouldn't open it, because that work will be done after clicking another button where date will be filtered. but unfortunately this is not working. Anyone pls help me. Private...

sorry sir I now double checked & I found out date is getting filtered but the area is not getting filtered ,it was a typo earlier . very sorry for the inconvenience, kindly help me on this regard.

dear sir , I need your help very badly , hence I sent a message to you ,kindly check once.

dear all, I have a calculated text box in my report , after calculating the value is now showing as 0.588 but I want the same in % format ,how to achieve the same?? I have attached the image of the report for your reference.

dear all , I have attached my report for your reference , I need a pie chart of the same but in %.in the bottom of it. could u please explain the steps on how to do it??

dear june7, As I already told you I am still learning , could u pls tell me the expression for this?? so that I can follow the same ??

hi june7, thank you it worked ,as I wanted something more I created two more text box which I can use to filter the date of my report. but now date is not getting filtered but area is filtering ,could u pls check the fault in my code??Private Sub OK_Click() On Error GoTo Err_Handler Dim...

hi june7, as I am a beginner I didn't get you correctly if I build an expression can it automatically update to successive rows also.?? could u pls send the syntax please . Thank you for your time & help.

dear all , I have report called OT details & I have a combo box in a form "filter report", but the code to filter the area is not working .here is my code. Private Sub cmdfilter_Click() Dim StrWhere As String StrWhere = "[Area]" = Me.cbolocationbrief & "'" End Sub

dear all , in my report I have 5 columns: 1. Area 2. Planned leave(Hrs) 3. unplanned leave(Hrs) 4. Absenteeism(Hrs) 5. Total OT(hrs) now at the second row I need percentage like below: 1. below sum of Planned leave(Hrs) - I need % of(Planned leave(Hrs)/(Planned leave(Hrs)+unplanned...

Thank you so much it worked!!!

dear sir , sorry to say but still the problem is unresolved, actually what I want is : * Even if no changes are made to existing form(record),& if I click on save & new It should open a new form. * Suppose if I did any changes to the existing record or enter a new record it should show a...