Visual Basic

2-Jul-04 3:05

It's not based in any "VB.NET technology". You'll be building a COM object using VB.NET or C#.NET. Checkout this[^] article on CodeProject. It's written in C#, but is convertable to VB.NET easy enough.

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

COM Add-In won't connect

joseph_rich_tx1-Jul-04 10:17

joseph_rich_tx

1-Jul-04 10:17

I have been writing a COM Add-In for Outlook using VB.NET. Now late in the game, it will no longer load when outlook loads. The connect event is never triggered. The .NET IDE gives the following hint:

' When run, the Add-in wizard prepared the registry for the Add-in.
' At a later time, if the Add-in becomes unavailable for reasons such as:
' 1) You moved this project to a computer other than which is was originally created on.
' 2) You chose 'Yes' when presented with a message asking if you wish to remove the Add-in.
' 3) Registry corruption.
' you will need to re-register the Add-in by building the MyAddin1Setup project by right clicking the project in the Solution Explorer, then choosing install.

I have tried their solution several times to no avail. Does anyone know how I can troubleshoot/resolve this problem. Needless to say its making me crazy!

Thanks in advance!

J. Rich

VenkatFor.NET2-Jul-04 8:09

VenkatFor.NET

2-Jul-04 8:09

I think you are talking about the same problem I had. Though I dont understand why, what I did was in Connect.vb OnConnection method, I commented out 'If' condition. This just works as I wanted.

Bhaskara

joseph_rich_tx2-Jul-04 8:40

joseph_rich_tx

2-Jul-04 8:40

I wish this worked for me. But no luck here.

In fact I have a msgbox statement as you enter the OnConnect event. But the OnConnect event never seems to fire. It does not appear that Outlook is opening the Add-In and thus the OnConnect event never occurs. My current theory is something is wrong in the Registry...but I have NO idea what or how...

From the information gravel road

Anonymous2-Jul-04 12:27

Anonymous

2-Jul-04 12:27

try this

add a setup project to the add-in app and install the application and see. it should work.

WMPlayer active x, begining of tracks get cut off

joseph_rich_tx3-Jul-04 14:22

joseph_rich_tx

3-Jul-04 14:22

Got it finally...FYI....

If you declare and initialize an object in the Connect Class declaration section(eg. Dim myObject as Object = Object), the Add-In will not connect(I think Outlook loads in "safe mode") and no error condition will be thrown.

Of course it was easy enough to declare the object in the in the declaration section and instantiate it after connection happens, and this was my solution....

Hope this helps someone else, cause this made me crazy for several days!

JRich

PictureBox Pan

Brad Fackrell1-Jul-04 9:10

Brad Fackrell

1-Jul-04 9:10

Hi.

Does anybody know if it is possible to ‘pan’ a PictureBox?

Thanks.
Brad

Re: PictureBox Pan

Name Removed1-Jul-04 9:58

Name Removed

1-Jul-04 9:58

If you are meaning like scrolling around, try putting one in a panel and setting the panel's .AutoScroll() Property to true.

Hope this helps

Re: PictureBox Pan

Brad Fackrell1-Jul-04 10:03

Brad Fackrell

1-Jul-04 10:03

Actually what I would like to do is a Pan similar to what a lot of drawing packages like AutoCAD have...left click and hold while dragging the image around the viewer. This is a very handy option when the picture is zoomed in very close.

Thanks
Brad

Glen Conaway1-Jul-04 7:30

Glen Conaway

1-Jul-04 7:30

I am making a application which plays tracks from a listboxcontrol
with the windows media player active x control (OCX). The items in the
listbox are the paths to the sound files.

The problem is that when I start playing a track, the very
beginging of the track gets cut off, this is only a fraction of a
second but it is still bad.

Any sugestions?

Many Thanks,
Glen Conaway

Trigering Application at specified intervals

kashif_kazi1-Jul-04 4:53

kashif_kazi

1-Jul-04 4:53

i want to developed server application
Which gets time from user let suppose 8'O clock in morning and then start seasrching database for changes and takes appropriate actions
thansk
regdrs

Dave Kreskowiak1-Jul-04 5:33

1-Jul-04 5:33

Permission granted!

I take it, there's a question buried in there somewhere...

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

kashif_kazi1-Jul-04 19:58

kashif_kazi

1-Jul-04 19:58

Well i mean
how i create Application as we see in Antivirus programs to Schedule scan time and other timing
thanks

Dave Kreskowiak2-Jul-04 2:46

2-Jul-04 2:46

All you have to do is write your application as a stand alone app that quits on its own. Then just use the Scheduled Tasks control panel to run it on at a scheduled time as often as you want.

Or you could make it more complex by building a scheduler into your app. You'd use a timer to fire off a method that gets the current system time and compares it to, maybe, a list of scheduled tasks that it needs to perform. If the time is right, you would have to launch the appropriate tasks. If not, the method just exists and waits for the next tick of the timer, say, every 10 seconds. My first thought is a scheduler that launches each task in a seperate thread. You would then need an interface to manage the task list and another one to manage the scheduler.

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

kashif_kazi2-Jul-04 19:59

kashif_kazi

2-Jul-04 19:59

Thanks Dave for supporting responce
I will soon try it
thanks

Crystal Reports Problem

fizzer6661-Jul-04 4:52

Re: Crystal Reports Problem

1-Jul-04 4:52

Hi everyone,

I have managed to get crystal reports working with my program fine when the database used for the source is put in a fixed directory ie. the programs directory.

I'm now updating my program so that the user can install the program in any directory and the database is called from the application folder. This works great with everything except the crystal reports. The main problem is that originally I had set the crystal report data source to the database in the fixed directory so I thought it would be a simple job to just use the dataset as the data source to get over this problem. I have tried the folowing code on a form with the report viewer:

'First change the directory of the database to the application folder
Try
Me.OleDbConnection1.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= Asset Control.mdb"

Catch eConnection As System.Exception
MessageBox.Show(eConnection.Message)
End Try

'now fill the data adapter
Me.OleDbDataAdapter1.Fill(Me.DsAssetTypeReport1)

'**********************************************************************************

'Change Report Source to application folder
Try
Me.CrystalReportViewer1.ReportSource = "Reports\CRAssetsByAssetType1.rpt"
Catch eConnection As System.Exception
MessageBox.Show(eConnection.Message)
End Try

'***********************************************************************************
End Sub

I think the reportviewer is still trying to open the report from the fixed directory because I get a log On dialog appear. And if the database is in the original directory it will open. Can anyone throw some light on this?
Also am I anywhere near the mark with the code above?

Thanks in advance.

Dave Kreskowiak1-Jul-04 5:45

Re: Crystal Reports Problem

1-Jul-04 5:45

fizzer666 wrote:
'First change the directory of the database to the application folder
Try
Me.OleDbConnection1.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= Asset Control.mdb"

Well, according to the comment you put in there, this code does NOT change the directory of anything. It just assumes that the current directory is the one with the .MDB database. You really can't assume anything, so what you might want to do is prepend the path to the .EXE file that started your app to the filename of the database (assuming it's in the smae directory as the .EXE file.)

Imports System.IO
.
.
.
    Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & Path.Combine(Application.StartupPath, "Asset Control.mdb")

The same thing would apply to your Crystal Reports files:

'Change Report Source to application folder
Try
    Me.CrystalReportViewer1.ReportSource = Path.Combine(Application.StartupPath, "Reports\CRAssetsByAssetType1.rpt")
Catch eConnection As System.Exception
.
.
.

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

fizzer6662-Jul-04 4:04

Re: Crystal Reports Problem [EDITED]

2-Jul-04 4:04

Thanks for the code.

It seems to be working because I'm not getting any errors like "Incorrect Path". However, i'm still getting the login screen.

Sorry if i'm being a bit thick here but have you any idea why this is happening?

Dave Kreskowiak2-Jul-04 4:15

Re: Crystal Reports Problem [EDITED]

2-Jul-04 4:15

Is your database using User and Group Security/Permissions? Or is it on a network share?

[EDIT]
Never mind, I just re-read your original post. Is the dialog coming from Crystal Reports? Does any of your usernames/passwords work in the dialog? If so, that might tell you where the dialog is coming from.

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

fizzer6662-Jul-04 4:54

Re: Crystal Reports Problem [EDITED]

2-Jul-04 4:54

I haven't got any usernames/passwords set in the database. The crystal report opened fine when the directory was fixed.

The Database Login dialog does state the correct table name when it opens but there is no options to select from the server name combobox or the Database combo box.

I'm pretty sure it's coming from the Crystal Report because if I enter something in the dialog and click finish I get a message box saying logon failed with the title of the message box being "Crystal Report Windows Forms Viewer".

fizzer6665-Jul-04 4:13

Read the decibel from a mic.

5-Jul-04 4:13

Think i've solved the problem. Found an example in a book I have. I've used the following code and everything now seems to work. Hopefully all should be ok now. Thanks for all your help Dave.

'First change the directory of the database to the application folder
'[Change dbconnection to application startup path]
Try
Me.OleDbConnection1.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Path.Combine(Application.StartupPath, "Asset Control.mdb")

Catch eConnection As System.Exception
MessageBox.Show(eConnection.Message)
End Try
'[Change dbconnection to application startup path/]

Dim myRpt As Object
Dim cr_dataset As New dsAssetTypeReport
myRpt = New CRAssetsByAssetType1
Me.OleDbDataAdapter1.Fill(cr_dataset)
myRpt.setdatasource(cr_dataset)
Me.CrystalReportViewer1.ReportSource = myRpt

sybux20001-Jul-04 1:36

sybux2000

1-Jul-04 1:36

Hi,

I'm looking for some code that can calculate the Decibel from a mic.

Thx

Re: Read the decibel from a mic.

Dave Kreskowiak1-Jul-04 4:02