Answer Questions

• John Lockhart [OTP] VBA ADO Reading CSV file - text values, field type always Integer

  Hi All; I'm doing a VBA custom import of a basic CSV comma Delimited file. The second field I am reading in is an Employee Id which is usually a 4 digit number, but sometimes has an alpha character, e.g. "C195", in which case it brings in a blank field and in debugging the Type on this field is constantly set to "adInteger". So far everything I have tried isn't working to get this string value to come in. Below is a code snippet: objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & importpath & ";" & _ "Extended Properties=""text;HDR=NO;FMT=CSVDelimited""" objRecordset.Open "SELECT * FROM " & importfile & "", objConnection, adOpenDynamic, adLockOptimistic .... .... .... D ...Show All

• Dipesh Agrawal My.Settings strange problem

  I have been trying to figure out why one of my settings will not properly save. Here is what the user.config file looks like: < xml version="1.0" encoding="utf-8" > <configuration> <userSettings> <Project_Tracker.My.MySettings> <setting name="MainLocation" serializeAs="String"> <value>86, 112</value> </setting> <setting name="Engineer" serializeAs="String"> <value /> </setting> </Project_Tracker.My.MySettings> </userSettings> </configuration> Notice that the setting for "Engineer" is not propery formatted. If I manually change the ...Show All

• NickNotYet Q: Persistent Graphics on Form or PicBox: a real pain!!!

  Hi all, this is kind of a follow up on 2 earlier threads I started. This time the question is a bit more fundamental. It concerns replacement of the persistent graphic methods in VB6 with the Picbox_paint persistent graphics in VB.net. Whatever I try, and whatever help I ask I simply cannot perform the following task: (heavily simplified) I have a VB6 program that reads inputvalues (X and Y) from an A/D convertor. It continuously reads values at ~5 per second and plots them as vectors. Aim is to visualize outliers and get a quick view of grouping of the outliers. I definitely need to implement exacly this functionality in VB.net. After a number of days, millions or even billions of vectors are drawn, with only a few outliers. ...Show All

• qpsk Open???

  How do you use the menustrip open button to open a file well it depends how you want to open the file, and what type of file it is. you can open it directly, assuming its a textfile: Dim theReader as new System.IO.StreamReader( YourFile ) dim theContentsOfFile as String = theReader.ReadToeEnd() theReader.Close() Me.theTextBox.Text = theContentsOfFile or you could ask for the file they wish to open using the OpenFileDialog class and use the above approach of opening the file giving it the filename from the OpenFileDialog class FileName property can you be more specific on what type of file you wish to open there are many ways for different files Me.textbox1.Text ...Show All

• paso writing ANSII/ASCII characters using streams

  Ok so I have some text boxes that have some text in them, I think I know how to convert them to ascii chars by converting them to uni bytes then to ansii/ascii bytes then to ansii char arrays but just in case I have it wrong, and I still am having issues writing them to a data/text file, how do I do this and write them to a file Hi, how about writing the text directly to the file, using wanted (ASCII) encoding Dim text As String = TextBox1.Text My .Computer.FileSystem.WriteAllText( "c:\myfile.txt" , text, False , System.Text.Encoding.ASCII) Andrej Different as in they're using different encodings, I think I found the problem though, I'll post on here in a bit if I did in ...Show All

• vbjunkie use vbsrccopy function of VB in VB.Net

  I want to use the vbsrccopy function of vb in my vb.net application so anyone can help me in finding the alternate function of vbsrccopy in Vb.Net or how can i use that library function VBSrccopy is the library function of vbrun.rasteropconstant class in visual basic. The fastest way to do this is in an unsafe block in C#, you can access a Bitmaps bits directly. I assume you're after 30 fps animation, in which case DirectX is a better bet, but otherwise, C# would allow you to have a bitmap, do a straight memory copy of the bits into a pointer, and draw it every time. If you're calling BitBlt from the GDI library, then SRCCOPY is what you'd pass in C++, and in both cases, it's just a number. Work out what all those ...Show All

• Eli Brodsky Unable to modify VS2005 Binding Navigator in the inherited Form

  Hi! I put a BindingNavigator on a Form1 and set Modifier=Public. Then I created an inherited Form2. I put a BindingSource on Form2. But I cannot to set any value of inherited BindingNavigator because they are disabled. I need to set "BindingSource" property to the created BindingSource. Is it possible in other way than at run-time Stone I understand your frustration around this issue, but we disabled this scenario intentionally (for ToolStrips and ToolStrip derived controls such as BindingNavigator). We chose to not make the engineering effort it would have required to enable this scenario for VS 2005. This decision was not make lightly and we understand customers would like this functionality, but the existing visual inheritance a ...Show All

• Weston Williams CSV file records

  I am trying to read a CSV file into a datagrid (the csv file has 4 columns and up to 3000 records) and i found the following piece of code by JOE_MS which does exactly what i want: Using parser As New Microsoft.VisualBasic.FileIO.TextFieldParser( "c:\temp\myFile.csv" ) parser.SetDelimiters( "," ) While Not parser.EndOfData Me .DataGridView1.Rows.Add(parser.ReadFields()) End While End Using However i cannot find the textfieldparser in my system. Do i need to add a reference or does this only work in VB.NET 2005 as i am using VB.NET 2003 If i can't get it in VB.NET 2003 how do i do it Help please!! Yes Microsoft.VisualBasic.FileIO.TextFieldParser is not ...Show All

• WilfRosenbaum Read VB6 variant from a binary file with .net

  I need read from my .net application a binary file written with VB6. I can get longs and string written with VB6  with .net BinaryReader class ut how can I read vb6 variants Do you know how variants are save in binarry file how much bytes do they take Thanks in advance Thanks a lot. It run sucessfull. But where do you learn this There is any documentation Yes, I can read long and string types in the binary files with BinaryReader, but how can I read vb6 variant type :( Revrese engineering my dear!! I've done a VB6 program which i posted before then open the file using Binary Reader in the VS .NET then ReadBytes(with the whole file length) , add to watch ... finally i understood what is it. I have searched t ...Show All

• CruzPedro Including a DLL file in VB2005

  Hi, I am trying to add a reference to third party DLL file that has worked OK in VB6 but I am getting an error message. The error message is check it is accessible, a valid assembly or Com comp[onent. How do I know whether it is valid Presumably as it function in VB6 and it is a DLL it should function in VS. Can anyone help me if I send the DLL to them Thanks If its a valid COM component then it will need registering using Regsvr32 or using the installer package if its a Commercial 3rd party component. Once it has been installed then adding a reference in a VB 2005 application should be as simple as My Project -> References -> Add Reference >- COM Tab -> Browse and point to the dll file. This sh ...Show All

• gregaug VB.Net IDE Crashes Often...

  I am having a problem where my VB.Net IDE crashes often throughout the day... I have a Client/Server application that I am developing, shared between the two is a ClassLibrary I developed. So my Client and Server project both have this ClassLibrary as a Project added to the main Solutions. This way if I am in either the Client or the Server code, I can immediately get access to the ClassLibrary code to make changes if needed. Now, my problem is that several times a day, when I attempt to open a form in Design view, I get a white screen with a pink bar on the top that says: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may ...Show All

• Markus Ringl a program run as part of the setup did not finish as expected

  If I add a custom action to run a console application during setup, I get this error: There is a problem with this Windows Installer package: A program run as part of the setup did not finish as expected. How can I successfully get a console application to run during my product's setup Thanks, Matt I don't think the program I'm trying to have the installer launch is a managed program. I really have no idea what language was involved in the creation of it, but I suspect C++. It is an executable (.exe) that runs as a console application, that is, a black screen appears during execution and disappears when the program is done, which only lasts about one second. Bob ...Show All

• Thilakavathy Really funky combobox databinding problem...help!

  Ok, I'm really stumped. I have a form that is bound to BindingSource1, which through it's table adapter references a table of records. Two of the columns in that table are type and typeID. typeID is a foreign key into another table that basically lists all possible types. So I have a combobox on this form that I would like to populate with all possible types and bind the SelectedValue to BindingSource1 - typeID. I set up everything in the VS2005 designer to populate the list and bind the Selected Value. I run the app and open the form and everything seems to work fine, the combobox is populated and the proper item is selected according to the typeID that it is bound to. The problem I'm running in to is that when I change the selectio ...Show All

• Zaracattle FOR EACH

  Think I posted this in the wrong forum... Hi, There is a sample in the help for VS called " HOW TO: Make a Visual Basic .NET Class Usable in a For Each Statement". I wanted to use it for enumerating tax classes in a financial program as it would make the code more readable and lines shorter...So I modified the example only change was to add runtime initialisation of the items rather than a fixed set as in the example and it semi-works... In the example it passes only one iteration of the for each loop my application uses it many times and each instance after the first iteration fails with the loop never executing as it is at the end of the set. Applied this to the example as is and it has the ...Show All

• DFX1212 Score

  Hi, I've recently started using Visual Basic 2005 express edition, so I'm pretty new to the language and so. Though I'm getting the hang of it! But I have one question: I'm trying to make some questions in my program, something like this: Translate the following sentences from English to French: Do you live in England ................................................................[textbox] Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "Tu es alle en Angleterre " Then MessageBox.Show( "Good!" ) Else : MessageBox.Show( "False!" ) End If End Sub Then if you type it in c ...Show All