Answer Questions

• Gabriel Méndez VBA call to VB 2005 DLL (COM) fails

  Hi, I have to call a DLL (COM in VS 2005 lingo) from inside Excel 2000 (VBA code). When I compile the DLL on .NET Framework 1 it works fine. However, when I compile the DLL in .NET 2 I run into a "File or assembly name <dll name> or one of its dependencies was not found" Please help if you can. Thanks much Dogleg, I finally found the answer. I will paste the answer posted by another MSDN user. User by the name of "Blackwood" posted the below answer. I don't know how best to link it, so I copied the text. Basically, what must be done is use the patch (KB908002) and deploy it with another application to the target client machine. Then follow the instructions below to deploy the DLL to the client ...Show All

• Pr0fess0rX 'dataSet' argument cannot be null error

  hello fellow VB2005 programmers. i have this problem that i had been trying to solve for hours but have not come up to any solutions even Googling isnt enough. let me discribe my situation here so you can see whats the cause for the error if you can spot it ok 1. i have a solution/project in which is composed of: a.) a Webservice and b.) a Client VB2005 application. 2. the Webservice stands for the middle tier in my 3-tier-application. Ok, so you get it Database tier is an SQL Server 2005, Middle tier is the ASP.NET Webservice using VB as language, and Client tier is a VB2005 application. 3. the webservice has two webmethods. named GetTestData and UpdateTestData which are functions respectively.i will post the source code o ...Show All

• Aabra Full Screen

  I know this may seem a daft question, i know that creating an application you get a window, but in creating a game how can you use the entire screen For someone experienced in VB, perhaps conversion to VB.NET would be straightforward, but for me it isn't. Looking at the code, I'm stumped as to how I would convert this to VB. I use Visual Basic 2005 Express, so, if anyone has the VB equivalent of the code at http://www.vesic.org/english/blog/winforms/full-screen-maximize/ that would be helpful. Just taking a guess here, but you could set the FormBorderStyle option to None, and then on the form load put the following code which will resize the window to the screen size: ...Show All

• Wendell G Problems searching a database using vb6

  Hi I'm having problems with this code for a search button but it keeps giving me a Data type mismatch in criteria expression error. The error comes in this part of the code 'RS.Open strSQL, cn, adOpenKeyset, adLockPessimistic, adCmdText' Can anyone help me with it Thanks Private Sub cmdSearch_Click() Dim strSQL As String strSQL = "SELECT * FROM cdtable" If txtSearch.Text <> "" Then strSQL = strSQL & " WHERE BandArtist = " & Val(txtSearch.Text) End If RS.Close RS.Open strSQL, cn, adOpenKeyset, adLockPessimistic, adCmdText bandartisttext.Text = "" & RS!BandArtist albumnametext.Text = "" & RS!Album genretext.Text = "" & RS!Genre advisorycombo.Text = & ...Show All

• Marcelene Browser question/code.

  I'm having some trouble finding the code to open an HTML file and display it in a web browser. All I've been able to find are methods to open text files...can anyone help me out Thanks ;p Thanks! Helped alot ;p well it depends how you wish to open the html file. if you want to just open the html file so it displays it in the internet browser, simply start a process to execute that html file so it opens in the assigned program in Windows. Example: Dim myProcess as new System.Diagnostics.Process() myProcess.Start( PathToHtmlFile ) if you are talking about a webbrowser control on your form, simply "Navigate" to the file (if its on your lo ...Show All

• banswaraboy More than one datareader at the same time?

  How to replicate this snippet of code using Ado 2.0 I mean, you are not able to use two datareaders associated to the same connection. Let me know, how do I such thing, I'm just a newbie with ADo .Net. TIA  sql = "select..."  command.commandtext = sql  set recordset = command.execute   While Not recordset.EOF    sql2 = "select..."  command.commandtext = sql2  set recordset2 = command.execute  While Not recordset2      Wend    Wend   Once you "fill" you tables within the dataset then you can loop through the tables, such as dim dt1 as DataTable = dsDataset.Tables(0) dim dt2 as DataTable = dsDataset.Tables(1) F ...Show All

• Pwint Storing HTML source in string then saving

  I need to open an HTML file as plain text, and store its contents in a string. I wrote some code to make minor changes to the string Then I need to save the string into a NEW html file. How would I go about doing this   Hi,  I would look into using StreamReader and StreamWriter mainly and maybe the String.Split method. See the url links in my post in this thread.>> http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1135010&SiteID=1   The MSDN library is a great resource for help on commands etcetera.>> http://msdn.microsoft.com/library/   Regards, S_DS   l33t, What is the meaning of move to a new line with St ...Show All

• jaimlin keeping current Date

  I am writing to a file, and on the file name I would like to have the date that it was created like fileName3/3/2005 how would i go about doing that when i do Private const File_Name = "C:\FileCreated" Dim runningDate As Date = Date.Now Using writer As Streamwriter = File.CreateText(File_Name + runningDate) writer.WriteLine("_______Hello___________") writer.Close() End Using i get a invalid path name exception.....any help on how to fix this I am using .Net 2.0 and there is no replace method of Date.Today or DateTime.Today any other way this can be done You need to remove invalid chars from the date string try following Dim runningDate As Date = DateTime.Today usin ...Show All

• asalcedo Copy dictory

  Hello   I am trying to make my program to copy a folder and paste it to somewhere else. But it gives be an error when i try this. btw i am trying to make a timer do this. when i use my.computer.filesystem.copydictory will it then overwright the other files in the folder cuz i need it to do that... Just keep copy and overwright but if a file in the folder that is copyed from gets deleded it may not get deleded in the copyed folder   my code:   Public Class Form1 Dim hvor As String = "C:\Programmer\Wizet\MapleStory\GameGuard" Dim hvortil As String = "C:\Programmer\Wizet\MapleStory\GameGuard2" Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As Sy ...Show All

• carpediembr getting binary from file.

  Private Function TextFromFile( ByRef fInStream As String ) As String Dim i As Integer Dim strText As String i = FreeFile strText = "" FileOpen(i, fInStream, OpenMode.Input, , OpenShare.LockWrite) System.Windows.Forms.Application.DoEvents() strText = StrConv( InputB (LOF(i), i), vbUnicode) --- this is the original code strText = My .Computer.FileSystem.ReadAllBytes(i) ---- I just added this to try FileClose(i) TextFromFile = strText End Function I just converted this code from mVB6 to 2005.net, but you will see a one of the functions don't exist any more (inputB), which is grabbing the binary info from a text file. I attempted to do the same ...Show All

• Averied Running a DOS command from within a VB application

  Hi all. I am a newbie, and I am trying to develop a graphical interface to automate a task that I usually execute through a batch program. I have to execute an external command-line program that is not capable of accepting parameters. In my batch files I always solved the problem redirecting the input: my_command < input_file So I tried something like this (which works perfectly when the external program accepts parameters): procId = Process.Start("my_command", " < input_file") This doesn't work, and this is the reason why I am here to beg you help..... Can someone help this sad newbie ! Regards ___ Max Try this: procId = Process.Start(&qu ...Show All

• Geoffrey Callaghan Formatting date in vb.net when the date comes from Excel 2003

  I'm trying to parse a date to the format 'yyyymmdd'. The date comes from an excel cell that is formated for dates like mm/dd/yyyy. I read the cell into an arraylist and try to format it something like this Dim a as new arraylist Dim xl as excel.application xl.workbooks.open ... Dim s as string Dim i as integer = 0 s = Ctype(xl.cells(r,c).value,string) a.add(s) Dim d as new datetime d = a(i) Dim ds as string ds = d.tostring("yyyymmdd") if I read 10/22/2006 from the spreadsheet, the value d will contain the value #10/22/2006#, but ds will contain 20060022 if I replace d=a(i) with d=ctype(s,datetime), I get the same result. VB's format function does the same thing. Any suggestions ...Show All

• Leon Langleyben HOW TO: Loop Through a DataGrid and send it to a TextFile.txt-.NET 2.0

  How do I Loop Through a DataGrid subform and send it to a TextFile.txt which version of the .NET Framework are you using .NET 1.1 or .NET 2.0 well you can iterate through each row and each column then write to textfile. Example: using theWriter as new System.IO.StreamWriter("file.txt") for each currentRow as DataGridViewRow in Me.theDataGridViewRow for each currentColumn as DataGridViewColumn in Me.theDataGridViewRow theWriter.Write(currentRow.Cells(currentColumn.Name).Value.ToString() + ",") next theWriter.Write(Environment.NewLine) next end using I saw where you guys were able to help the respondent loop through a datagrid and send the data to a textfil ...Show All

• Kuei-yang Lo shaped controls

  hallo. I'm trying to create an irregular shaped button. I know that it sounds simple enough but the thing is that i need to trigger events only if the cursor is within the shape itself (not in the ractangle containing the control). Any ideas You need to create a region for the control. Check out the shape controls on the vb-tips website for an example. ...Show All

• C&amp;#233;dric_M DataGridView Row Slection Question

  What I would like to do is, if the user selects a single row, all the fields from that row are displayed in individual text boxe, ie.. a detail screen for that row, I am just stumped on how to get the data, by column, for the selected row. Any help would be appreciated. John Actually, I am looking for a way to do this without bound controls. I guess the better way to phrase the question is how do I capture (display)the data from a specific column, based on the row clicked My DataGridView has many columns that are not visible without scrolling, but there are key fields that I would like to have "pop up" when I click the row. John OK You can reference the the rows and ce ...Show All