|
Please don't post all your code. Just the trouble spot in your code ( or at least where you suspect it is not working ).
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi there,
I would like to change the hideselection color from the treeview. I have set it to false, and i've noticed that the color is equal to the systemcolor control.
Is it possible to change this color to for example Red?
Thanks
|
|
|
|
|
You can't change TreeView.HideSelection Color directly.
But to change HideSelection color here is an another solution
1) TreeView.HideSelection = true
2) Declare:
Public previousSeletedNode As TreeNode 'To hold reference to previously selected TreeNode
3)
Private Sub TreeView1_Validating(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles TreeView1.Validating
TreeView1.SelectedNode.BackColor = Color.Yellow
TreeView1.SelectedNode.ForeColor = Color.White
previousSeletedNode = TreeView1.SelectedNode
End Sub
4)
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
If Not previousSeletedNode Is Nothing Then
previousSeletedNode.BackColor = TreeView1.BackColor
previousSeletedNode.ForeColor = TreeView1.ForeColor
End If
End Sub
|
|
|
|
|
that works great! Thanks.
|
|
|
|
|
Can anyone please let me know how to convert the data type of a field under Crystal Reports I'm using this code in the formula editor but gives me an error 'A Field is Required'.
sum (ToNumber({A String Field}))
I know it takes only Numeric data type fields but is there any way to first convert the string into a Number then calculate its Sum?
Thanks in Advance !
AliAmjad(MCP)
First make it Run THEN make it Run Fast.
|
|
|
|
|
Is it possible in VB to open up a word doc/template replace some certain words with information read in from a csv file and then print this doc/template ? I suppose in effect it is a simple mail merge.
I've written the bit to open the csv file and read the data in but am a bit stumped as to how to open a word doc and replace some words and then print.
Any help gratefully appreciated.
|
|
|
|
|
With the Microsoft Interop Library found with MS Office, I think it is possible...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Is anyone able to help with a snippet of code as to how to find a word in a word document and then replace with required text ?
I've tried the code below but the items highlighted are not declared, I've tried various lines of code for the declaration but cannot seem to get it right.
With Selection.Find
.ClearFormatting
.Text = "hi"
.Replacement.ClearFormatting
.Replacement.Text = "hello"
.Execute Replace:=wdReplaceAll, Forward:=True, _
Wrap:=wdFindContinue
End With
Any help would be gratefully appreciated
|
|
|
|
|
Found a solution that works for finding text and replacing it in word.doc, snippet below
Imports Microsoft.Office.Interop
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim axword As Microsoft.Office.Interop.Word.Application
Dim axdoc As Word.Document
axword = New Word.Application
axdoc = axword.Documents.Open("c:\quote.dotx")
axword.Visible = True
axdoc.Activate()
axword.Selection.Find.ClearFormatting()
axword.Selection.Find.Text = "~{CUSTOMERNAME}"
axword.Selection.Find.Execute()
axword.Selection.Select()
axword.Selection.TypeText("Joe Bloggs")
|
|
|
|
|
how do i add columns to my datagrid and give them a name
|
|
|
|
|
Use the myDataGrid.Columns.Add method
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
ok i got my datagrid set up and its loading text files fine now when i edit the text files in the datagrid i need to know how to save the changed textfile.
|
|
|
|
|
Dear All,
I use VB.NET 2003 and MS Access 2003.
After executing the program, I have enclosed coed to compact the database and close it. Those code are as follows,
Sub Main()
Try
Dim File_Path, compact_file As String
'Original file path that u want to compact
File_Path = AppDomain.CurrentDomain.BaseDirectory & "db.mdb"
'compact file path, a temp file
compact_file = AppDomain.CurrentDomain.BaseDirectory & "db1.mdb"
'First check the file u want to compact exists or not
If File.Exists(File_Path) Then
Dim db As New DAO.DBEngine
'CompactDatabase has two parameters, creates a copy of compact DB at the Destination path
db.CompactDatabase(File_Path, compact_file)
End If
'restore the original file from the compacted file
If File.Exists(compact_file) Then
File.Delete(File_Path)
File.Move(compact_file, File_Path)
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
This was working fine, but after i created crystal report to display my results, those codes are not working. An error displays at,
db.CompactDatabase(File_Path, compact_file)
An error message as follows,
Cannot open database "Path/db.mdb'. It may not be a database that your application recognizes, or the file may be currupt.
If i execute program without displaing crystal report, it is OK. The problem arise only after run crystal reports.
Please help me.
Thanks
Dimuthu
|
|
|
|
|
Is crystal reports trying to run before the compacting of the Database is complete?
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Dear Steve,
Yes, the database is compacting when the program is exiting. Compacting codes are placed in main Exit Menu.
Thanks
Dimuthu
|
|
|
|
|
Hi,
I'd like to display a form with an animated graphic whilst some information in a large dataset is being saved to a file. Naturally, once the file is saved the form should close. Can anyone point me in the right direction please.
thanks in advance
|
|
|
|
|
You what something like this :-
Dim f as WorkingForm<br />
f.show<br />
'Do something here<br />
f.close<br />
f.dispose<br />
f = nothing
Ensure the TopMost property of the WorkingForm is set to True.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
I'm not shure but this might have the problem that the animation isn't going to go to well/smooth
perhaps multithreading would solve that problem
at the end of the thread that save the file fire an event that closes the form?
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
I have a third party executable that I run, which writes its results to a text file. Unfortunately, it writes only to a single file, overwriting itself each time, and locking the file as it writes. As a result, if I run four copies of this simultaneously, for example, only one of those copies will sucessfully write to the log file.
Is there some way I could launch the file and intercept its file output operations (bearing in mind I have no knowledge of how it's doing that output), redirecting them to a unique instance of the log file each time it runs?
Thanks for any input, and do let me know if the above doesn't clearly explain what it is I am trying to do.
|
|
|
|
|
Hi,
if the log file's path or name somehow depends on the EXE's path or name, you could
create copies of the EXE with different paths or names.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Unfortunately I'm looking at being able to run up to 100s of instances simultaneously, so that's just not practical. Thanks, though.
|
|
|
|
|
Hi, if the EXE creates the log at a relative position you could programmatically start it with
different explicit "current directory" values (use Process and ProcessStartInfo classes).
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Ooh - I'll look into that, thanks.
|
|
|
|
|
Could anyone please help on how to disable the click event of datagrid. Bc when I disable the datagrid, the datagrid is just gray out but it's not disabled. I want the datagrid disable so the user can see it but can not click on it for SelectedIndexChanged event.
Thanks in advance
|
|
|
|
|
Why not just make it ReadOnly?
|
|
|
|