Search results for query: *

Thanks enigma, There's a problem in creating .exe file since I'm using VBA with my excel application and not VB. I have tons of code written in VBA..how easy would it be to convert that to VB? Thanks

Hello everyone, I have an excel application that needs to be accessed remotely through citrix by 100 clients. Is this technically possible ? Please advice.

Hello, I have a query in access that gets the records of 35 soccer players (The fields are ID, Name, age, #, paycheck amount). Now each month I run my query, copy and paste their records to seperate pages where I show all the fields as well as total amount Year to Date. Is it possible to have...

I copied this code from the forum. There's a problem on this line: dtmTemp = DateAdd("d", 1, dtmTemp) what's wrong with it. Tks Public Function NextWorkDay(dtmDate As Date) As Date '**************************************** 'Created By: Robert L. Johnson III 'Mod Date...

This is my first module it works perfectly. I wrote it myself. It returns the number of businessdays between 2 dates. The holidays dates were entered manually for 2006: The second module is below it (I copied the code from the forum)and is not working properly. It should return the ending date...

Hi, I'm trying to write a query that does the following: First:Assume today is the 10th of january get the total volume generated from the beginning of this month until today's date. Do the same for the previous three month and then get the business days and compare the volumes based on that. I...

Hello everyone! I need help figuring out this: I want to return the total volume generated based on these periods: the beginning of this month until today's date (say for example today's date is the 15) then the beginning of the past month until the same date as today of the last month (which...

Hi, Can someone tell me how many records can access 2002 handle? Thank you

Tks

Hello, I'm new to access. How can i set a field to 1 if value is null, otherwise set to 2. Thanks

Hello, I'm running a Select query that is not showing a specific row. That's because all the values are eqaul to 0 in that row. However i want it to show the 0 values because i'm exporting the data to Excel. how do i do i make show the entire row with 0s. Thank you in adance..

Hello, I inherited an access file with bunch of tables and queries and there's no documentation whatsoever. I have a table created using a query. Can I possibly find out which make table query created that table? Thank you

Hello, Can you refer me to any website/tutorial where i can learn Essbase financial reporting? Thank you

Hi, Tks for the help but there's an If statement! I want to check in my module if a specific day is a business day or not. so if i have in a table a date such as 1/16/2006 and i write in my module If DatePart("y", Date1) = 16 would it recognize that date as a holiday (for sure after the...

If (DatePart("w", Date1) = 1 That means of the Day is Sunday ! What about If(DatePart("y", Date1) = 16 (Does this indicate that the day = Martin L King Day) ?? Thank you

Hi everyone, I'm trying to create a HolidayDays function in VB that i will be using as a Module in my database and it basically needs to return the # of business days between 2 dates correctly if there's a holiday in between. Ex: Businees days between July 3 and 5 should be 1 and not 2...

Hi everyone, I'm trying to run this query and it runs fun but returning the wrong results. I need to use Distinct on count in access and i don't know the syntax. if i add DISTINCT before count it does not work! Do i need to use a subquery? Any ideas.. Tks in advance SELECT D.DayOfYear...

Hi everyone, I have a table similar to this one: Salesman_ID .............HireDate.......... Qutting Date 123454 ..................1/1/2006 333365 ..................2/3/2006.............4/5/2006 4546463..................5/6/2006 325535 ..................4/8/2006 I need to return each day of...