Search results for query: *

oops, ignore the "FETCH NEXT FROM ECL_CURS INTO @DATE_BEG,@DATE_END,@DATE_MID,@DATE_NAME" That should be commented out. I took all the commented out lines out of the thing and apparently skipped deleting that line. Trisha

Ok, I've taken out the data manipulation and left the main loop inserts. ---------------------------------------------------- SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[DEV_AL_ECL_TEST_PROC] AS DECLARE @DATE_BEG DATETIME, @DATE_END DATETIME, @DATE_MID...

Yes, I can post it but it's 2200 rows. That's why I didn't post it. It builds a single data warehouse table from a large number of source tables. I inherited this monster and I've sped it up considerably in that 4 mins to build and insert the first month is a huge improvement. But, now it...

I have a table that I build monthy that contains 22 million rows. I use a while loop that inserts a month of data at at time which is about 400 thousand rows to 500 thousand rows for each month. Takes about 4 minutes for the first loop and increasingly takes longer with each loop. It takes...

I'm sorry but I can't duplicate your problem. When I run the code, it correctly selects I2. You could try: Application.Goto Range("I2") I doubt it will help but maybe. Trisha padinka@yahoo.com

Well, that is good for the example but I'm looking for something a little more broad that would work regardless of the titles or whether they had 3 columns or 60 columns of data. Basically to copy the entire row. Trisha padinka@yahoo.com

Can someone help me with this? I need to take large files, which are sorted by area and split the rows for each area into individual workbooks. Area City Dollars AL Bham 5 AL Mnt 10 AL Hunt 5 TN Nash 6 TN Memphis 5 This would produce two workbooks, Alabama with...

Can you see the file dsn from both computer's odbc setup? File DSN are stored locally in C:\Program Files\Common Files\ODBC\Data Sources. Try copying the file there on your user's computer. Trisha padinka@yahoo.com

How are you setting the printer? Trisha padinka@yahoo.com

Take a look at excel pivot tables your access database as the source data. You could add your branches as a "Page" section and it would allow you to report view each branch separately or all the branches together. To update the report you merely have to open it and 'Refresh' the pivot table...

Have you looked at this? http://support.microsoft.com/kb/q131534/ Also, if your report runs at specific intervals, weekly, monthly, etc you can caluclate the dates in the stored procedure instead of manually entering the dates. Trisha padinka@yahoo.com

I need to search for a set of specific infomation stored in, for example, table1.findme in a second table table2.lookhere which is text and the data may be anywhere in the field. Any ideas? Any one of the table1.findme records may be in a single table2.lookhere record. Trisha padinka@yahoo.com

Wow. That was a long time ago. You just need to do an outer join on your query. In the example I gave, a RIGHT JOIN. Copy and paste the query into your database and run it. It should give you a sample query. I used the table names and the field names that you gave me. I didn't Count the...

A couple more questions. Does a file go to more than one person and what mail program are you using? Trisha padinka@yahoo.com

I'm getting a type mismatch error at: For Each r In .[IP] Trisha padinka@yahoo.com

Jill, What is your table name, I will take a look at this as I send stuff with attached files programatically all the time... Trisha padinka@yahoo.com

I have two spreadsheets. Servers and Application. I need to look at a column called IP in the server speadsheet and see if the IP has a Match in the Application spreadsheet's IP column. If so, move to the next row. If not, then I need to look at a different column of the same row called...

try doing this in a module: Call Shell("fullpath\excel.exe path/filename.xls", 1) where fullpath\excel.exe is the full path and filename of your excel program and path/filename.xls is the macro file you want to run and your macro should be named Auto_Open in the file. (To edit a...

I have been working with access since 2.0 beta. I don't agree that access runs 'better' locally. Faster maybe but each user running an individual copy places some strong programming limits on you. I read your 'ten commandments' and agree with them but I don't see where it states in them that...

SELECT essays.essayID, Count(sales_details.Essay_ID) AS TotalID FROM sales_details RIGHT JOIN essays ON sales_details.Essay_ID = essays.essayID GROUP BY essays.essayID; Trisha padinka@yahoo.com