owuraku
Last Activity: Nov 18 '08, 02:58 PM
Joined: Jul 14 '08
Location:
-
Thanks y'all I got it to work. Used the Recordset technique. Extracted the data from a query and then used to a For Loop to copy it into specified cells. -
I have been able to create the excel sheet according to the following specification:
[1] When the code is run the first time in a year, an excel spreadsheet is created which contains 12 worksheets, for each month of the year.
[2] Whenever the code is run again, data should only be added to the existing spreadsheet, no new excel workbooks should be created.
Now what I need is to transfer data from ACCESS to a specific...Leave a comment:
-
Dont bother y'all. Figured it out!Leave a comment:
-
Create 12 worksheets named after each month
Guys this pretty straight forward. I have a code that generates only the first three worksheets and names them after the first 3 months. I want to extend it to include all 12 months.
Here's my code:
Code:Sub Mnth() Dim i As Integer For i = 1 To ActiveWorkbook.Sheets.Count Sheets(i).Name = MonthName(i) Next End Sub
-
Oh I probably didnt mention this but the coding should be done in ACCESS VBA.Leave a comment:
-
\
Basically I need a code translation for the skeleton I generated. So in a way I suppose it will be a "lets do it, see if it can be done" type of question....Leave a comment:
-
Creating Excel Worksheets based on conditions
At the end of each year (i.e. on every December 31) I want to create a new Excel Workbook (spreadsheet). Thus on December 31, 2008, I want to create a workbook called 2009. Now at the day 1of each month in 2009, I want to create a worksheet named after that month. So for on Jan 31, 2009, I want to create a worksheet called January in the workbook 2009. Clearly I have to use a loop to generate the worksheets but I will go a SELECT CASE instead. Also... -
My first ASP.NET project
Hi fellas
So I am a newbie with ASP.NET and I have been recently assigned a website development project.
So here's what I have to do:
In my department we usually send out reports to investors at the end of every month. These reports are sent out via email. What I want to do is to create a webpage portal that will:
1. Allow these reporters to go in and send emails to their investor
2. Track which... -
Transposing cells in Excel
Hi guys
I am have two excel workbooks. One book has data formatted according rows. Example:
The other book needs to be formatted so that it contains a column that looks like:Code:ROW 1: Loan # ; Principal Amount ; Interest Rate ; Date
...Code:COLUMN: Loan # Principal Amount Interest Rate Date -
Do I need ASP for this project??
I am a newbie with ASP. I have a website development project that I am working on and I have a feeling it might require the use of ASP.NET I might be wrong but it's just a hunch.
So here's what I have to do:
In my department we usually send out reports to investors at the end of every month. These reports are sent out via email. What I want to do is to create a webpage portal that will:
1. Allow these reporters... -
Thanks Mike. Apparently you had the right idea all along, and it eluded me somehow. Since I had "Const" infront of FILENAME, and the value of FILENAME includes a variable string, the resulting value of FILENAME was nonexistant. VBA couldnt interpret it as exisiting. Debugging the code line by line, I realized that the value of FILENAME was empty. So I took out the "Const" from infront of FILENAME and voila!!!...prob lem solved!!...Leave a comment:
-
Hmmm...you've got an interesting observation for point # 1. The problem is that the code doesnt generate any errors but it JUST WONT OPEN the specified database when the button is clicked. Basically the button doesnt show anything when it is clicked....Leave a comment:
-
The problem is that the code doesnt generate any errors but it JUST WONT OPEN the specified database when the button is clicked. Basically the button doesnt show anything when it is clicked....Leave a comment:
-
Calling specific Database to open
Hi fellas
I have a list of Databases named to reflect the current working month and year. Each month a copy of the past month's database is saved and the name is changed to the present month. For instance last month's database was named DBS0808, but this month's is named DBS0908.
I have a code attached to a button in a security database that opens another database when the button is clicked. My issue is that I am trying... -
Disabling and Enabling Form buttons
I have a table with a field called DEPT_ACCESS. I also have a form called FRMACCESS with 3 buttons called DEPT_1, DEPT_2 and DEPT_3. I want to write a code such that when a user from whose DEPT_ACCESS is 1 opens the FRMACCESS, only the button called DEPT_1 should be enabled. Similarly, user whose DEPT_ACCESS is 2 should have only button called DEPT_2 enabled. The same criterion holds for user with DEPT_ACCESS 3. The name of the table is called T... -
Thanks Bud!!! You're gem. Although the code did not meet my exact need, it pointed me to where I wanted to get. I tweaked it a bit to serve my purpose. Here's my code:
...Code:Function RunMacro() Dim dte As Date dte = DLookup("[RecertDate]", "tblRecertDate") If dte = DateValue(Now()) Then DoCmd.RunMacro "RecertMacro" End If End FunctionLeave a comment:
-
Thanks Bud...
That worked!! Guess I didnt need a loop function after all. Now another problem building off of this one is that I need to run a macro based off of the date in this table. Since the table data is going to change once every 3 months, I want to write a code that starts off the macro once every 3 months. So if the table data reads 10/30/08, the macro should run on this date; and the procedure should reference the table data....Leave a comment:
-
Here's the break down of what the table's supposed to be doing:
At Today:
The value of cell = 6/30/08 + 3 mnths = 9/30/08
At 9/30/08 (Current system date at the time):
The value of cell = 9/30/08 + 3 mnths = 12/30/08
.
.
.
.
At nth day/30/mth year:
The value of cell = n/30/m + 3 mnths = (n+3)/30/m
From the above, the table would not be due for an...Leave a comment:
-
Thanks Janders, I had thought of recordsets and SQL too. With recordsets, I havent really worked with them enough to be able to implement them into my code. As for SQL, can you tell me how I can incorporate the "DO WHILE" loop into it? I know I can do a regular UPDATE query but my problem has to do with the loop...how do I loop in a query??
PS: And yes. My table is STATIC!...Leave a comment:
-
PS: tblDate.ChngDat e has a starting value of "6/30/08". And I have modified the code from previous post to make question a lot clearer....Leave a comment:
No activity results to display
Leave a comment: