Answer Questions

• DQM Add connection wizard fails with Access database

  I have the RTM version installed. I am quite puzzled at this wizard. It works fine with SqlClient. But for Access databases, this wizard completely fails. In this wizard, I only have one option to do - setting the ConnectionString. I set it to Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\path\abc.mdb, which works fine in my code. But when I click OK, it complains: --------------------------- Microsoft Visual Studio --------------------------- Format of the initialization string does not conform to specification starting at index 0. --------------------------- OK   --------------------------- And more, the Advanced button is disabled and the dialog does have the same funtionalities as described in MSDN ms-help://MS.VSCC.v80/MS ...Show All

• Michael Schwarz - AjaxPro making a dynamic .exe at runtime

  how in vb 2005 would i make an exe at runtime. For example say i hade my main program (main.exe) and i wanted it to take an imput in at runtime say input = textbox1.text and then i wanted the main.exe to make a program that would make lable1.text = input try by making batch file.. another way i hv heard is "Shell command" shell "main.exe" + input try..it may work ...Show All

• ruben_itlp reading from an xls file (into VB) without using Excel

  Hi everyone, I've written a program in VB which accesses data from an xls file. Right now I open excel, and then hide it (so it is invisable to the user) to read the data from the file. Then I have a close button on my program which the user can click and as the program exits, it also closes excel. I have removed the "x" from the taskbar on my program, but I still run into problems if the user uses ctrl+alt+del. I am sure this is probably the worst way to read from this file, but it does get the job done... although very buggy and error prone. I was wondering if someone could inform me of a way to read in this data in a more efficient manner. Possibly even if the user doesn't have excel installed on their computer I am no ...Show All

• elwood Exporting Excel to an access table.

  Hi, I have an access db called TablePeople. This table has the following fields: PeopleID FirstName LastName UserName I have an excel spreadsheet called People.xls that has the same fields as TablePeople. What I want to do is to import all the data in the excel spreadsheet to TablePeople using VBA that is shipped with access. Can somebody point out what are the steps I need to take in order to automate this process Thanks Hi, I don't know VBA well enough but you could always SAVE AS the file in CSV format and then load it into ACCESS or vice-versa. CSV=Comma Separated Value ( text file ). Regards, S_DS. hi, It is easy to do this with Excel, just reco ...Show All

• creaturita Process control exception handling

  Hey all, Please could anyone suggest the best way to handle a win32 exception that would be thrown if the file I try to launch is not dettected Many thanks, Tom. hi all, Thanks for your help. Best wishes, Tom. Um, what do you mean by 'launch' What code are you using to perform this launch Usually, one would use Try/Catch ...but you haven't given enough information about what you are doing such that a Win32 error would be thrown. The best way is to use a try/catch block. Example Sub LanchProgram(ByVal exePath As String) Try ' Your code to launch the program Catch ex As Win32Exception ' Print an error message End Try E ...Show All

• Morten Petteroe pop3 code to check NDR

  I was hoping someone could help me. I'm looking to write a vb.net or 6 app to check a specific pop account for any NDR messages. I'm not intersted in sending, etc, but would like to scan the pop account and find the email address that the email was orginally sent to, so it could then inturn delete that email address from a my database. Anyone know of some simple code that could do this pop3, ndr, etc is not being defined. is there some other project references I need to make first Terry Fox, There are two steps to finish your demand: Check the POP Server response: Private Function CorrectedResponse( ByVal ReceivedBytes() As Byte , _ Optional ByRef Message As String = "&qu ...Show All

• Giber Mdi Form question

  Hi all, this is a very simple question but is driving me nuts !!! i have made a simple MDI aplication ( a single Parent Form with MDI Control Activated and a simple Blank form ) and i have made this simple code in my Menu Dim frm As New Form2 frm.MdiParent = Me frm.Show() so it works fine. when i press a few times the button it opens the new from2 inside of the mdi parent, but supose that i have open 4 forms, and close them all and when i open the 5 form it instead of open in top left corner  ( because i don’t have any other from open ) it opens in the same sequence of the others !!! ( this is in cascade ) is there any way to solve this ! thks JSB   frm ...Show All

• Witek DeviceIOControl and SCSI_PASS_THROUGH_DIRECT

  Hi, I'm trying to get data from a SCSI Inquiry command in VB. I'm using DeviceIOControl with SCSI_PASS_THROUGH_DIRECT - the call goes through OK and DeviceIOControl returns 0, but I can't seem to get the expected data back - retBytes just contains 7 bytes of seemingly (but probably not) random data: (40, 4, 20, 0 , 40, 4, 20). Changing scsi.dataIn to 0 gets me 255 bytes of data, but not the data I should be getting. Any help would be greatly appreciated. Here's what I'm doing. offset as Byte is ignored for now, and fileHandle is a valid handle to \\.\F:. Private Function getVPDPage(ByVal offset As Byte, ByVal fileHandle As Long) As Byte() Dim status As Long Dim dIn As IntPtr = Marshal.AllocHGlobal(255) Dim dOut As IntPtr = Ma ...Show All

• Amit Online hopefully a little problem with listbox/getfiles

  dear ladys and gentlemen, i've got a maybe little problem with the path in an listbox, when i use this code: For Each foundfile As String In My .Computer.FileSystem.GetFiles( _ ( "c:\nuproject\txtfiles\komm" ), _ FileIO.SearchOption.SearchTopLevelOnly, "*.txt" ) ListBox1.Items.Add(foundfile) TextBox1.Text = "" Timer1.Enabled = True Next then i got a list of all txt-files in this directory. so far so good, but i don't want the path be in there. so c:\nuproject\txtfiles\komm\ should be hidden! thanks for your solution! ListBox1.Items.Add( My .Computer.FileSystem.GetName(foundfile)) Using th ...Show All

• Shane1990 Using .DLL files

  I have looked for a while on the internet but I cant figr it out, how do I call and use functions in a VB app from a dll file. Probably, Unmanaged API's The following may help example a little more http://www.codeproject.com/dotnet/PInvoke.asp This is a useful site for finding the declare statements for many of the Win32 API's - on some of them there are sample code you can call. http://www.pinvoke.net/ Also, the developer of the API, should be able to provide some documentation / information on the methods inside and calling from various different languages. There are a number of different types of DLL COM / ActiveX .NET Class Libraries Unmanaged API ...Show All

• Mohsen Kokabi Parsing a non-delimited(space I imagine) text file

  I have a text file that has been exported from a Progress Database v8.23e (this is an old system, i know) . I need to parse the data to a dataset or XML or anything that has structure heh, any ideas Ive tried multiple threads here on parsing text files as well as searched MSDN/Codezone and they did not work. 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX GRILLED CHICKEN SALAD 5.00EA428565-00 3.95 09/07/06 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX CHICKEN SALAD ON CROISSANT 4.00EA428565-00 3.25 09/07/06 0278XX'S XXXXXX PXXXXXX #49 101new multi unit 94919S & W WHOLESALE SAND ACCXXXXXX CEASAR WRAP ...Show All

• Zac Boyles It ain't necessarily so ...

  In the documentation, you state: "When you print a form, everything in the client area of the form is printed. This includes all controls and any text or graphics drawn on the form by graphics methods. " I have a form on which I place graphics with DrawImage and ran into this problem: PrintForm only pick up the dynamic content in Compatibility Mode (both 'Full Window' and 'Client Area'). It doesn't work in the other modes. Is this by design or is it a bug Roger Right ... that's exactly it. Since I'm on XP - Home, I didn't think "... some operating systems ...' applied to me. Roger Hi Roger, If I understand you correctly the custom graphics that you're adding to the form a ...Show All

• GLutz78 Intellisense Selection

  Ok this is for the ide experts. Is there any way to bind the "enter" key so select the highlighted member in the intellisense dropdown Right now it's the "Tab" to select but I just can't get used to it. Same goes for html source. The enter will select it, but it adds a carrage return. Thanks. Would be nice if the option could be changed in the IDE options :-) I personally dont mind but I use C# 99% of the time but it would be nice to have something like this which can be enabled/disabled from the environment options in the IDE The behavior where pressing ENTER in intellisense inserts the CR/LF comes from the days of VB6 and is something that was preserverd. Apparently ...Show All

• NickoM call data from one form to another and other questions

  Hi i am using vb.net i have 2 forms , form 1 contains 2 labels, 1 listbox and 6 comboboxs and form 2 contains 1 richtextbox. i want call data from the tools in the form1 to richtextbox in the form2 by using button how can i call data from one form to another >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> if i in form1 and i want go to form2 by button , form1 doesn't close !!!! how can i let form 1 close >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> i have in the form 1 datagrid also, i want add data from labels and comboboxes to datag ...Show All

• kunal.pandya Why VB compiler is allways running !?

  I’m sorry, i just don’t want to be rude. I have a few simple questions !!! 1o Microsoft want to KILL VB ! 2o if not, so why the stupid compiler start compiling a every line i wrote. 3a Why this experiencing is not lived by the C# compiler !! perhaps the C# team made very good job !!! 4o The performace patched release by you guys, work but the problem is not solved, the IDE continues flinking, the compiler is allways running, the bigger projects continues to be slow to work on them..... Sorry, but i’m working with VB.NET for a quite long time ( since VB.NET 2002 and 8 hours day) , and i’m doing a very large application since them and for the last 6 to 8 months i was experiencing something that i never imagine, slow pr ...Show All