I had to create a new CD.mdb database due to errors in the index.
I imported all tables, forms, queries, etc. successfully.  No index error found while compacting database.

I replicated the database to three other users, while keeping the design master on my computer.

When the other users open their replica, as error appears:   Missing or broken reference to OWC10.DLL.

How can I fix this problem?

Here are 2 images:

 

I hope to resolve this before the users return to work on Monday.

Thank you for your help!

Hi,
I would like to calculate the process duration and how long does it take excluding Weekend ( Friday and Saturday), I have used below function but it does not work specially if End date is "empty" and the process not completed... what i what to do is calculate the duration ( End date-Start date) excluding weekend(fri-Sat) and if end date is empty, (up-to-date - start date)
any help please

Public Function WorkdayDiff(ByVal d1 As Date, ByVal d2 As Date) As Long
  Dim diff As Long, sign As Long
  Dim wd1 As Integer, wd2 As Integer

  diff = DateDiff("d", d1, d2)
  If diff < 0 Then
    '* Effectively swap d1 and d2; reverse sign
    diff = -diff
    sign = -1
    wd1 = Weekday(d2)
  Else
    sign = 1
    wd1 = Weekday(d1)
  End If
  wd2 = (wd1 + diff - 1) Mod 7 + 1

  If (wd1 = 1 And diff = 0) Or (wd1 = 7 And diff <= 1) Then
    WorkdayDiff = 0 '* Both dates are on same weekend
    Exit Function
  End If

  '* If starting or ending date fall on weekend, shift to closest weekday
  '* since the weekends should not contribute to the sum.
  '* This shift is critical for the last If condition and arithmetic.
  If wd1 = 7 Then
    wd1 = 1 '* Shift to Monday
    diff = diff - 1
  ElseIf wd1 = 6 Then
    wd1 = 1 '* Shift to Monday
    diff = diff - 1
  End If

  If wd2 = 1 Then
    diff = diff - 1 '* Shift to Friday
  ElseIf wd2 = 7 Then
    diff = diff - 2 '* Shift to Friday
  End If

  '* If difference goes beyond weekend boundary then...
…

SQL View to group employees and show days for range.
I have my SQL View which is showing me the data that I want however it is not formatting how I would want it and I am at a brick wall with it -

Here is my sql

SELECT DISTINCT 
                          dbo.EMPLOYEELIST.EMPLOYEE_NAME,
                        
						 dbo.EMPLOYEELIST.ACTIVE, 
						 CASE WHEN cast(dbo.TimeEntered.Monday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Monday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Monday  as date)
						 END AS MONDAY,
						  CASE WHEN cast(dbo.TimeEntered.Tuesday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Tuesday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Tuesday  as date)
						 END AS Tuesday,
						 	  CASE WHEN cast(dbo.TimeEntered.Wed  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Wed  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Wed  as date)
						 END AS Wednesday,
						 	 	  CASE WHEN cast(dbo.TimeEntered.Thursday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Thursday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Thursday  as date)
						 END AS Thursday,
						 	 	 	  CASE WHEN cast(dbo.TimeEntered.Friday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Friday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Friday  as date)
						 END AS Friday,
					

Select all Open in new window

…

I want to add a conditional formatting to the cells in column G ( 7 - 22) . I want the cells to highlight a certain color blue (RGB 183, 222, 232) if the ship date in column H is delinquent based on today's date OR if the ship date carries through to Sunday of that week. For example today is Monday, Sept 10th. The cells in column G should highlight if the ship date is through Sunday, Sept 16th.

Second, is it possible to also to write a formula in cell H31 to automatically sum up all cells that are highlighted in the blue in column G so that I don't have to manually do the sum each time I move lines around?

Third, is it possible to also to write a formula in cell H32 to automatically sum up all cells that are highlighted in the purple (RGB 204, 192, 218) in column K so that I don't have to manually do the sum each time I move lines around?

Fourth, is it possible to write a formula in cell G32 to automatically sum up all cells that are highlighted in the green (RGB 0, 255, 0) in column K so that I don't have to manually do the sum each time I move lines around?
FCS-TRAINING.xlsx