|
Pleeeeeease can´t anyone help me with this, it´s breaking me... Men in long white coats will come and get me soon if I dont solve this problem. = (
|
|
|
|
|
It's tricky to make it seem as though *you* were the one who did it. Here's a starting point- you may already be past this:
1. In Excel, start a macro and then create the chart.
2. Examine the code in the macro generated VBA module.
3. Instantiate the Excel.Application, Workbook, Chart and create a chart programmatically using the macro code as your guide.
It isn't difficult to do, but it will require that you users have Excel on their machines.
Oh, and you can macro copy+paste operations too, in case you want to copy it to an OLE container control or something like that.
I hope this puts you on a track...
David
*->>Always working on my game, teach me
*->>something new.
cout << "dav1d\n";
|
|
|
|
|
I'm using VB6. This is probably a beginner question but I created a group of three radio buttons. They are all part of the same control array. However, in runtime mode, when one of the three buttons is clicked on, the old one that was on remains on. Thus, I end up with two radio buttons that are on/enabled. I thought VB handled this automatically. If not, how do I write code to disable/uncheck the other two radio buttons when one is activated?
|
|
|
|
|
VB handles the WS_GROUP style when grouping automatic radio buttons. It groups by "container" controls like a frame, picture box, the main form, etc. If it's not doing it for you then make sure some of the radio buttons are not in a frame, etc. Or put all of them in a frame, etc.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
This is probably a stupid question but how do I add the radio buttons to a group box. Do you draw the frame first, create option button1 within the frame, then select copy and paste it into frame as part of array element 2? or do you create the 3 options buttons first a part of a control array and then create the frame, put it over the buttons and send it to back?
The reason I'm asking is cuz I had a frame around almost all of my controls and when I tried to put a frame inside of that one to group some radio buttons is when the troubles began. So, I deleted the main surrounding frame but have five radio buttons that I want into two groups/two frames.
|
|
|
|
|
JohnnyG wrote:
This is probably a stupid question
This is not a stupid question. 
JohnnyG wrote:
how do I add the radio buttons to a group box.
Create the frame first. Then, directly creat the radio buttons within the fame. If you create the radio buttons first, you should notice they seem to be behind the frame instead of on top of it and are not grouped by themselves.
Do note that the frame does not become the parent of the radio buttons it "encloses." The parent will still be the form. This is just VB's way of doing the logical grouping. You can override this behavior using raw Win32 API, but that is rarely needed.
And, if you don't want the frame showing up during runtime, set its BorderStyle property to None. Setting Visible to False on the frame will also hide the radio buttons, and the user won't be able to see them also.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
No matter what I do. If there are two groups of radio buttons on a form, they interfere with each other. One group works fine though.
|
|
|
|
|
I have a class in a Class Library project called "Foo". Here is the class...
Namespace Foo
Public Class Bar
Shared Function HelloWorld() As String [...]
End Class
End Namespace
I have compiled this and put the .dll Assembly into the \bin directory of a 2nd project.
Project 2 is called HelloWorld2 and is a Windows Application which has a reference to the Foo.dll assembly added to it.
Problem is the Import statement I need to use to access HelloWorld.
I would have thought it would be
Import Foo
...
Public Class Form1
....
Private Sub Form1_Load(...) Handles MyBase.Load
labal1.Text = Bar.HelloWorld()
End Sub
End Class
End Sub
But it seems I have to do
Import Foo.Foo
Why the extra Foo?
Bah humbug!!
|
|
|
|
|
I had the same problem recently. But I thought it may have been to do with the fact that I already had a namespace called Foo in an existing C# library.
Kevin
|
|
|
|
|
Hi - I'm not much of a VB programmer, more VC++, so a little help is much appreciated. could anyone provide some links for tools that detect memory leaks in vb (i don't see anything native, like in the vc++ devstudio.), or better yet, some sites that show proper coding styles in vb to avoid it?
Marcus Spitzmiller
|
|
|
|
|
Has anyone out there developed an enhanced console class for VB.Net
What I am specifically needing is a ClearScreen and the ability to cut and paste to the clipboard from inside a console mode app.
I also would like a method to put shutdown code in when the user closes the console mode app from the upper right hand X.
In the good old days console mode apps automatically made use of ANSI.SYS escape sequence.
Can VB.Net console class be enable to use these sequences
I have read that the console mode class was made such that you can not derive a new class from it and add additional methods.
|
|
|
|
|
If so, any fixes?
~Timothy T. Rymer
http://tim.xpertz.com
http://www.digipen.edu
http://www.ttrx.com
|
|
|
|
|
MSDN says there is a limit of 32,000 unique identifiers, variable names, module names, etc. in a VB 6.0 project. Is there any way to tell how many I have in a project, other than going in and actually trying to count them manually?
Thanks
|
|
|
|
|
?????
~Timothy T. Rymer
http://tim.xpertz.com
http://www.digipen.edu
http://www.ttrx.com
|
|
|
|
|
Dim x As Double
x = 14.94560958345
x = Round(x, 2) Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Thanks...
~Timothy T. Rymer
http://tim.xpertz.com
http://www.digipen.edu
http://www.ttrx.com
|
|
|
|
|
Here's my problem.
I wrote a bunch of stored procedures on a sybase database and I want to be able to trigger them from vb.
How do I connect to the database through vb, and how do I call a stored procedure passing in variables? I'm doing this all in a module, so no visual cover. Any ideas? 
ICXC
NIKA
|
|
|
|
|
Read up on ADO in MSDN. That is one way of doing what you need. I am assuming the appropriate drivers are available. I have never used Sybase myself but see no reason why ADO and ODBC will not let you connect. There are sevral examples in MSDN.
Try:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/dasdkadooverview.asp?frame=true
There are also many articles on CodeProject discussing ADO.
|
|
|
|
|
Use a command object, or wite the SQL yourself e.g.
strSQL = { CALL myStoredProcedure ('txtParam', 'numParam', #01-Jan-2002#) }
If the SP returns a recordset then
dim rs as new adodb.recordset
rs.open strsql, cnn, ...., ....
|
|
|
|
|
I have connected to Sybase from VB using DTS on MS SQL Server; the only problems i really had was datatypes. Money doesn't equal money, etc.
Here is a bit of my code. It's much like connecting to any other ADO or ODBC device.
<br />
Set oConn = CreateObject("ADODB.Connection")<br />
oConn.Open "Srvr=[servername];Driver={SYBASE SYSTEM 11};uid=[username];pwd=[password];"<br />
And yes you have to have the proper drivers installed on your machine to connect to sybase.
Real programmers don't document. If it was hard to write, it should be hard to understand.
|
|
|
|
|
Does anyone know how I can turn off the auto-compile feature in VB.NET?
Thanks
|
|
|
|
|
How can I programmatically check if a certain Windows component (e.g., Dial-Up Networking) is installed?
Is there a way for a VB program to launch the installation process for a missing component?
Platform differences?
Anyone?
A reasonable man adapts himself to the world. An unreasonable one persists, trying to adapt the world to himself. That is why all the progress in the world depends on the unreasonable men.
|
|
|
|
|
I'm not an expert but wouldn't you just create a component via its ProgId which you can lookup with the OLE/COM viewer in VC++? It's also known as the OleView tool on Start Menu | Programs | Microsoft Visual Studio 6.0 Program | Microsoft Visual Studio 6.0 Tools submenu.
e.g. Set objScripObj = CreateObject("MSScriptControl.ScriptControl.1")
Just trap the error (On Error....) if the Set statement fails, then it is not installed on the system or in the registry. As far as installing a missing component, you would have to provide it since it isn't already installed and if its the DUN object, I don't know about the compatability between different Windows OS.
|
|
|
|
|
Helo
I want my VB.NET app to have the same good looking MainMenu as in Visual Studio.Net.
Is it a add-in component or avilable as default?
/Knappen
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
