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!

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

Recent content by HyperRon

  1. HyperRon

    Printer Orientation

    I have two reports that I'd like to merge into one two page report. The problem is that I want the 1st page to print in portait and the 2nd page to print landscape. I'm using .NET's crystal designer. Is there a way to accomplish this?
  2. HyperRon

    If I change a text in a textbox how can I call a function to handle an

    FYI, if VB.NET the sub's name doesn't matter when creating.
  3. HyperRon

    If I change a text in a textbox how can I call a function to handle an

    Private Sub txtPrice_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtPhone.TextChanged 'do something end Sub
  4. HyperRon

    set and exec

    Use this: Syntax was wrong in the post above for create table create table #tempMaxDate (MaxDate datetime) SET @query_max = "select max(date) from " + @link_server +".database1.dbo.table1" INSERT INTO #tempMaxDate exec(@query_max) SELECT @maxfound = MaxDate FROM...
  5. HyperRon

    Concatinating in a select statement

    select (cyb_first_name + ',' + cyb_last_name) as fullname should work
  6. HyperRon

    sp_executesql

    What are you trying to do? You have @m as Max(date) that's not declared and you have MaxDate without '@' in front of it. Kinda confusing. Or maybe I'm on crack lol Take a look at this...
  7. HyperRon

    Run Application with Command Arguments from xp_cmdshell

    That works for some odd reason. Thanks for the work around. It'll buy me some time at least :)
  8. HyperRon

    Run Application with Command Arguments from xp_cmdshell

    I'm trying to run an application using xp_cmdshell that takes an input parameter.. looks like this: "myapp.exe 32" where 32 is the id of some record in a table. meaning that i only want the program to process one record. when i run myapp.exe without the parameter it runs through...
  9. HyperRon

    WMI VB.NET

    I originally tried doing this using xp_cmdshell but, it kept hanging so I tried this (which i found via search) and it worked: CREATE PROCEDURE dbo.sp_cmdshell(@cmd varchar(255), @Wait int = 0) AS --Create WScript.Shell object DECLARE @result int, @OLEResult int, @RunResult int DECLARE...
  10. HyperRon

    Launch application on Server from Client App

    i tried that and it just hangs. i've been researching how to accomplish this using WMI but, I can't find any .NET references and have not gotten a response from my post in the VB.NET forum yet. Thanks for all the help :)
  11. HyperRon

    WMI VB.NET

    I need to run application on a remote machine. I have this code in VB 6 but, can't seem to get it working in VB.NET (windows 2000 network). Dim strComputer As String Dim objWMIService As Object Dim errReturn As Long Dim intProcessID As Long strComputer = "dev2&quot...
  12. HyperRon

    Launch application on Server from Client App

    Thanks.
  13. HyperRon

    Launch application on Server from Client App

    I thought about that first but, the procedure just hangs. I've screwing with VB .NET and WMI but, can't seem to get it working that way either. I'm having trouble finding anything on WMI and VB .NET for this.
  14. HyperRon

    Launch application on Server from Client App

    I'm in need of a way to kick off application (A) from a desktop application (B) and have application (A) run ON the server it resides and not the machine application (B) is running on. Both Apps are VB .NET applications running on windows 2000 servers. Application (A) requires no user...
  15. HyperRon

    Crystal .NET

    I have a subreport where I need to select the top three records from a table "select top 3 * from tblMyReport". Is there an easy way to do this? It currently show all the records. I'm a crystal beginner and am under the gun. Any help would be greatly appreciated.
See more

Part and Inventory Search

Back
Top