Visual Basic Discussion Boards

shinay12-May-04 20:02

12-May-04 20:02

I am trying to figure out how to hook this DocumentBeforeSave event when using IDTExtensibility2( Add-in
for all office application )got this idea from ms knowledge base Q238228
I worked with "Using the VB6 Add-in Designer", but not with "COM Add-In Using Implements"

Dim WithEvents objWord As Word.Application

Private Sub objWord_DocumentBeforeSave(ByVal Doc As Word.Document, SaveAsUI As Boolean, Cancel As Boolean)
msgbox "please say something!!!"
End Sub

Thanks in advance
Shin

Re: Office Addin IDTExtensibility2 Event

Anonymous12-May-04 23:19

Anonymous

12-May-04 23:19

How can I ignore invalide path characters being entered into a text box

Kettlewell12-May-04 13:17

Kettlewell

12-May-04 13:17

I am aware of System.IO.Path.InvalidPathChars. However, I don't know how to filter out these characters when input into a text control. I tried using the TextBox1.KeyDown event, but I don't know how to keep the invalid char from showing up in the textbox, even if I can identify it.

Mark Kettlewell

How can I get the event when user using DELETE key to delete a ROW of a datagid table?

ATC12-May-04 11:05

ATC

12-May-04 11:05

Hi,

I am stuck when try to detect an user deleting a row of a datagrid table! I do need to perform some tasks at that moment, but so far I can't!

*) I did try to set datagrid events KeyPress, KeyDown, KeyUp but somehow no event generated when I success delete a datagrid row!

Can someone explain or show me how to set this kind of event?

Thank for any help!

Re: How can I get the event when user using DELETE key to delete a ROW of a datagid table?

shinay12-May-04 19:57

shinay

12-May-04 19:57

Just get an event on the form and see there is a change on the number of rows in the datagrid. Work?

Shin

Re: How can I get the event when user using DELETE key to delete a ROW of a datagid table?

ATC31-May-04 8:28

ATC

31-May-04 8:28

Hi Shinay,

This way is worked, except that I have to do two steps.

Thanks

Could not find installable ISAM

Member 33182312-May-04 8:53

Member 331823

12-May-04 8:53

I am receiving this error when trying to open an oledb connection on an Excel file from within VB.NET. All samples I have seen seem straight forward but for some reason I cannot connect to the file. My Connection string is "Provider=Microsoft.Jet.Oledb.4.0;Datasource=c:\file.xls;Extended Properties=Excel 8.0;HDR=Yes".

I have attempted to manipulate my connection string with different properties with no luck. If anyone has any suggestions as to what is wrong please let me know.

When are events fired?

PaleyX12-May-04 7:57

PaleyX

12-May-04 7:57

I have a dialog with a treeview and a listview. I want the listview to change when i select a different node on the treeview (I use the AfterSelect event of the treeview) - before I show the dialog using dlg.ShowDialog() I want to populate the treeview and then in the code select the a treeview node to fire the AfterSelect event which will populate the listview then I want to programatically select some items in the listview.

The problem is that the AfterSelect event doesn't seem to get fired until the dlg is shown so if I do

<br />
call dlg.PopulateTreeView()<br />
call dlg.SelectListViewItems()<br />
dlg.ShowDialog()<br />

the listview isn't populated when I call dlg.SelectListViewItems

Is there a well known way of doing this?

Rugby League: The Greatest Game Of All.

Re: When are events fired?

Dave Kreskowiak13-May-04 7:24

Dave Kreskowiak

13-May-04 7:24

You might want to try calling Application.DoEvents() before you call the dlg.ShowDialog(). It's no so much of a problem of when the event gets fired, but when it can get processed.

RageInTheMachine9532

Re: When are events fired?

PaleyX18-May-04 16:49

PaleyX

18-May-04 16:49

I already tried that, it didn't make a difference.

Rugby League: The Greatest Game Of All.

Re: When are events fired?

Dave Kreskowiak19-May-04 2:44

Dave Kreskowiak

19-May-04 2:44

OK. After going back and re-reading the original post, I misunderstood you.

Calling the Select methods in the ListView and TreeViews will NOT fire the AfterSelect events). They will only fire on mouse clicks. But, you can call those functions from another form's code if those functions are marked public. A better method would be to have your event handlers call these functions seperatly so you can make the functions public and not the eventhandlers:

The following is not useable code. It is a pseudo-code example for illustration purposes only!

Form1:

Dim dlg As New Dialog1
dlg.PopulateTreeView()
dlg.AfterSelectHandlerFunction()
dlg.ShowDialog()

Dialog1:

Private Sub TreeView_AfterSelect([eventargs stuff]) Handles TreeView.AfterSelect
    AfterSelectHandlerFunction()
End Sub
 
Public Sub AfterSelectHandlerFunction()
    [code to do whatever here]
End Sub

RageInTheMachine9532
"...a pungent, gastly, stinky piece of cheese!" -- The Roaming Gnome

background image taking over toolbar

Phaldo12-May-04 5:07

Phaldo

12-May-04 5:07

When you create a toolbar in any .NET application, (I'm working in VB.net but I had the same problem in C#.net) and set the background image to whatever image you want, if the toolbar appearance is "flat" the background image takes over the toolbar and instead of the toolbar being gray, it's like the background image was also tiled on the toolbar

anyone ever seen this? There's no code involved to reproduce this problem, all you need is a toolbar with the appearance set to flat, and a background image

System Properties VB6

DragonByte12-May-04 4:41

DragonByte

12-May-04 4:41

I have a question. How do I programmaticly open the System Properties dialog just like the user right clicked My Computer and selected Properties. I am using VB6. Any help would be GREATLY appreciated! Big Grin | :-D

The Dragon

Re: System Properties VB6

DragonByte12-May-04 4:44

DragonByte

12-May-04 4:44

Ooops....found it. Here it is if anyone else is looking for it: link

The Dragon

Help for mschart problem

allen_homer12-May-04 4:32

allen_homer

12-May-04 4:32

Dear Expert,
I'm a mschart control newbie. Here are 3 Questions needed your help.

(below is supposing to use this contorl in VB , you can also use it in VC, or other windows program tools capable of using this ActiveX controls, the encountered problem is same)

Q1: When I set *.ChartType=VtChChartType2dXY, How can I set X-asis Label to
my own expected string instead of Xas automatic generated by
itself.(Such as datetime instead of "0 1 2 3 ...")

Q2: Both when *.ChartType=VtChChartType2dXY or VtChChartType2dLine,
and when Xas Lable string is too long , How can I display it in Multi-line

Q3: When *.ChartType=VtChChartType2dLine , and after I set xasis.tick.style=...Inside,
& xasis.tick.length=200, it does not take effect, nothing changes , and what I expected to occur does not occur

In sum, What I want to do is by using mschart (must , cant use any other 3rd party controls),
set xasis infos(such as label , tick style, length) customarily by my expected format

Thanks in advance , Expecting your answer!
Allen, Homer

add commandbarbutton in outlook 2k3

sebmafate12-May-04 2:45

sebmafate

12-May-04 2:45

Hi everybody,

i'm making a addin for outlook 2k3, it works fine but i can't add commandbarbutton in Standard commandbar.
Can you help me ?

this is my code source :
Public Sub OnStartupComplete(ByRef custom As System.Array) Implements Extensibility.IDTExtensibility2.OnStartupComplete
Dim oType As Type
Dim oArgs As Object()
Dim objMissing As Object = Missing.Value

'TODO: Connecter une nouvelle barre d'outils
' Ajout du bouton dans la barre standard
Try
oType = applicationObject.GetType
objCommandBars = oType.InvokeMember("CommandBars", BindingFlags.GetProperty, Nothing, applicationObject, Nothing)
stdCommandBar = objCommandBars.Item("Standard")
btnFortune = stdCommandBar.FindControl(MsoControlType.msoControlButton, objMissing, , "Fortune", True)
If (btnFortune Is Nothing) Then
btnFortune = stdCommandBar.Controls.Add(MsoControlType.msoControlButton, objMissing, objMissing, objMissing, objMissing)
btnFortune.Caption = "Fortune"
btnFortune.Style = MsoButtonStyle.msoButtonCaption
btnFortune.Tag = "Fortune"
btnFortune.Visible = True
End If
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.Message, ex.Source)
End Try
End Sub

At run, I take a "Unknown name" error (french message : "Nom Inconnu") on line "objCommandBars = oType.InvokeMember("CommandBars", BindingFlags.GetProperty, Nothing, applicationObject, Nothing)"

Thanks for your help.
Seb.

Sébastien FERRAND

DB accessability problems

Greg Eales12-May-04 0:19

Greg Eales

12-May-04 0:19

If I have a DB on one machine in a network and I connect to it from an app on another machine, how do I supply the username and password for the PC with the DB on it. Is it done through the connection string or is there another way to get the client to pre-log on before attempting to make a connection to the DB.

Greg

Re: DB accessability problems

Dave Kreskowiak12-May-04 2:50

Dave Kreskowiak

12-May-04 2:50

Normally, you'd supply that information in the connection string. Is this an SQL Server? If so, then all you need is the SQL username and password in the connection string. I would avoid using Windows authentication or trusted connections if at all possible. Using an SQL login is more secure because this ID won't have access to the underlying server.

But if it's an Access database, then you'll have to authenticate to the machine before you can even attempt to get to the Access database. On the side, Access databases we're not designed for connections from other machines. It will work, but performance stinks and the number of connections you can get is, normally, very limited.

RageInTheMachine9532

Re: DB accessability problems

Greg Eales12-May-04 2:57

Greg Eales

12-May-04 2:57

Trust me I would love to be able to implement in SQL Server, But unfortunately I am pretty tied into Access, although admitidly performance is not really an issue. Which leaves the authentication problem. How can you, in VB .Net Authenticate a client logging onto another machine?

Greg

Re: DB accessability problems

Dave Kreskowiak13-May-04 7:21

Dave Kreskowiak

13-May-04 7:21

You can't do it entirely in managed code yet. You'd have to map a drive using the WNetUseConnection API. See this MSDN Article[^] for VB6 code on how to do this (translates pretty good to VB.NET)

You might also want to look into using the Windows Scripting Host Network object to do it too.

RageInTheMachine9532

Internet Monitor

Rohan Kaul11-May-04 23:06

Rohan Kaul

11-May-04 23:06

Hi,

Could someone help developing an application to monitor the web activity. I want to develop something like an internet spy software which monitors the web sites opened by my internet explorer.

Till now i have just been able to create a new instance of the internet explorer object and monitor the activity of the instance.

But any other instances creates other than that by the application are not monitored.

Re: Internet Monitor

Dave Kreskowiak12-May-04 2:52

Dave Kreskowiak

12-May-04 2:52

IE already has this built in, called History.

RageInTheMachine9532

Monitoring Internet

Anonymous11-May-04 23:00

Anonymous

11-May-04 23:00

Hi,

Re: Monitoring Internet

Dave Kreskowiak12-May-04 2:43

Dave Kreskowiak

12-May-04 2:43

HI!

Now what?

RageInTheMachine9532

System.Web.Mail - Good/Bad or just plain ugly

Greg Eales11-May-04 20:54

Greg Eales

11-May-04 20:54

The system.web.mail namespace allows for sending mail via SMTP right. But one thing I cant figure out. What if the SMTP server requires authentication? Can the SMTPMail class log you into the server and if so, how? or is there another way?

Greg

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.