Search results

oh yea by the way, you probly won't need the doevents funciont, as I said I had ALOT of records to go through with this:)

I used the following code to get rid of that While InStrRev(arrData(3), Chr(44)) DoEvents arrData(3) = Mid(arrData(3), 1, (InStrRev(arrData(3), Chr(44)) - 1)) & Mid(arrData(3), (InStrRev(arrData(3), Chr(44)) + 1)) Wend arrData is an array of strings, you can use any...

I apologize, but i do not follow you:( I have figured out how to use code, on the activate event. I will have to put it to a button or something, but for now this is a start. Dim I, J As Long Dim lngBranch, lngCust As Long Dim dblTotalPrice As Double Dim strCurrent, strMonth As String...

here is a description of my excel file. there are 12 worksheets, each representing a month. each of these worksheets has 3 columns branch, customer_no, price I have a 13th worksheet for totals. I need to get the total price for each month/branch/custom. example output month branch...

yes it should:D

You are very welcome. Glad to be of help.

Can you post the lind where you are declaring stLinkCriteria? If you are not declareing it, you can try putting dim stLinkCriteria as string right under Dim stDocName As String or you could even use somthing like Dim stDocName, stLinkCriteria as string

I would suggest to just find the variable that is not declared, and declare it. But you can usually remove the option explicit without any problem. Any variable not declared will be assumed to be a variant type. this is normally not a problem, unless you try to do this with large arrays, then...

hmm sorry bout that last post, that was wierd, I was looking at a different message, and when it posted, it put it here:( very odd indeed:(

I would suggest to just find the variable that is not declared, and declare it. But you can usually remove the option explicit without any problem. Any variable not declared will be assumed to be a variant type. this is normally not a problem, unless you try to do this with large arrays, then...

did you put in option explicit If so then you will have to declare all your variables, or remove it. I do not know of anything else that would cause that error, off the top of my head

on ething that may make it alittle easier to find the error is to copy your sql statement to a string like strSQL and then run your command like MyQry.SQL = strSQL Then you while in run time you can put strSQL into the immediate window to see what the actual SQL statment is running. That...

I think you will want to change aglh() to GetAGLH() as that is your sub name.

I used the following code to find comma's in a string and remove them, but you can use something similar in your case. <code> While InStrRev(arrData(3), ",") DoEvents arrData(3) = Mid(arrData(3), 1, (InStrRev(arrData(3), ",") - 1)) & Mid(arrData(3), (InStrRev(arrData(3)...

Worked like a charm, thank you.

Worked like a charm, thank you.

I have a program that is pulling data, and for reasons of speed and memory I decided to use comma delimited files to store the data. This then does some calculations on the data and then exports the data to an excel sheet for a report. The problem is that one of these files is over 200MB in...

hmm I though /code worked, can someone tell me what it is supposed to be?

ok this was a complete disaster. I tried just running the queries given, and had to kill them after they were running for over 18 hours. I decided to create a form with a label, and a command button. The code behind this form Created my results in less than an hour. I am posting my code here...

ok well it was a linked table, but as I do not have much access to run queries on the server, I brought it to my machine. It is a simple one single table. What I am trying to do is to find duplicate data. It is indexed. The key is mfrno and itemno, the other data is a obsolete_code, and a...