Answer Questions

• Thomas Olsson Creating Pivot Table in Excel File with Interop Assemblies

  Hi everyone, I'm trying to create a pivot table. Actually, I'm creating one from a Table of an existing sheet. So I'm creating a pivot table named Activite, and then add the pivot fields, Libelle in Row and 2 series of fields, named Nb P1, NB P2 as Data. But the problem is that: in the sheet of the pivottable, the 2 series have been added in the same colomn, so it does the sum of the two series. And actually, I want the 2 series, displayed separetely. Here is the code: obook is an Microsoft.Office.Interop.Excel.workbook object With (obook.Worksheets.Item("Feuil2").PivotTables("Activite")) .SmallGrid = False With .PivotFields("Libelle") .Orientation = Microsoft.Office.Interop.Excel.X ...Show All

• Thomas Greenleaf null TextBoxes in Database Entry Form

  Hello, 1. The Form has TextBoxes c1,c2,c3 receiving currency and c4 which shows the totals: c4=c1+c2+c3 As it is now, an "Add New" Button_Click event initialize all the TextBoxes to "0.0". While this works, it places a burden on the user when entering data (he has to erase the "0.0" or might make a mistake say typing "1" without erasing "0.0" turning it into "10.0"). 2. How could the c4 always show some result, starting from the initial 0.0 to c4=c1 then c4=c2 c4=c3 or c4=c1+c2 or c4=c1+c3 or c4=c1+c2+c3 Thanks, Hi Spotty, Thanks for your time. The EntryForm is the front-end to a Database and a somewhat more complicated that it was posted originally. (It ...Show All

• zabrucewayne Is it possible?

  How would I fill a picturebox with an image ramdomly selected from a bank of images whether in a class, or a set of dimensioned images Please give me a piece of code that depicts this idea. Private Sub btnRandom_Click(By Val...etc.) Dim i as integer For i = 1 to 65535 Picturebox1.image = RANDOM IMAGE etc. Next i End Sub . . I think you get what im trying to say! Very basic usage: Open a windows application Add an ImageList control, Picture Box control and a Button control to your form in the design view add your images to the imageList's image collection And add the codes shown below Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As S ...Show All

• j_o_h_a_n_n_e_s how to get data out from datagridview

  pls provide me with an soln to my problem above asap.... THX!! are there anyway u could print this data from the datagridview to excel pls reply asap You could walk the grid manually using the before mentioned properties and push the data into a spreadsheet. There's actually two ways to do that. The "proper" way is to use the Excel object. There are aricles in MSDN that cover that like the article 301982 "How to automate Microsoft Excel from Visual Basic.NET" or article 306022 "How to Transfer Data to an Excel Workbook by using Visual Basic.NET." Using the Excel object does require that the computer where the program is b ...Show All

• JTK Collection key regional settings german umlaute

  Hi newsgroup, greetings from Germany. I've a simple vb.net 2005 code-snippet: Dim x As New Collection x.Add(0, "Muller" ) x.Add(0, "Mueller" ) I found out, that sometimes the snippet runs (as compiled exe) without any problems, sometimes not. Adding an item with the key Mueller, when the key Muller exists, may raise an exception. It depends on the regional settings (German Windows XP Regions- und Sprachoptionen). The sort-option Telefonbuch (DIN) raises the error, Worterbuch doesn't. Is this behaviour a bug I think so, because a string should not be converted into a system string using a special sort-setting before it is used in a collection key. What do you think about it Sorry, but I do ...Show All

• xlordt How to fill buttons texts with for each statement

  Hello, I would be grately thanfull if someone could help me out with this problem. I have a set of 75 buttons named button1...button75, and I want to fill the text of the buttons with data I have inputed in a dataset. I am using a for each statement to get the information from the data rows, but I cant put the button name as a variable so that it changes to the next button to put the next text. Right now all the information is put only in one button, so it ends up with the last data from the dataset table. Please help Thank you, Alfredo you can get the button reference as fallows Dim intCtr as int32 = 1 Form1.controls("button" & intCtr.ToString()).Text = "Put Your Text here&qu ...Show All

• pc_bond Label not visible on form when Text property is blank.

  I blanked out the Text in design time since I only want it to display when a button is clicked during run time. However, I wanted to relocate the label on the form and there's no indication of where it is during design time. Is there any way to display the label on the form and access its properties in the Properties window Go to the properties window (normally F4) and select the control from the dropdown list of controls on the form at the top of this window. The control will be selected.  Which will enable you to drag and reposition it. Or you could adjust the properties directly to reposition it. For what you are trying to do - I'd leave the text alone (with text in there) so its always easy to drag it around at de ...Show All

• GoDaddy NetWork Printer Not getting Displayed in Vb.NET Services

  Hi, I work on VisualStudio 2005 and .NET framework 2.0 I have written the below code and compiled both as Windows application and windows services. The Results are different. I need to run my program as windows services. Please help. I have added the Reference to Powerpack.Printing. If I run the below code as windows application, all printers gets listed. If I run the below code as windows services, NetWork Printers do not get listed. Any help would be appreciated. Imports Microsoft.VisualBasic.PowerPacks.Printing.Compatibility.VB6 Public Sub Listprinters() Dim objPrinter As Printer Dim strtemp As String = "" Try For Each objPrinter In Printers strtemp = objPrinter.DeviceName ...Show All

• Mike Berro Shared Classes: Good Idea or Bad Idea

  I wanted to solicit some opinions on this topic since we're laying some ground rules for VB.Net development in our organization. My observation so far is that shared classes are good for function libraries where the calls are stateless. For example, you might have a set of functions that performed common operations on a passed in value or object. It seems like this would be a good way to group this kind of functionality throughout the app or multiple apps. However, I’ve run into a few pre-built shared classes that required setting properties before calling functions and results from functions were available by getting a property with the function only returning a boolean. Making a shared class stateful like this seems like a re ...Show All

• Jim Perry Webbrowser - Webbrowser1_DocumentCompleated

  Hi! From the event "Webbrowser1_DocumentCompleated", i try to call a function called "lookup_all_htmlTables". This is not working, anyone know why The line lookup_all_htmlTables() is not executed. ! I have this code in the Webbrowser1_DocumentCompleated --cut-- Dim htmDoc As HtmlDocument = WebBrowser1.Document AddHandler htmDoc.Click, New HtmlElementEventHandler( AddressOf Document_MouseClick) lookup_all_htmlTables(webbrowser1.document) --cut-- --cut-- Sub lookup_all_htmlTables(tmpHtml as HtmlDocument) Dim objects, tblCount Dim tblName As String Dim tmpHtml As mshtml.HTMLDocument tmpHtml = WebBrowser1.Document tblName = "" tblCount = 0 For objects = 1 To tmpHtml.all.length - 1 tblCount = tblCou ...Show All

• FASimus Error when adding a reference to the main project in a solution

  Error 1 Could not find file 'Microsoft.Windows.CommonLanguageRuntime, Version=2.0.50727.0'. PerfWSService I get this error when I add a new Windows Service project and then add a reference to the main project "PerfWS". I can not figure out why this is happening At this point I'm thinking it's either something conflicting in your project file for the main project or solution file. If you feel comfortable doing so, can you post the contents of your solution file and main project file 1. VB2005 2. It builds fine without the reference. As soon as I add the reference it fails. 3. PerfWS is a regular Windows Application project. I have the code setup in a way where the main form calls it to execute background ...Show All

• Sondre - MSFT Regional Director Software Publish Question

  Alright, I have a program that I'm working on and i have noticed that whenever I run the Publish in the Programs Properties, that it makes a .exe . Now whenever I run the .exe , I noticed that it puts it under Start - All Programs but I don't see it anywhere in the C:\Program Files\ . Why is that Also, I have a .mdf in the application. Will it create the .mdf upon install for me or do i have to encode that into the program You'll need to create a Setup and Deployment project. You can use the Setup Wizard to get you started. I'm not sure on the database question since I've always used a pre-existing SQL Server in my .NET applications. I'd guess you would have to create and install it locally. ...Show All

• levi3man Is this possible?

  Hello,   I am using Visual Basic 2005. I am wondering, if it is possible to do these 2 things:   1.       if there is a way to make a application, that retrieves certain data from an Internet webpage If there is a way, how is it done 2.      Also, if the above task is possible, is there a way to make it so that the application gets and updates the data, every time the application is opened   Thanks in advance, well basically you have to do some string parsing and this is for you to do and work out since its not an easy task :-) It would be good if they had a webservice where you can hook up to it an ...Show All

• jiggs Excel file creation

  I'm doing some automated report stuff with kicking out an excel file here. What am I doing wrong below I can get output, so files do get written, but after running the program a few times I get a System.OutOfMemoryException --- "Not enough storage is available to complete this operation." so I'm guessing that I need to close up some objects. I've tried closing up some stuff in addition to my oXL object, but I just get errors. So I'm turning to the community here to help me out. so what else should I be doing in my "finally" section Dim oXL As Excel.Application Dim oBook As Excel.Workbook Dim oSheet As Excel.Worksheet Dim iRow As Integer Dim iCol As Integer Dim stFileName As String Dim ar As String() = {"ID"} Try oXL = ...Show All

• coolarian VB.NET Language Translator

  Hi, How can I write a program that translates text from English to another language by using Google Translate Please re-read my initial post. I do not want to create my own language dictionary, I want to write a program that uses an existing online dictionary to translate text. Any ideas robinjam wrote: I think you misunderstood. I would like to make a VB.NET application that translates text into different languages. How do I do it Hi, No i didn't misunderstand you, i was offering an alternative to a very difficult problem. No single software translation program can be 100% accurate due to sentence being re-arranged in some languages if you were to simply translate each word in a sentence. Translate ...Show All