Search results

Hello Arnel, I already solved the runtime error. It's a user error. Hehe. Will do a full test to my database. Regards,

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 dave, it's ok, no worries and thanks :)

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.

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 realized that my question is quite vague... haha... anyway, many thanks for the explanation. Gemma is right that I want to know what is the importance of codes inside the parenthesis.. Will do my research now for byref and byvals.. Cheers, vash

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

Ok, Many Many Thanks for all your help :) :) I'll be just tweaking this MS access for it to be user friendly... Cheers, Vash

Hello Plog, I used the Query Criteria and it works now, please disregard. :) Only that the query is slow to gasp. :( But if you can advise the best way (speed up) thru that created function it's very much appreciated. Thanks. Cheers, Vash