Answer Questions

• David Brenchley Doing an Update query using Dataadapter

  Needed an expert to tell me if I am on the right track for doing an update query to change a field in an Access table using OLEDB. Here is the code I think would work. I know how to do in under ADO Classic in VB6 but know things are different now. Dim DaMain As New OleDbDataAdapter Dim DtMain As New DataTable Dim sql As String = "update [" & SourceDatabase * "] Set [" & FieldName & "] = " & RecordID & " where [" & FieldName & "] = " & OldRecordID DaMain.SelectCommand = New OleDbCommand(sql, CountySourceConnection) DaMain.Update(DtMain) Thanks Larry Gatlin Great! Than ...Show All

• RajeshPKumar No Windows Control Library icon? and Is there a way...

  Does anyone have any idea why when I open a new project there's no Windows Control Library icon to select I had no clue why it wasn't there so I re-installed VB 2005 Express and it still doesn't show up. Also, I created an sql database and got an edit form working using textboxes by dragging table columns onto my form. When entering data the tab key must is used to move to the next column. Is there a way to change that to use the enter key TIA Mike In answer to your first question, although the full version of Visual Studio has a Windows Control Library project template, this template is not in the Express edition.  However, since the Windows Control Library project template is just a Class ...Show All

• thuthinh 2005 Compiler not recognising code changes

  Ok you guys, I know this is probably going to be something really simple so I apologise in advance. I've recently converted a vb.net 2003 solution to 2005. everything is great and I've got rid of my pre-compilation conversion errors and warnings etc and am reading to carry on development. My problem is this - in a sub project (which is referenced in the main solution by the sub projects DLL file, but I also change the source code for the subproject whilst in the main solution (hope that's clear!)), when I change or add to the source code (in the sub project) and start debug, or even rebuild the whole solution, the new code doesn't get picked up. I've tried putting a breakpoint in the code, and it doesn't pick it up, so i tried typing " ...Show All

• VladR VB.Net, Access, Excel, and the Office PIAs

  hello, I have been tasked with writing a VB.net application that can take excel spreadsheets and convert the entries into the correct database entries (in an Access database). I am using VB because of its ease of use and quick results (and because I've done it before). However, I have been doing some research to determine what the best way to accomplish this is and that is how I found the Office PIAs. I have not used them before and don't know what their limitations or advantages are. There's not a lot online about them and I think they might make it easier to access information in my spreadsheets. So my question is, " How can I use or should I use the Office PIAs to directly access the spreadsheets I need to tear apart " ...Show All

• DennisW511 Special type of ListBox?

  I need a multi-columed list box where the entire row is one item though, kind of like the listbox that the IDE uses for build error listing. Is their such a control, or property for the listbox control oh i see, your code shows me exactly what you are talking about a listview, not a listbox which is what i've been using. EDIT: Ah you did specify listview in your original post, i just needed to RTFP. well they don't exist in 2005 What version of VB are you using (although I believe those properties are valid all they way back to VB6) Are you creating the listview control progmatically or dropping it on the designer surface ...Show All

• Krivahn Copying Listbox items

  I have two list boxes.  Listbox1 and Listbox2 Listbox1 is Bound to a datasource and Listbox2 isn't. What I am trying to do is read each item in Listbox1 and Add it to Listbox2. I have tried multiple variances of the following code but can't seem to access the text for the item in the listbox1 items.  Can anyone help please   Dim intCounter As Integer Dim intTotal As Integer intTotal = ListBox1.Items.Count For intCounter = 0 To intTotal - 1            ListBox2.Items.Add(ListBox1.Items(intCounter).ToString) Next intCounter     thanks tattoo   try: fo ...Show All

• FredMunro Saving the Forms Image as a picture

  Is it possible to save the forms face and only the form as apposed to the whole screen, OR even better part of the forms face, as an image/bmp I have a homemade scanner that feeds data into the computer where it is processed as tiny panels of different colours until it forms a whole picture. I want to be able to save the form it's on OR the panels themselves as a group as an image. Is this possible Hi, I think this article http://msdn2.microsoft.com/en-us/library/6he9hz8c.aspx contains the code to do what you need. Quoting from the article, please refer to it for the full code. Dim memoryImage As Bitmap Private Sub CaptureScreen() Dim myGraphics As Graphics = Me .CreateGraphics() ...Show All

• barkingdog Old code issues...

  I use VB6 at school, and was quite used to doing the following: number = txtbox1.txt mumber = number+42 lbl1.caption = number Why does it not work with the new version, and hw can I fix it What I'm looking for is a way to get text (in this case numbers) from a textbox, manipulate it, and output it to a label. How can I do this Also., for later purposes, how do I directly output a textbox to label that still wont work as you need to CONVERT the value to an integer, even then it may not work as the value may not be a numeric value. This is what you would do: Dim theNumber as Integer theNumber = Convert.ToInt32(Me.theTextBox.Text) theNumber = theNumber + 42 Me.theLabel.Text = theNumber.ToString() ...Show All

• _Matt Smith _ Passing a Structure

  I am attempting to pass a structure from one DLL to another. The Structures are identically define in each DLL (Cut-and-Paste), but compiler complains it cannot convert types. I've tried the usual 'fixes' -- moving code around, changing ByVal to ByRef, etc., etc., etc. No Help. Any ideas ERROR: Value of type 'LPM.Menu.User_Data' cannot be converted to 'SS.clsUpdates.User_Data' <CODE> ' ' In One DLL ' Public Class Menu #Region "Structures" Public Structure User_Data Dim ID As Integer Dim Role As String Dim Preferences As String End Structure #End Region #Region "Variables" Public UserData As User_Data #End Region #Region "Update" Priv ...Show All

• Hoakie How to generate following function "IsValid" using codedom?

  Public Overloads Function IsValid() As Boolean If ( _ My_int < 0 Or _ my_date = DateTime.MinValue Or _ my_decimal = Decimal .MinValue Or _ my_arraylist Is Nothing ) Then Return False End If Return MyBase .IsValid() End Function Also the no.(and data type) of parameters (e.g My_int, my_date ) can vary and codedom should be able to emit code both in C# and VB.Net. Thanks in advance This generates code which is close syntactically, and functionaly equivalent: ' imports Imports System.CodeDom Imports System.CodeDom.Compiler Imports microsoft.VisualBasic Imports microsoft.CSharp Imports System.io ' ...Show All

• D. Choquette Troubleshooting with IDE - Unable to open search!

  Hi. I have Visual Basic 2005 Express Edition and I am having problems with the "Search" option, where you type in Keywords and it searches on 4 different websites / places including my on-board MSDN. It has worked before, in the past, and has been very helpful... But lately it will not open when I try to start it. When I click on the "Search" button at the top it gives me this message box: "The type initializer for 'Microsoft.VisualStudio.CommonIDE.Help.Sylesheet' threw an exception." and that is all that it tells me. I have no idea why it says this and will not open. I have also tried reinstalling my software and that did not help a thing. Thanks, I hope you can help. -Joe M. ...Show All

• swingme How to send e-mail? Try this way.>>

  As the question, how to send e-mail I don't know what's the code for send e-mail. Can anyone teach me how to I have a button on the Menu Tool. I want when user presses that button, it will directly link to the Microsoft Office to send e-mail to me. Please teach me. By the way, I also want to know how to load a text file. I want to make another button on the menu tool so when user presses it, a text file will pop up. Thank you You probably need a .doc SDK or something for reading it to plain text, theres too much formatting to just ReadAllText and send the result. You probably want to use some pre-done code, check out attachment_doc: http://sourceforge.net/projects/attachment-doc/ with some sl ...Show All

• Raffaele Rialdi Need help exporting VB.Net variables/data to VBA macro

  Hi I'm using VBA AutoCAD for drawing, but instead of defining parameters in VBA, I would like to take those parameters from VB.Net codes. Here is an example Sub CreateCylinder() Dim CylinderObj As Acad3DSolid Dim center(0 To 2) As Double Dim radius As Double Dim height As Double ' Define the cylinder parameters center(0) = 5#: center(1) = 5#: center(2) = 0 radius = 10#: height = 20# ' Create the cylinder in model space Set CylinderObj = ThisDrawing.ModelSpace.AddCylinder(center, radius, height) End Sub This VBA code will create a cylinder at co-ordinates (5,5,0) with radius = 10 and height = 20. I would like to know how to link or export these parameters from VB.Net to VBA AutoCAD for plotting. Many t ...Show All

• Xtremer Scroll Bars

  When the max value of a HScrollBar is set to 100, the actual runtime max value is 91. What's up ...Show All

• Knvb1123 Function to open a form, then when it is closed, return a value back to original form

  Hi Guys! Basically I'm after a way I can open a form (say, form2 for the exercise), then when form2 is closed, the function will return a value from a textbox on form2, obviously calling the function from form1. I've got something like the following... #FORM2 Public Class Form2 Dim Showing As Boolean = True Public ReadOnly Property ValueIWant() As String Get ValueIWant = Me .TextBox.Text End Get End Property Public Function GetValueFromForm2() as String Me.Show() If Me. IsShowing = False Return Me. ValueIWant End Function Public ReadOnly Property IsShowing() As Boolean Get IsShowing = Showing End Get End Property 'There is also a sub that alters "Showing" to false when a button ...Show All