Search results

Mostly we use BI from a repository to compare data between subscribing systems. Access is used for quick looks and to review cross table links on an adhoc basis.

I know it is from the Weekdays Error in the code. I think if I make the date/time just date and forgo the timestamp it may resolve this particular error.

And now for a new error... Error 5: Invalid procedure call or argument.:banghead:

Thanks for the help. I renamed the modules and the query ran just fine.

I am attempting to determine workdays in a process. I can successfully do total days, but need to take out the weekends/holidays. I've created 2 modules The first is: Weekdays [CODE] Option Compare Database Option Explicit Public Function Weekdays(ByRef Process_Start_Datetime As Date, _...

I'm an old school nerd. I'm new to Access VB Modules. Have been using Access successfully for years. I am more of a data quality analyst. My first database introduction was Dbase I.