Visual Basic

6-Mar-06 9:11

KreativeKai wrote:
The server does not have Excel on it

There's your problem!

KreativeKai wrote:
Is there a way to get around loading Excel on the server?

No, there isn't. How is your server code going to call Excel if it's not installed on the server?

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

Re: References

KreativeKai20-Mar-06 7:13

KreativeKai

20-Mar-06 7:13

I called Microsoft using one of our MSDN incidents. Basically Office is designed for interactive usage and they do not recommend automating it with an unattended application. Like you said, you need to have Excel installed, but they do not support Office being installed on a server because it is not designed to work on a server and cause unexpected results.

Here is a link showing their “Not supported” statement and their “at your own risk” workarounds:
http://support.microsoft.com/?id=257757

I used the workaround towards the end of the article related to “How to configure Office applications to run under the interactive user account” and I put the application on a client PC using scheduled tasks instead of on a server.

Thanks for you help Dave!! Smile | :)

Lost in the vast sea of .NET

multithreading

DoubleD_6-Mar-06 7:15

DoubleD_

6-Mar-06 7:15

Hallo, I'd like to to get help on the following subject:
I use a BackgroundWorker control in a form and i'd like to show intermediate results from the BackgroundWorker in a control on the same form (before it has finished its work). I tried accessing the control by reference but an exception occurred stating that the control's property (Text) cannot be changed from another thread.
thank you.

Re: multithreading

CWIZO6-Mar-06 7:31

CWIZO

6-Mar-06 7:31

Make an event to which your form that will display the progress will listen.
And then fire that event from the working thread whenever you wan't to update the status (you can pass the status information in the event arguments)

Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

Re: multithreading

Dave Kreskowiak6-Mar-06 9:09

Sending Info to Login Box

6-Mar-06 9:09

It's correct. You can't access UI controls from any other thread other than the one that created the control (known as the UI thread).

The BackgroundWorker exposes a ProgressChanged event that you can use to update your controls. Of course, your worker code has to be able to send some kind of usuable progress!

' Setup the BackgroundWorker object and start the work somewhere...
BackgroundWorker1.WorkerReportsProgress = True
BackgroundWorker1.WorkerSupportsCancellation = True
BackgroundWorker1.RunWorkerAsync()
 
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker1.DoWork()
    ' Get a reference to the BGW that called this
    Dim bgw As BackgroundWorker = CType(sender, BackgroundWorker)
 
    ' Do some long running task about a million times...
    For I As Integer = 1 to 1000000
        ' Check to see if we've been cancelled
        If bgw.CancellationPending Then
            e.Cancel = True
            Exit For
        End If
 
        ' Do something useful here...
 
        bgw.ReportProgress(i / 10000)   ' Reduce i to the range of 0 to 100.
    Next
    e.Result = whatever ' Return whatever the result of this work is supposed to be.
End Sub
 
Private Sub BackgroundWorker1_ProcessChanged(ByVal sender As Object, ByVal e As ProgressChangedEvent) Handles BackgroundWorker1.ProgressChanged
    ' Do something usefull with the progress
    ProgressBar1.Value = e.ProgressPercentage
End Sub

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

Re: multithreading

DoubleD_7-Mar-06 5:02

DoubleD_

7-Mar-06 5:02

thank you for your answer, it was really helpful.

jdjd11186-Mar-06 6:37

jdjd1118

6-Mar-06 6:37

Hello. I'm writing a program to store passwords. I would like to allow the user the option of sending the username and passwords to the website by just clicking a button. Can anyone help me? Thanks in advance.

Re: Sending Info to Login Box

Dave Kreskowiak6-Mar-06 8:52

6-Mar-06 8:52

In most cases, you can't do that. You'll have to load the login page, find (NOT EASY!), then fill in the fields with the data, then submit the login page back to the server. You can't just send a username and password to the web server and expect it to work. It just doesn't work that way.

On top of that, this is already built into Internet Explorer...

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

-- modified at 14:52 Monday 6th March, 2006

uiRich Text Box - Hell

EvolutionSoftware6-Mar-06 5:11

EvolutionSoftware

6-Mar-06 5:11

Okay I realize this is probably quite an easy questions however it has me stumped right now. I am trying to use a rich text box to display output data in three columns. The columns are lined up using tabs and everything looks great on the screen. The problem is when I go to print the data all of my tabs are lost! I have used vbtab and chr(9) coding. I don't want to hard code spaces since that way is very unpredicable and can cause problems if the font every gets changed.

Can someone please explain what the hell I am doing wrong?

Thanks

Confused | :confused:

Dave Kreskowiak6-Mar-06 8:50

6-Mar-06 8:50

That depends on how you're printing the contents of the box... An explaination of how you're doing this might help.

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

EvolutionSoftware6-Mar-06 9:22

EvolutionSoftware

6-Mar-06 9:22

I am using the PrintDialog tool right out of the box from Visual Studio same as I am doing for OpenDialog, PrintPreviewDialog, etc.

Maybe a better explanation is that I am using a for next loop to write two arrays of data to the rich text box. After each element I insert a number of tabs so that I end up with columns of data (there are three columns in total). Like I said in my original message the form looks fine when it is run. When I go to print or use print preview all of the data is squished together. For some unknown reason (at least to me) my tabs have been removed.

Dave Kreskowiak6-Mar-06 9:37

6-Mar-06 9:37

Your tabs are getting reduced down to the size of a single space character, since in GDI+, they don't have a width, and there is no such thing as a tab stop. Printing with the PrintDialog, and the other objects you're using, isn't WYSIWYG. If you really need to do this in a RichTextBox, you'll have to modify the RTB by creating your own, supplying all the formatting and printing code.

Fortunately for you, someone ahs already done this, here[^]. I hope it works for you.

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

EvolutionSoftware6-Mar-06 9:52

EvolutionSoftware

6-Mar-06 9:52

Thanks Dave. I'll read through the article you pointed me to and see if this helps.

linking forms together

madchanic6-Mar-06 4:33

madchanic

6-Mar-06 4:33

could someone tell me how i could link forms together such as if i click a botton on one form the another form would open up.

-- modified at 10:34 Monday 6th March, 2006

Christian Graus6-Mar-06 4:38

Christian Graus

6-Mar-06 4:38

You would have a click event handler for the button, and that code would create an instance of the second form and call ShowModal on it.

Christian Graus - Microsoft MVP - C++

madchanic6-Mar-06 4:56

madchanic

6-Mar-06 4:56

how do i get the event handler

Christian Graus6-Mar-06 5:11

Christian Graus

6-Mar-06 5:11

Well, I would respond with a bit of general advice. More so than ever, there are people downloading VB Express, looking at the IDE and deciding they can write a windows program. Most of these people will fail. If you want to learn to code, you need to learn the language before you play with it's frameworks, write console apps before windows apps. It seems to me that it's likely you're at this level, and should take a step back.

The easiest way to create an event handler for a button is to double click on it in the design view.

Christian Graus - Microsoft MVP - C++

Dave Kreskowiak6-Mar-06 8:48

Autocomplete Combobox in Compact Framework

6-Mar-06 8:48

Stop, backup, and learn the basics[^] before you beat us to death with easy questions.

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

mikelawry6-Mar-06 4:07

mikelawry

6-Mar-06 4:07

I've been trying to implement the autocomplete functionality on Pocket PC application but I can't get arround the framework restriction.
Can anyone help?

Thanks.

Re: Autocomplete Combobox in Compact Framework

Dave Kreskowiak6-Mar-06 8:46

Re: Autocomplete Combobox in Compact Framework

6-Mar-06 8:46

What Framework restriction???

Also, your question would be better handled in the Mobile Development[^] forum.

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

feuch218-Mar-06 8:37

feuch21

8-Mar-06 8:37

Dave Kreskowiak wrote:
What Framework restriction???

I can't use the Findstring methods or the selectionstart and selection lenght properties in the Compact Framework

How to delete a thread object once it comes out of its method of execution.

varmag6-Mar-06 4:06

varmag

6-Mar-06 4:06

Hi all

In my app i am creating a thread and cheking the status.
When i tried to check the status of the thread after the execution of the method that it is reffering, It is giving that thread state is Stopped.

what doest it mean.

Is that the thread object is still alive.

1) If so how to destroy the thread object once its state is "Stopped".
2) The other issue is how to restart a thread which is in stopped state.

Re: How to delete a thread object once it comes out of its method of execution.

Dave Kreskowiak6-Mar-06 8:39