Search:

If I understand it correctly now, I have to compile the graphics library with the build--so far no luck with that....

Hey all--I built a process control prgram which uses MSChart20, and it performs beautifully on my computer. However, when I tried to run it from our server, I got this error:

Could not load file...

I've tried trimming the text, but for some reason, the white text rectangle extends way beyond the text of my checkbox when I create it dynamically. I'm creating a tight array of checkboxes--does...

sometimes the value is null though--in which case that would throw an error (i think). jmcilhinney gave me a good method, although my compiler wouldn't accept isNullorEmpty, so i made my own method...

Thanks--that saved me a lot of time and MB.

and sorry, add a .tostring() on the end of the second conditional on the first block.

I constantly find myself having to do code similar to the following.


If Not Trim(parameters.Rows(0)(5 + num* 6 ) is Nothing
If Not...

Wow...that's all it took. Thanks!

I'm programatically creating labels in programatically-created panels, and have run into an issue--the label's information isn't completely showing! COnsistently only the first few characters are...

This has been so frustrating to figure out, no one seems to answer the question.

I'm trying to find the value 2 cells to the left of whatever cell contains the value of A1. THe closest I've gotten...

I did and it suddenly didn't like the executable = System... line

error: The specified executable is not a valid Win32 application.

I assume since its a perl program (which is native to unix,...

I run a program based on a timer in VB.NET, and it executes just fine when I don't try to retrieve the output. For some reason, though, I constantly get an error on the Dim myOutput line... Can...

Yes, how do I log the sql queries that the update command prompts?

I'm currently tracking all database updates (which are done with dynamic sql or stored procs) via a separate sql table which stores the query, windows user, and time of request. However, I am having...

I'll let you know the precise error and upload the relevant code tomorrow. My spreadsheet is populated by sql queries so I can't access it from home

Nevermind, I tried it with an array of 200 rows and the program bugged out. I'd read there were problems like this with arrays--the array can only get so big before it doesn't work anymore. I guess...

Thank you that worked very well.

Thanks--but I'm dealing with thousands of datapoints, and I know that series notation is capped at 275 characters or close to that.

I'm trying to use the difference in values between two ranges as a range--the following code should convey what I'm trying to do, but VBA doesn't accept it. Is there a way to make this work without...

got it

http://pubs.logicalexpressions.com/pub0009/lpmarticle.asp?id=590

I can't seem to get my area charts to stack up right. I'm graphing an spc (statistical process control chart) and want the area between line graph series UCL and LCL to be white (as that an...

I'm using sql server 2005.

The way I worked around this before was simply running the indistinct query, then deleting from my datagridview the duplicate entries--but this is obviously pretty...

I keep getting this error
The text, ntext, or image data type cannot be selected as DISTINCT.

on this code:


cmd.CommandText = "SELECT DISTINCT [Priority], [Priority Status], [Tool Type],...

'-- Ion mill
number = 20
Worksheets("Ion Mill").Activate
With Worksheets("Ion Mill")
MsgBox .Range(Cells(number, 1), Cells(number, 1)).Value
While .Range(Cells(number, 1), Cells(number,...

But if I type Worksheets("*Worksheet name*).Activate before the code, it works. Do I need to turn something on/off? I thought you didn't have to activate a worksheet to retrieve/import values...

wow...I kind of tuned that out. Yes now I'm getting sql exceptions, which means this issue is solved haha. I should have realized that earlier

Sorry--i'm behind on this thread (so many questions pop up moving to vba that books don't answer). I ditched the declaration in the workbook activation and initialized the form with...

Just did and I still get the object error. I feel like i have to declare it (i would if it were .NET).. but again, it bugged when I declared adocn as new connection.

Alright I put this:


Dim connstring As String
connstring = "DRIVER=SQL Server;SERVER=IRNTS4SQL;UID=" & Environ("UserName") & ";APP=Microsoft Office 2003;WSID=" & Environ("UserName") &...

I created (and hid) a userform at workbook initialize. I now need a control on a worksheet to toggle the visibility of the form, but I have no way to refer to it. How do I do this?

Under workbook...

How do I populate an excel combobox with data from a Sql database? I have to use excel so our company browser can support it.

I agree. Since I'll load this form with the workbook, I'm not going to implement activate or initialize, but will set the defaults from the worksheet load sub.

On second thought, since I need this form to house information even the command button is not clicked, I think I will render it invisible (and visible on button click). I'll set the parameters from...

Thank you for your response. I am using excel 2003--I thought the sub was called on the userform's loading (called by a command button--I would add the code there but this userform can be called by...

I don't know what the problem is--this code exists to establish default values when this userform is loaded (from excel). I can't get the system to recognize the event. (I also used Private Sub...

"ODBC;DRIVER=SQL Server;SERVER=IRNTS4SQL;UID=" & Environ("UserName") & ";APP=Microsoft Office 2003;WSID=" & Environ("Username") & ";Trusted_Connection=Yes"

--I obviously changed out my windows...

I looked there, but they didn't work. I figured it out by recording a macro and connecting--if anyone else has this problem, I would recommend using record macro and looking up the connection string...

For some reason I get an 'automation error' (with code as is or with 'Driver = {SQL Server}' included) or multi-step OLEDB operation generated error with (provider = OLEDB). I can't figure out what's...

survey says, yes. Alright then, thanks for your time.

Okay, I messed up. While there was no tab stop on the panels, they were still somehow grouping the controls together and messing up the tab order. I removed the panels and it followed the proscribed...