Search results for query: *

that was it, my connection optionswere messing me up. thanks for the help...

I tried to cut and paste it into analyzer and fill in the values for the variables, it returns the right data, when I check the values of the variables steopping through, it matches the data in the query. It has to be something with the select, something silly, there are no errors but it...

hhmm, to reply to Luis, I tried the ''s around the 1 and no dice. when I step through the code, the variables are correct...I'm not sure what additional debugging you are refering to?? nicsin, If I included the strState inside the quotes it would pass the variable name instead of the value...

I am using this sql statement called from a class module RST.Open "select DISTINCT REPNAME, E_MAILADDR, ILEC, LEVEL] from escalateemail where ilec = " & "'" & strIlec & "'" & " AND " & strState & " = 1 order by [level]", CN, adOpenForwardOnly...

I need to populate some cells in Excel through VB I origionaly use Set sht = wb.Sheets("NameOfSheet") then I poulate the cells I need now I need to change to the next sheet in the workbook. when I use. Set sht = wb.Sheets("NextSheet'sName") I don't get an error but my...

I'm reading a recordset and creating a string to be used in a select case. Do While Not rsT.EOF strLinked = """ & Trim(rsT(1)) & "", " & strLinked rsT.MoveNext Loop I can't get it to give me a string of "rst(1)", "rst(1)", and so...

mabe you could use a flag in addition to your if then statement, then if the event fired and sent it through the loop again you can exit sub

I need to load a rather large recordset (aprox 140,000 records) and populate a flex grid. It blows up at 35,000. Anyone know if that is in fact the max rows count? Any suggestions or alternatives? I can't split the record set.

correction to above. Absolute position is 34997 when error occurs

I'm trying to load a large recordset into a flexgrid. The rec-count is 37214 records. When I check absolute position I'm at 3500 when it blows up giving me the error 7. Could it be this is max records allowed in a grid or could there be a system memory problem? Any help would be greatly...

I use this code to lay out my pagesetup sht.PageSetup.PrintArea = ("A:n") sht.PageSetup.BottomMargin = 0 sht.PageSetup.TopMargin = 0 sht.PageSetup.RightMargin = 0 sht.PageSetup.LeftMargin = 0 sht.PageSetup.CenterHorizontally = True...

the formatnumberline did the trick but the select line got an error. I made it read this and it worked... Sub Format_Sheet() sht = ActiveSheet.Name Worksheets(sht).Range("d:d").ColumnWidth = 15 Worksheets(sht).Range("D3").Value = "CLAIM #&quot...

I need to change the format of a column to "number" from "general" and have not been able to get it so far. Here is the code any suggestions? sht.Range("d:d").ColumnWidth = 15 sht.Range("D3").Value = "CLAIM #&quot...

I need to change the format of a column in excel to "number" from "general" and have had no luck getting it to work. Below is the code. Any suggestions? sht.Range("d:d").ColumnWidth = 15 sht.Range("D3").Value = "CLAIM #&quot...

make that error 440

I'm trying to trouble shoot a program while the designer is on vacation. It's a 3 tier which uses a class to export reports to excel. when I try to step through the code I get an "automation error...This system cannot find the path specified" The code calls a new instance of the...

I have a FG where I need to merge the cells in some of the top rows giving the report name, dates, and when there is no data in the report it says on the last line "NO RECORDS TO REPORT". as I step through the code and use the immediate window I can see the values are correct but the...

worked out great thanks very much!

I am making a function in a class to return 2 fields from a table in SQL 7 this is the code Public Function GetReCurChgs(strCustno As String) As String Dim rsTemp As ADODB.Recordset Set rsTemp = New ADODB.Recordset rsTemp.Open "select chg_desc,chg_amt from rcufil...

I looked at that for a bit however there are still some 13" monitors on our office and with the amount of information entered on each form would be trouble. I can code the forms to resize automatically depending on the other but If there is a way to combine them in one form as sub forms I...