Search results

Hello, I want to create a database were I can calculate business days using holidays from 2 or more countries. I am using the below code on calculating business days. Public Function GetNetWorkDays( _ ByVal datDateFrom As Date, _ ByVal datDateTo As Date, _ Optional ByVal...

Hi All, My job requires me to create a template that will simplify our variance composition analysis. This is the set-up: Our organization consist of employees who handle more than 1 business unit. A business unit is required to prepare variance composition analysis report for their interim...

I know it may be a stupid question but can someone enlighten me the use of parenthesis when creating Subroutine or Function in VBA? Sub () <Code> End Sub Function () <Code> End Function I appreciate the explanation and reference sites where can I further read :D Cheers, vash

Hello All, Is there a way to replicate NETWORKDAYS formula in Excel to Ms Access? Maybe a sort of macro? Cheers, Vash

Hello All, I am trying to create a Ms Access database that will generate an automatic variance explanation comparing two periods in two tables and the comparison in third table. This will help me eliminate the time spent on tedious (manual) comparison of various increases and decreases between...

Hello To All, Thanks for the wonderful welcome. :) :) I am sure I'm gonna enjoy my stay here. I am from Philippines and currently doing some projects related to Ms Access database. Looking forward for a lot of learnings. Thanks. :)