Search results for query: *

I notice you a function in here called stuff(@sumfunc, len(@sumfunc), 1, ' END)' ) Can you give me details about this Function. THank YOu ITM

In Access you can create a Cross tab query, which is basically a Pivot table in Excel. This si the code that Access generates fro one of my queries: TRANSFORM Sum([Summary 3].[ESC ADV BAL]) AS [The Value]" & _ "SELECT [Summary 3].[INV GROUP3], Sum([Summary 3].[ESC ADV BAL]) AS [Total Of ESC ADV...

...be done with SQL Server. Currently I use something like this to import an Excel sheet to an Access Database table: StrSQL = "SELECT [Summary$].* INTO [Escrow_Avdvance_rtp1] FROM [Summary$] IN '" & FileName2 & "' [Excel 8.0; HDR = YES;];" Cn.Execute StrSQL Or something like this to get data...

I appreacite everyones help, but unfortunantly I can not install and Un install apps at work; and i can nt request this for everyone at the job. But I know I once saw this API call and it solved the problem, I quess I will keep Looking. Thank You ITM

Hi, I have code that opens Excel and inputs data, but some times it gets hung up because Excel is left runing in the backround. ANd my code has xl1.ActiveWorkbook.Save xl1.Quit which seems to do nothing. Is there any way to kill the the excel process, before I run my code, that may be left...

No that surprises me too, but as you can see in me question I do have that, and it still does not work. But if I move it ot a vb program it works fine. I have seen this before and I heard that there is a an API function that handels this. Thanks ITM

No if I use this samwe code like I ma doing now it runs just fine. But there is something Access, maybe sharing the same dills as Excel, that this happens here. I heard that htere is an API call that you can use to turn off process. Or something like it, but I am not sure wwhat. ITM

Hi, I have code that opens Excel and inputs data, but some times it gets hung up because Excel is left runing in the backround. ANd my code has xl1.ActiveWorkbook.Save xl1.Quit which seems to do nothing. Is there any way to kill the the excel process, before I run my code, that may be left...

Thanks that worked. ITM

Hi, I am writing out a sum of cells, in an Excel spread sheet, from my VBA in Access. It will go through a loop first summing C4:C11 and then D4:D11 and so on. Each time this will be different, the program figures out how far it will go. In any case I need to do something like this...

Thanks again ITM

Thanks Golom, That worked. I was wondering though if you can tell me what the this pice of code you wrote does: Rs.CursorLocation = adUseClient ITM

TO fredericofonseca: Thankl you I ddid not see that, but the code worked if I did not use the Loop and the array There must be some way to get the array in there to work. Isin there? ITM

To Golom:You are right, as you can see in my code, I have an Rs.State stsatement which is telling me tha tthe Rs is not opening. But what can Ido to make this work. I am trying to use an array to Also, to DrJavaJoe, you are right this is not the best code but it works and I am trying to stream...

Hi, I tring to use an array the different catigories listed below. I got htis code work if I do it without loops, but that makes it really long, because I have a number of these. However, the problem that I am having is that it is not excepting the array in the sql statement. I know this...

Thanks that worked. I really appreciate it. By the way how do put the code in the text box like you when you answered my question. ITM

Hi, This code part of a large program that I am developing and I have used this extensivly through out the program with success. However, here it is not working because I hve LOAN_TYPE = 11 FHA. I know this is the case because if I take out the where clause it works. If I set it to not Null it...

Hay it works. When RoyVidar said that I sould use brackets Itryed that and it did not work, but when I tryed changing the name all together it worked. Thank you all for your help I really appreaciate it. ' thank you ITM

No I still get that message and not results. But that was a good try. thank You ITM

Yes at one point I had everthing in brackets. that is table names and fields; but still nothing. ITM