Search results

It's not my field of expertise @ all.. Thxs a lot for ur help :)

Ive amended as follow: Public Function fncDateDiff(d1 As Variant, d2 As Variant) As Integer If IsNull(d1) Then d1 = Date If IsNull(d2) Then d2 = Date Dim cnt As Integer For dt = d1 To d2 If InStr("Sat/Sun", Format(dt, "ddd")) = 0 Then cnt = cnt + 1 Next If cnt > 0 Then cnt = cnt - 1...

@arnelgp, i've used the last function u sent and still error 'Date type mismatch in criteria expression' with the fncDateDiff & select. TASK_NO TASK_NAME ACTUAL_STARTDATE ACTUAL_COMPLETIONDATE TimeTaken getting #Name? #Name? in all the fields Hv i missed out something?

@arnelgp, Getting error 'Date type mismatch in criteria expression' with the fncDateDiff & select. Table datatype: TASK_NO, Short Text TASKNAME, Short Text ACTUAL_STARTDATE, Date/Time ACTUAL_COMPLETIONDATE, Date/Time ACTUAL_COMPLETIONDATE can be null, the time take is then #Error

Hi, Pls help. In query, i want to get list of task that has exceed 15days for completion excluding weekends(sat & sun). Include Mon-Fri as days counted. using below select: SELECT TASK_NO, TASKNAME, ACTUAL_STARTDATE,ACTUAL_COMPLETIONDATE, DATEDIFF(dd, ACTUAL_STARTDATE...

thxs a lot for ur help :)

I did put the textbox name in the code If strCriteria2 & "" = "" Then Me![Text331] = 0 Else Me![Text331] = strCriteria2 & " And [Status]='Pending'" Text box value is below instead of count: Emp_name='John Smith' And [Status]='Pending' anyother amendment to be done?

Getting 'Run-time error 2465' in below code Me![On-hold] which value expression should it actually has?? If strCriteria2 & "" = "" Then Me![On-Hold] = 0 Else Me![On-Hold] = strCriteria2 & " And [Status]='On-Hold'" End If

Yes did use the previous provided code where total count working. I've attached the zip DB instead of posting code

for the summarised count per status I've created the 3 textbox and added code in label. but its that when click on clear button.. we cant clear as it has this formula. ON-HOLD in textbox added >> =Count(IIf([status]="ON-HOLD",0)) WIP in textbox added >> =Count(IIf([status]="WIP",0)) CPL in...

Hi, One small question & help pls... The overall count is working fine. :) However, i need to display an individual count per status next to these combos. I created 3 textboxes for each status (ON-HOLD, WIP, CPL) If i select employee_name e.g John and other combo-box null then display His...

hi, Ive a continous form with a button 'Open this record' and added attached macros. when click on btn its opening the record. BUT At end of the form there's a new record which is null. when select the null ID getting error 295. Any idea? Or is it possible to hide that record & btn if all...

hi, I've created a duplicate record button via the button wizard Command Button Wizard > Record Operation > Duplicate Record button How can i amend the button to show when field 'date_input' is not null hide when date_input is null ??

btw how to do the count based on multiple dropdown values selected.. Employee_Name Company_Name Status Type

Right... It's working .. :) Thxs

hi, the combo will have only employee name. I've tried below code but the count is 0 instead of actual count. What have i missed out? Private Sub Combo303_AfterUpdate() Me.Txtempl = Nz(DCount("1", "tbl_empl", "employee_name='" & Me.Combo303.Column(1) & "'")) End Sub

Hi, I have 4 dropdown fields in a continuous form with a search btn. Employee_Name Company_Name Status Type How can i amend the 'employee text box count' to display the count per employee_name values being selected. instead of hardcoding like below =Count(IIf([Employee_Name]="John",0))

hi, Pls help. in access 2016, I have field ' assigned_to' & 'project_cost' in the database and form. how can i make this these fields be amendable by only the admin user. for security level, i have admin, normal user.. both of these user type will have access with the form containing these...

hi, From below query access2016, i need to represent the data (attached) in a chart. Which chart types can i use to represent the details? SELECT tbl_customer.customerName, Count(tbl_customer.customerName) AS COUNT_PER_customer, tbl_customer.Status, tbl_customer.SEGMENT FROM [tbl_customer]...

hi, I have 3 charts (2 Pie Chart & 1 bar-chart) in a single report page. Added below code in page: DoCmd.OpenReport "Report", acViewPreview However, when report load i'm not able to view one of the chart in the preview. But in design /report & layout view the details are available. Pls help.