Jump to content
Xtreme .Net Talk

Derek Stone

*Gurus*
  • Posts

    1910
  • Joined

  • Last visited

Everything posted by Derek Stone

  1. Just extract the file to the Vb7 directory. You don't have to worry about which file goes where.
  2. http://www.visualbasicforum.com/showthread.php?s=&threadid=41088
  3. Neither can I, but Microsoft apparently thought we shouldn't be able to. Visual Basic .NET Standard Edition doesn't have a Class Library project type. You'd either need to upgrade to VS.NET Professional, or create a new project type by using the Visual Studio scripting system.
  4. Dim x As Control For Each x In Me.Controls MessageBox.Show("", "") Next
  5. Straight from the mouth of Microsoft. http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308470
  6. Enumerate the controls collection.
  7. The .NET SDK comes with one. I believe it's called Wintalker. [edit]It's Wintalk. You can find it under \%ProgramFiles%\Visual Studio .NET\Framework SDK\Samples\Applications\Wintalk\ if you have the SDK installed.[/edit]
  8. Use the Microsoft.Win32 namespace. The classes you're looking for are Registry and RegistryKey. [edit]Needed to re-word this one[/edit]
  9. You never declared the DataSource variable.
  10. Include the .NET redistributable in the installation package. http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-FILES/027/001/829/msdncompositedoc.xml&frame=true
  11. Ideally though you should ditch the function I posted and only open the connection one time, loop through and add the new records, and then close. I've given you all the code to do it, so I'll leave this part up to you. :)
  12. You'd call the above function like so: CreateMyOleDbCommand("INSERT INTO myTable (field1,field2,field3) " & _ "VALUES('Tom','Dick',Harry')", & _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ DataSource & ";Persist Security Info=False")
  13. Try to avoid using COM components, ADO included, in .NET. The exact same results can be achieved using ADO.NET. Public Sub CreateMyOleDbCommand(myExecuteQuery As String, _ myConnectionString As String) Dim myConnection As New OleDbConnection(myConnectionString) Dim myCommand As New OleDbCommand(myExecuteQuery, myConnection) myCommand.Connection.Open() myCommand.ExecuteNonQuery() MyConnection.Close() End Sub
  14. The "next record" exists, correct? If you're converting an Excel spreadsheet to an Access database the records wouldn't be there yet, and therefore would need to be created using a SQL INSERT INTO statement.
  15. Can you post a screenshot?
  16. Order is, in most cases, rather irrelevant when it comes to XML, so I doubt the framework includes built-in methods for rearranging the entries in the XML file.
  17. Eregnon, you might want to read the article below regarding file access. http://www.elitevb.com/content/01,0072,01/01.aspx
  18. Remember, that code will throw an error (Win32Exception) if Word isn't installed, so make sure to use a Try/Catch block.
  19. Unless you want to decode the AVI files yourself you don't have much of a choice. The control works well though, so I don't see a huge problem.
  20. The framework doesn't provide a direct method of retrieving email. You'll need to implement POP3 using the System.Net.Sockets namespace.
  21. I don't know how you can consider 20MB "a lot of space" when current hard drives are exceeding the 100GB mark. Even if you're working in an archaic environment with 4GB hard drives chances are there's plenty of space.
  22. Yes, there is. Rather easily too I might add.
  23. Works fine for me. How are you adding the component? Via Customize Toolbox?
  24. System.Diagnostics.Process.Start("winword")
  25. In a case like this where no data is ever displayed (as far as I know) I'd suggest using a DataReader object instead, the .Read method returning False if no data has been returned.
×
×
  • Create New...