Search results for query: *

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...

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...

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

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...

I need to be able to send outlook mail as the delegate of someone else via code. (I have permission in outlook and can do this manually) How would I modifiy the sample code below to allow me to send From: someone else? Sub SendMessage(DisplayMsg As Boolean, Optional AttachmentPath)...

I have a access database (a report scheduling application) that cycles through a recordset and opens various access databases on our server created by other developers and runs reports from them on specific dates. My problem is that shellandwait won't work since the calling application is...

I am not a sybase expert but this query would work in oracle or access but doesn't work in sybase. SELECT SW_CASE.swCaseId , DS_SURVEY.gr7RootCause, SW_CASE.grKeyword1 FROM SW_CASE , DS_SURVEY where SW_CASE.swCaseId *= DS_SURVEY.swCaseId and SW_CASE.swDateCreated Between '9/1/2002' And...

I have a problem. I can't use 'exists' as it is not available in the particular software I am using to write this thing (MS Access). I can get around this problem by using a passthru query and using exists but have two trainees that can't. Why do the two queries below return the same results...

Could someone help out a newbie with a bit of sql? I need to be able to calculate the previous weeks dates (Sunday through Saturday)no matter what day I run a report using a between statement. (Between 07/28/02 and 08/02/02) Thank for taking the time to read my post! Trisha padinka@yahoo.com

Help me...My detail section of a report is sometimes printing the labels of the last line of the previous page at the top of the next page. The data is not printed on the second page. Anyone have any idea what's going on... Example: Page 1 (Last Line) Label1: Text1 Label2: Text2 Page...

I have a report that checks for a certain value in the data via vb. If the value is there, I wish to stop the report from opening and prompt the user to fix the problem. How do I do stop a report from opening. Trisha padinka@yahoo.com

I have a report that contains some text boxes for very large memo fields. Can grow is set and majority of data is output but sometimes report doesn't output last few characters for a record. It's almost like it didn't grow enough. Some text boxes are many many lines long but it still...

This function takes a several records and appends them together in a single string separated by commas. Function Attached_Cases(myTicketId As Long) As String Dim dbs As Database Dim rst As Recordset Dim strSQL As String Dim fld As Field Dim myLen As Long Set dbs = CurrentDb()...

How do I write code to modify a date/time field to a date/time field with a "short date" format using VBA or sql? Trisha padinka@yahoo.com

This is a sampling of my data. BU Invoice Dept DateOccurred ServiceRestored EAST 100110125 1 8/23/00 10:20:00 AM 8/23/00 10:33:00 AM EAST 100110125 2 8/23/00 10:24:00 AM 8/23/00 10:46:00 AM EAST 100110125 3 8/23/00 10:26:00 AM 8/23/00 10:30:00 AM EAST 100110125 4 8/23/00...

In Access 97 I have 5 retention folders (Daily, Weekly, Monthly, Quarterly and Annual) for data storage. I need to be able to search through the folders and delete files bases on our retention schedules (Daily folder(1 week), Weekly folder(2 weeks), Monthly folder (3 Months) etc) for a...

In Access 97 I have 5 retention folders (Daily, Weekly, Monthly, Quarterly and Annual) for data storage. I need to be able to search through the folders and delete files bases on our retention schedules (Daily folder(1 week), Weekly folder(2 weeks), Monthly folder (3 Months) etc) for a...

I need to get an Excel VBA macro to run a VBA module in an access database. Can someone give me some code???

I need to get an Excel VBA macro to run a VBA module in an access database. Can someone give me some code??? Or even a place to start looking.

I need to get an Excel VBA macro to run a VBA module in an access database. Can someone give me some code???