Hello Arnel,
Many thanks for the quick feedback. :) :)
I really appreciate your help.
I encounter again another error. :(
Run-time error: 3061:
Too few parameters. Expected1
Hello Arnel,
After a little bit of excitement on your code, I am block by Block if End IF error.
Am not sure again where it did came from,
Apologies, but can you take a look again.
Regards,
Hello Arnel,
I tested the two macros.
I encounter compile error on below part of code.
Set rs = DBEngine(0)(0).OpenRecordset()
It says Complie error: Argument not optional.
It highlights ".Openrecordset"
Appreciate your assistance again.
Hello Arnel,
Networkdays in Excel includes both the start dates and end dates.
I believe the macro for access only include either start date or end date.
Am not sure if it is or it can count the total holidays and deduct to the total business day.
The correct one is the networkdays in excel...
Hello Arnel,
Many thanks for your response.
It now calculates on a per country basis.
One more thing, I found a draw back on using the macro. When I manually calculated the diffs using networkdays in excel, there is always a difference of 1 day.
Appreciate your assistance again.
Many thanks...
Hello Arnel,
Many thanks for the assistance.
Error are now gone but some countries do not calculate correctly.
I attached here my current db.
Many thanks,
Vash
Hello,
I am having a compile error with the code we I run it.
It says "Function call on left side of assignment must return Variant or Object".
I already change the field name but this error won't go.
It ended up closing the application.
Appreciate your assistance again.
Regards,
Vash
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...
hello jdraw,
manually concatenation consumes a lot of time and effort considering the number of customers we have. i believe this process should be automated.
that's why I created the access file.
i actually solved the problem in access itself for those items exceeding 255 characters. the...
Hello jdraw,
I attached here a sample of the data that we are getting from our system.
on the second sheet, there you find data for 2 periods. this is not the maximum data, it can be more than this data.
i also do some pivots on the other sheet and calculated some variances.
regarding the...
Hello Gemma,
Please find below my remarks below.
a) I do not see what exactly the 10 or the -50 represent.
Assuming below is in table and this is the Payments Due ledger:
Customer | October | November | Change
Raccoon | USD 50 | USD 75 | USD 25
Marconi | USD 75 | USD 25 | USD -50
Jack | USD 0...
Hello Gemma,
Many thanks for replying :)
The main problem is how can I limit the explanation generated.
I have these two options but need help how am I gonna start.
1. Top 10 Highest INCREASE and Top 10 Highest DECREASE amounts.
or
2. Total amount of explanation for INCREASE should be not...
Hopefully someone can reply to my post or tell me if my post contains info that too hard to answer. :banghead: I am still "locked" at my own procedure so I am seeking the help of prof programmers.