|
This is to all the excel geniuses, am trying to limit the lenght of text in a dailog box(in excel) if you think u can help plz reply
Thanks
|
|
|
|
|
I assume you are using a textbox. Just set the MaxLength property to the length you need. You can do this in the properties window (right click the text box and select Properties) or in code (Userform1.Textbox1.MaxLength = xx in the initialize procedure).
|
|
|
|
|
How do you create a new User Defined function for Crystal.Net?
|
|
|
|
|
|
I want put array of 400 byte into a field in Access Table from my code (VB).
How ???
|
|
|
|
|
I'm new to VB,anybody can tell me how to add items(root,and child) to a TreeView control?
thanks
|
|
|
|
|
TreeView1.Nodes.Add , , "root", "Root Node"
TreeView1.Nodes.Add "root", tvwChild, "child1", "Child 1"
TreeView1.Nodes.Add "root", tvwChild, "child2", "Child 2"
TreeView1.Nodes.Add "root", tvwChild, "child3", "Child 3"
TreeView1.Nodes.Add "root", tvwChild, "child4", "Child 4"
TreeView1.Nodes.Add "child3", tvwChild, "child3.1", "Child 3.1"
Also, try looking on MSDN, it will tell you a lot more.
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
I have one:
http://www.codeproject.com/useritems/ASPTreeView.asp
Fernando Finelli
|
|
|
|
|
Speech to text Example is not working....I am working on win'98 with vb 6.0 and the code doesnt work..ie the speech output isnt there.Even in the supplied example.Any ideas......
|
|
|
|
|
I have used ActiveX ctrl to asynchronously download a file from FTP site. Program downloads the file for the first time from the site.But,next time it dont download file from the site.I think,It gets the file from cached in c:\winnt\profiles\myNTlogin\temporary internet files.when delete the file from there,next time program downloads from site.
I have used :
flag=fs.FileExists("c:\winnt\profiles\myNTlogin\temporary internet files\file")
Although, the file is there, function returns FALSE.
Can anybody tell me How to delete that temporary file programatically,
Thanks in advance
|
|
|
|
|
C# has an events button in the properties window, but VB.NET doesn't.
WTF?
How do you get to choose the event of a eg: command button?
Cheers,
Simon
X-5 452 rules.
|
|
|
|
|
In the code editor, there are two drop downs at the top of the window. In the left one, pick the object (or overrides, interface, base events etc.) that you want, and then in the right one, pick the event/method.
Or, for events, just start typeing:
Private Sub DoSomething(sender as object, e as EventArgs) Handles
as soon as you press the space bar after Handles, IntelliSense will pop up a list of objects, and away you go.
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
Thanks, I'll pass it on to my team.
Cheers,
Simon
X-5 452 rules.
|
|
|
|
|
Hi !
I'm using VB 6. I want to develop a class (.cls) in which I would like to instanciate a Timer (m_myTimer) and react to the event m_myTimer_Timer().
I know how to do that in a form (I put on my form the 'Timer' control), but I'm not able to do it in my class. I tried to do that :
<br />
Dim WithEvents m_myTimer As Timer<br />
<br />
Private Sub Class_Initialize()<br />
<br />
m_myTimer.Enabled = True<br />
m_myTimer.Interval = 2000<br />
<br />
End Sub<br />
<br />
Private Sub m_myTimer_Timer()<br />
<br />
' Handle event <br />
<br />
End Sub<br />
but I get an error at line 'm_myTimer.Enabled= True'. I guess I have somewhere to do something like 'Set m_myTimer=whatever', but I can't figure out what to do.
Thank you for your help !
Jerome
|
|
|
|
|
Try changing this line:
Dim WithEvents m_myTimer As Timer
to this;
Dim WithEvents m_myTimer As New Timer
--
Andrew.
|
|
|
|
|
I added the crystal report component to my vb application and it runs fine
when I run the report in preview mode behind a command button. But when I
package and deploy this application, they hit the button and the report does
not run at all in preview mode. I dont get an error or anything, the report
is in correct path but it just does not open. I have the latest version of
vb which is SP 5.Any ideas?
lenhan
|
|
|
|
|
Did you check that that crystal ocx is registered correctly?
Cheers
Schalk
|
|
|
|
|
I was wondering what a really good/fast sort routine I could use to sort a text array. I will have about 250,000 records to go through.
A name of a routine would be great, a link even greater.
thx
Quinn
|
|
|
|
|
the fastest i know is quick sort but i don't have any link sorry
Michael
|
|
|
|
|
ok thx, I ported a qsort routine I had done in C when I got home and it works great.
|
|
|
|
|
I created a simple class module in Visual Basic called Child.
When I try to dim it in my project the auto completion pop up shows my class in the list as "child" rather than "Child".
Visual Basic treats the lower case version as a different object, so when i try to dim it, it gives me an object required error.
My problem is that no matter what I do I cant use this statement
Dim c as Child
becuase VB automatically changes it to the lowercase version like this
Dim c as child
Im not sure why it behaves like this, does some one know how to correct this?
Thanks for you help!
|
|
|
|
|
May be your having some other oject with tha name Child or change the class name to some thing else and try it.
Gau
Gaurika Wijeratne. // www.gaurika.com
|
|
|
|
|
I am using a listview control in Details mode that has three columns as follows:
Q100 C true
Q200 N false
Q300 N true
I would like to display a checkbox in the third column. Does anyone have any suggestions for adding a checkbox in the third column.
TIA!
- Derek
|
|
|
|
|
You may want to look into using a datagrid instead. You would have to do some code for the bubbling events, but it would surely be easier than drawing your own custom control.
David Stone
dstone@newcenturytitle.com
"I am but mad north-northwest, when the wind is southerly I know a hawk from a handsaw." -Hamlet
|
|
|
|
|
Thx for the reply!
I have resorted to using the listview control but with the checkedboxes property set to True. It's not exactly what I wanted but I am tired of fighting with the listview and the datagrid. The problem that I had with the datagrid is that the dragdrop events (lack of itemdrag) were more difficult to deal with as compared to the listview. Although, at least with the datagrid I could add checkboxes to easily to a datacolumn.
I was able to add checkboxes to a listview but the problem is that I just ended up painting the controls on top of the listview verses binding the control to the actual column. So when I scrolled thru the list the checkboxes were not bound to a specific row (sub-item). If I get some free time then I might try making a listview control that acts more like a datagrid.
- Derek
|
|
|
|