Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Kliot
  • Order by date
  1. Kliot

    Sql Server 2008 Replication Agent message code 20084

    Computer L is on a Domain computer R is on a WorkGroup, Nothing has changed with the VPN connection so all necessary ports should be open, this setup worked perfectly before I replaced Computer R. There may be something on Computer R "Windows 7 Pro" that is not allowing the connection but I sure...
  2. Kliot

    Sql Server 2008 Replication Agent message code 20084

    Thank you for the response, yes I have tried both pull and push subscriptions with the same result. Not sure what you mean by "Is the distributor a different machine/instance from R and L?" The distributor is computer R and the subscriber is computer L
  3. Kliot

    Sql Server 2008 Replication Agent message code 20084

    I replaced a computer at a remote location (Computer R) and I can no longer get replication to work with my local server (computer L), computer R is running windows 7 Professional with Sql Server 2008 R2, the computer it replaced was running Windows Server 2005 and Sql Server 2008 R2...
  4. Kliot

    Vs.Net Print Last Page Only

    I have a Vs.Net 2008 application that prints a report, I want to be able to print the last page only. I can print a range using StartPageN and EndPageN, is there a way to set it to only print the last page? I of course could use StartPageN and EndPageN but the lengh of the report varies. Thanks
  5. Kliot

    get size of Folders and subfolders

    You can use DirectoryInfo to loop through all the files on the drive and get info about each file and directory. Imports System.IO Dim dDir As DirectoryInfo dDir = New DirectoryInfo("D:\") For Each fFileSystemInfo In dDir.GetFiles("*.*", SearchOption.AllDirectories)...
  6. Kliot

    Never written a line of code in any of the .NET development tools - Where should I start?

    This is also a good site with lots of samples and tutorials. http://msdn.microsoft.com/en-us/vstudio/default
  7. Kliot

    Get currency exchange rates

    Where are you planning on getting the exchange rate from? Seems to me you would need to retreive the current rate from a web service such as Oneada.com. https://www.oanda.com/currency-data/currency-feed-xml from there you would receive an xml responce and you would just need to parse through...
  8. Kliot

    Help with HttpWebRequest

    I set up the same thing a few years ago and if I recall it was a pain to get working correctly. I have posted the code I use, you can compare your code to it and you should be able to figure out the problem pretty easily. I put my result into a dataset and display it on a form so my users can...
  9. Kliot

    TableAdapter vs BindingSource, curious about what is what?

    They are definitely not interchangeable, they all have a specific role. The DataTable is the in-memory data. TableAdapters communicates between your application and a database, executes queries, updates, procedures etc. All of this can be setup from the dataset, this is where you create your...
  10. Kliot

    Help With Form Design and Large Text Boxes

    How about having the 6-8 textboxes on the form displaying as much text as will fit and have your mousehover event display the tooltip with the full text of the textbox. This will give the user a quick view of all the textboxes and if they move the mouse over the textbox the full text will popup...
  11. Kliot

    VB.NET Equivalents

    Most should be pretty easy to figure out, think classes instead of commands. VB Dim d As DateTime = Now() DatePart(DateInterval.Day, d) VB.net Dim d As DateTime = DateTime.Now d.Day Dim s as string = " Leading Spaces" VB s = LTrim(s) VB.net s = s.TrimStart Hope this helps, if there...
  12. Kliot

    Connect to SQL Server across the internet...

    Vpn can be a simple solution if your hosting company is running windows server and has a static IP address. They would just have to set up the RRAS (Routing and Remote Access Service) on the server and the remote company then just needs to set up a Vpn Client to log in the the host server. If...
  13. Kliot

    Close a DataSet??

    It should dispose automatically when the form closes.
  14. Kliot

    adding existing project to solution

    I don't have 2010 but in 2008 if you right click on the solution in the "Solution Explorer" you have an "Add" option and from there you can select "Existing Solution
  15. Kliot

    Option Strict setting - new projects vs. existing projects

    No, you can set it any time just add the line at the very beginning of your code and build. Option Strict [ON : OFF]
  16. Kliot

    Sending emails with attachment

    MailTo doesn't support attachements. You can use the smtp client do send mail directly from VB with attachmmts. Perrin
  17. Kliot

    What is equal to Null

    Null is unknown so it would make sense that two unknowns ould not be equal. You should also take a look at String.IsNullOrEmpty() Method
  18. Kliot

    How to convert a string to a control name

    Zameer, This will add a new control to the form not add the text to the existing control.
  19. Kliot

    How to convert a string to a control name

    Try accessing the textbox like this CType(Me.Controls(c), TextBox).Text = "Succeeded!!
  20. Kliot

    > in Select Case

    Thanks for the tip, I'm not familiar with Cross Apply, I'll give it a try.

Part and Inventory Search

Back
Top