Search results for query: *

Hello All, I'm hoping someone can help here. I'm trying to count how many times a string occurs in an array. Here is the code I have ... String animals[] = {"Cat", "Cat", "Dog", "Dog", "Fish"}; String animalSingle[] = {"Cat", "Dog", "Fish"}; count = 0; for (int i = 0; i <...

I'm trying to label a chart axis with this ... Set objAxis = xlapp.ActiveChart.Axes(xlValue, xlPrimary) With objAxis .HasTitle = True .Title.Text = "Issues" End With And I keep getting a Unable to get the Axis property of the Chart class, Code 800A03EC. Does anyone haev any idea what I'm...

Hello, I'm trying to find the best way to count elements of an array. I have any number of occurances of dates, such as mm/dd/yy and I would like to count the seperate occurances so that I can plot them on a chart. The data I'm currently working with is; 7/6/04 7/6/04 7/6/04 7/5/04 7/5/04...

Hello, I'm not certain which forum this would go in. So if it's wrong, I apoligize. I'm wondering if anyone has any references to the excel formatting commands that would be used in VBA (or vbscript). I have a script that is working and I would like to add instructions for another...

Hello, I'm getting a "Type Mismatch" in this snippet of code. I'm hoping someone might be able to explain it ... Dim rsTestlog Dim arSta() Dim arVer() Set objFSO = CreateObject("Scripting.FileSystemObject") sSQL = "SELECT Status, Version FROM TestLog" Set connection =...

Hello, I'm hoping someone can help with this formula... =IF(H:H="1.13A",COUNTIF(INDIRECT("D1:D"&L9),"Verified"),0) I count(if) the 1.13A's in the H column and store the number in L9. I would like to count the "Verified"'s in Col D starting at D1 and going to D(whatever is in L9) Thanks in...

Hello, Is it possible to change the structure of a query using VB? In other words, my query has seven fields. Is it possible to add an eighth field with a script? Thanks in advance, JohnCR

Is there a way to use a variable in this string? Something like... sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ= & applipath(errorlog.mdb)" Is there a way for 'applipath' to be a variable which would just hold a path to a folder (and .mdb file)? Thanks in advance, JohnCR

Hello, I'd like to extract data from a MS Access query. Can this be done using a script? If so, does anyone have any examples? I'm trying to get just a date out of the query. I can use a Macro to do this and then run a script to get just the data I need but I'd rather skip the macro if I can...