Search results

Hi, Yeah, i have tried using datepart as i have said above. It doesnt give me the option that suits my requirements. vbUseSystem 0 Use the NLS API setting. vbFirstJan1 1 Start with week in which January 1 occurs (default). vbFirstFourDays 2 Start with the first week that has at least four...

Hi, Im trying to write some VBA to convert a date into a week number. After a lot of studying and googling. My work colleagues do not not what system is used to define the week numbers. So I have gone through all their records (im the new guy) for a few years and deciphered this pattern: I...

Thanks for all the responses. It was counting 0 when I knew the criteria should count 5. PR2-eugin your code worked straight away. Thanks all :) :):)

Hi, Trying to get a Dcount to work. My code so far (not working) DCount("OracleID", "TblEmpAb", "(OracleID = '" & txtOracleID & "'" & " AND AbStart =#" & Me.txtAbStart & "#") Im using this VBA to prevent a new absence case being created if the employee selected already has a case open...