Answer Questions

• RavenWorks I am haveing trouble getting my vb.net add-in to work from withing Excel 2003

  Originally I wrote some unctions for excel, in VBA, to calculate some engineering values. Beam calculations. I have since moved that code into vb.net. I have tried everything to make these functions available to Excel and have not been able to do so. I found an example in C# that works well. But, I am interested in VB.net. When I build the C# code, I can go into Excel --> Options --> Addins --> go btn --> Automation and select the C# dll in the Automation Server. WaLa C# functions work. With my VB project, I am not able to get my dll to show up in the Automation server list. I am at a loss as to how I "expose" my dll to the Automation server. On the AddIns Tab of the Excel Options dialog I can see my dll under InA ...Show All

• dotnetkiwi Creating Strongly Typed Datasets from an XML File

  I am trying to learn to use XMLDataDocument (where I can access and modify data in both an xml format and through a dataset). I looked at this site, with a tutorial for VB 2003. XMLDataDocument This site explains how to take an XML Document and convert it into an XSD schema which is then converted into a strongly typed datasets. In 2003, all you do is press "Generate Dataset" on the schema window and you are set. In 2005, that "Generate Dataset" is nowhere to be found. My question is, how do I generate a strongly typed dataset for use with XMLDataDocument from within VS 2005 It was exceedingly simple in VB 2003, and I figure it has got to be something easy I am missing. Thanks for your help. I am trying to figure ou ...Show All

• Nash Bridges Problem with GetChanges() from a DataTable Object

  I am trying to find out if a DataTable object has any changes that need to be saved to it's SQL Database using the Update() method. I looked throughout the properties of the DataTable object and can't find a Dirty property. But I did find a GetChanges() method. Problem is whenever I execute the GetChanges() method, which claims to return a DataTable of records that have been modified, I get the following error: MissingMethodException was unhandled No parameterless constructor defined for this object. Does anyone know why this is Or better yet, anyone know how I can accomplish what I am trying to do How are you calling this method...please show the local code you are using! Ok...here is my code line that crashes.. ...Show All

• Tryst Add input from textbox?

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim TextBox1 As String = "TextBox1.Text" Dim TextBox2 As String = "TextBox2.Text" If Button1.CanSelect Then TextBox3.Text = TextBox3.Text & TextBox1 & vbCrLf TextBox3.Text = TextBox3.Text & TextBox2 & vbCrLf End If End Sub What is supposed to go into the RED parts to take the info(text) from the text boxs and add it to the TextBox3 Wow Thanks A LOT man it worked. I love this forum its about the only one that i get HELPFUL respones, Not ones with there own codes that either take forever to make it work with my own app or arent what I need. Thanks Guys for helpin ...Show All

• Sonic1981 Arithmetic Exception

  "An unhandled exception of type 'System.ArithmeticException' occurred in system.drawing.dll Additional information: Overflow or underflow in the arithmetic operation. """ plz help how to solve this error thanks in advance FaheemKhan, I suggest you to add the ArithmeticExceptin Class in your project and in order to make sure there is no Overflow or underflow in the arithmetic operation. The exception that is throw for erros in an arithmetic, casting, or conversion operation. ArithmeticException class is the base for OverFlowException. In general, use one of the derived classes of ArithmeticException tp more precisely indicate the exact nature of the error. Just make a declaration in Visual Basic ...Show All

• bgailer How to create DLL's?

  Hello, I was formally known as kn1123, but I forgot my password so, I decided to register again as kineticAnimation.... Anyways, I was wondering how I can create DLL's... Right now I just want to know how I can make one... I found out that this is the code in the DLL Public Class Common 'Functions and other stuff End Class What option do I choose when I create a project Can anyone provide a step by step direction on how to create a DLL Thanks When you create a project - use the Class Library Template. File - New - Project -> Class Library and then place you classes in here. When you build the project it will create the output as a DLL which you can then reference in other projects. ...Show All

• 67RAM67 Working with an Array of Structures

  I am be being annoyed with "object is not set to an instance of the object" error message. I am working with a array of structures. What am I missing Friend Structure IdNums Friend OldID As Integer Friend NewID As Integer End Structure Friend MyIdNum() As IdNums *******I get the error on the "For each x in MyIdNum"******* Friend Function ReplaceNumber( ByVal id As Integer ) As Integer Dim x As New IdNums Dim Flag As Boolean = False For Each x In MyIdNum if id = x.OldID Then id = x.NewID Flag = True End If next If Flag = False Then Return -1 Else Return id End If End Function Thanks, ...Show All

• Chugupta HELP! Getting nothing reading/writing to COM1

  I downloaded "UsingTheSerialPort" as part of the VB 101 samples. When I run it, I do not get any sort of reply or indication that my text is being sent to the device I have attached to COM1 via an RS232 Null Modem cable. Stepping through the code with Debug shows that the ReadLine() code in the sample never gets executed and I'm not getting any error messages or warnings. I added displays and code to verfiy that the port is open: ComVal = SerialPort1.IsOpen MessageBox.Show( "Com1 Open:" & ComVal) I set ComVal to False when it is declared and it displays as True after the open on COM1. I'm fairly new to Visual Studio and VB 2005 so I'm hoping that someone has some good suggestions. ======= ...Show All

• DarthCoder Word Interop creating Tif's on some machines but not others

  I have written an application which uses MS Word to perform a MailMerge with data entered into a VB form to generate letters to be sent out to people. Some machines are expieirencing issues where a TIF file generated by the Microsoft Office Document Image Writer printer are invalid or corrupted files. I have had our Tech group make sure to apply the SP2 patch to all of the users MS Office. The version of the MODI Writer printer matches mine along with my test boxes. Some documents will be generated find and appear in the image viewer fine but some others do not. I cannot replicate this behavior on any of my machines as all of the documents generate fine and submit to our document storage system without a problem on my development machine a ...Show All

• PostMeridian intercepting keyDown events

  Public Sub MainForm_KeyDown( ByVal eventSender As System.Object, ByVal eventArgs As System.Windows.Forms.KeyEventArgs) Handles MyBase .KeyDown Dim KeyCode As Short = eventArgs.KeyCode Dim Shift As Short = eventArgs.KeyData \ &H10000 is what the upgrade wizard does with the following from vb6...but when I set a breakpoint, it isn't catching the firing of any keydowns , such as if I press on the 'A' keyboard button. What am I missing Thanks, -greg Public Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) ' a b c d e f g h i j k l m n o p q r s t u v w x y z '65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 KeyPreview = True ...Show All

• Ix-Xerri ClickOnce autoupdate question

  I have an application that I published to a local network folder with ClickOnce. I set the autoupdate option to check once every 7 days. If I publish an update of the same apps and same network folder , do I need to keep the old version in that same path, or do I have to remove it first then publish, so that it will automatically pick up the new version Yes, the publish version and assembly versions are two different things and are not(!) in sync with each other. You'll find the publish version under Project properties, on the Publish tab [see Publish version section]. If the checkbox under it is checked, Visual Studio will increment this version after each successful publishing. Andrej Hi, ...Show All

• Charles Tam Irritating effect from combo

  I have got a form that I open, in the forms load event i do the following Me .EDF1TableAdapter.Fill( Me .DataSet1.EDF1) Me .ENameComboBox.Text = "" Me .ENameComboBox.DroppedDown = True Me .ENameComboBox.Focus() when the form loads, the combobox is dropdown and does have focus, but its got a mouse cursor showing wait it does go away after you click in the combobox if you dont dropdown the combo it does do it, why Davids Learning its working fine for now. didnt the first time I put it at the end Thanks for helping Davids Learning Hmm, that's interesting, it reproes on my machine. Not sure why it's doing that, but you ca ...Show All

• NickNotYet Disabel or Enable the DELETE key programatically

  I wander if any body has a VB.NET or C#.NET code for disabling and enabling the DELETE key programatically; this problem is giving me a headache when using master detail relations using datagrids; please help thank yoy ziad dodin Do you mean the DELETE key on the grid, or disable user pressing Delete key HI I got the same problem, but when some one deleting the text in a combobox using delete key on the keyboard. can you suggest me how to disable the delete key on comboboxes and text boxes in vb.net Have you try to catch the Keydown / keyup event on this two event, don't fire deleting code. i wouldnt suggest disabling/disallowing the use of the delete key in your ap ...Show All

• stombiztalker FileLogTraceListener not writing to file beyond a constant max-size

  Hi Friends, I've been using FileLogTraceListener class to write log data to files. Since the data being written is continuously generated, I set the file to be created on a daily basis. I do not set up the maximum size for the log file. The problem is - My log files do not seem to grow beyond a fixed size (4833 K). All messages are written to log file till the file grows to this size and then no logs are appended. Here are my settings - faultLoglistener = new FileLogTraceListener(); faultLoglistener.Location = LogFileLocation.Custom; faultLoglistener.CustomLocation = "C:\\"; faultLoglistener.BaseFileName = "FaultLog"; faultLoglistener.LogFileCreationSchedule = LogFileCreationScheduleOption.Daily; faultLoglisten ...Show All

• efriese Updating a dataset (Syntax error (missing operator) in query expression)

  Hi all I keep getting a syntax error when I try updating my dataset. I can add and delete no problem it is just when I try to edit existing records. I have attached my update code below. Private Sub UpdateDataSet() 'Procedure to update the dataset if new record is to be added 'or existing one edited. Try Cursor.Current = Cursors.WaitCursor '------------------------------------------------------------------ Dim updateCommandBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(daComplaints) '------------------------------------------------------------------ If CurrProcess = "ADDING" Then 'Create a new row and add to table. Dim newRowValues As DataRow newRowVa ...Show All