Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 29
Search took 0.02 seconds.
Search: Posts Made By: vash011390
Forum: Modules & VBA 02-10-2016, 09:17 PM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

Hello Arnel,

I already solved the runtime error. It's a user error. Hehe.

Will do a full test to my database.

Regards,
Forum: Modules & VBA 02-10-2016, 08:02 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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
Forum: Modules & VBA 02-10-2016, 04:51 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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.
...
Forum: Modules & VBA 02-10-2016, 12:01 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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.
Forum: Modules & VBA 02-09-2016, 06:06 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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...
Forum: Modules & VBA 02-09-2016, 05:07 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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...
Forum: Modules & VBA 01-31-2016, 08:55 PM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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
Forum: Modules & VBA 01-31-2016, 07:06 AM
Replies: 16
Views: 2,129
Posted By vash011390
Re: Networkdays in Access but Using Global Holidays

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...
Forum: Modules & VBA 01-30-2016, 06:17 PM
Replies: 16
Views: 2,129
Posted By vash011390
Networkdays in Access but Using Global Holidays

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...
Forum: General 11-23-2015, 05:40 AM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

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...
Forum: General 11-23-2015, 05:19 AM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

Hello dave,

it's ok, no worries and thanks :)
Forum: General 11-23-2015, 12:37 AM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

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...
Forum: General 11-22-2015, 05:45 PM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

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...
Forum: General 11-22-2015, 07:38 AM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

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...
Forum: General 11-19-2015, 03:40 AM
Replies: 11
Views: 674
Posted By vash011390
Re: Simple Variance Composition Generator

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.
Forum: General 11-11-2015, 01:31 PM
Replies: 11
Views: 674
Posted By vash011390
Simple Variance Composition Generator

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...
Forum: General 08-26-2015, 12:17 AM
Replies: 5
Views: 764
Posted By vash011390
Re: Arguments on Subroutine or Function

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...
Forum: General 08-25-2015, 11:29 PM
Replies: 5
Views: 764
Posted By vash011390
Arguments on Subroutine or Function

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
Forum: General 07-30-2015, 07:40 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Ok, Many Many Thanks for all your help :) :)

I'll be just tweaking this MS access for it to be user friendly...


Cheers,
Vash
Forum: General 07-30-2015, 07:33 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

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...
Forum: General 07-30-2015, 07:21 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Hello Plog,

I've managed to plug the code on VBA but the Remarks are not filtered per Chartline. I know I am missing something but I cannot figured out how to use the "Filter" part of the syntax....
Forum: General 07-30-2015, 05:58 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Oh my, :confused: but it must be in a single field also.
Can you help?
Forum: General 07-30-2015, 05:45 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Hello Plog,

This is amazing :) :) Everything that I need is here!
There is one more thing, how can I managed to build a query out of that Variance Table that produces the Variance...
Forum: General 07-30-2015, 05:12 AM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Hello Plog,

Ok, apologies.
Can you check if I made the right Totals Query?

I attached again the file and combined the two excel sheets.

Cheers,
Forum: General 07-29-2015, 09:24 PM
Replies: 15
Question Variance File
Views: 863
Posted By vash011390
Re: Variance File

Hello Plog,

Thanks for the quick information.
I somehow managed to create cross tabs. These two cross tabs produces the sum but only for a specific chartline (as the other chartline serves as a...
Showing results 1 to 25 of 29

 
Forum Jump



All times are GMT -8. The time now is 05:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World