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 strongm 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: *

  1. lance59

    Adding crystalreport.rpt or any file to project for install

    I have several files that I would like to have installed at the same time the project is installed on the clients machine. Best I can tell is that you add them to the resources, but how do you tell the installer to make a new folder and load the files there? TIA
  2. lance59

    Image into SQL 2005

    I have this code but gives me an error on the insert statement. User selects image from file which loads into picturebox. I then pull out the image to store in SQL 2005. If have_image = True Then Dim ms As New MemoryStream PictureBox3.Image.Save(ms...
  3. lance59

    Primary Key question

    I have an inventory db with a table called items which I am using GUID for the item_id and table_key (auto incrementing) for the primary key. Works just fine. I also have a table called item_history which is a copy of items table including the primary key field. I am using this to be able to...
  4. lance59

    Form Validation before SQL Insert

    Thanks, I modified it to show that name rather then the control name for the user to understand. Friend Function CheckControlsForValues() As ArrayList Dim al As New ArrayList For Each c As Control In Me.Controls If TypeOf c Is TextBox Then If...
  5. lance59

    Form Validation before SQL Insert

    I have a form that has several text boxes and combo boxes. I need to validate that the text boxes and combo boxes have values in them before using the data to populate a table in SQL. For the text boxes I found this, which does check to see if they are empty. But if the user just skips to the...
  6. lance59

    Multiple Variables in One SQL select statement

    Thanks! That was it.
  7. lance59

    Multiple Variables in One SQL select statement

    ...and I end up with no errors but a blank datagridview. Using SQL 2005 and VB.Net (Visual Studio 2008) TextBox1.Text = str_item_column TextBox2.Text = str_item_type Dim SQL As String = "select * from item_table where '" + str_item_column +'" = '" + str_item_type + "'" Any help is...
  8. lance59

    What are you using for computer inventory/auditing?

    We are looking for a computer inventory/audit software. Open Source would be great but necessary. If you could sate why you like it that would be great. We have about 400 computer. TIA
  9. lance59

    Delete Script for email >30 & last logon > 60 days

    Looking for a script for Exchange 2007 SP1, that will delete email from a users inbox that is older then 30 days if the user has not logged on in the last 60 days. TIA
  10. lance59

    Stopping a service in Vista 64

    ...& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colListOfServices = objWMIService.ExecQuery ("Select * from Win32_Service Where Name ='Norton Antivirus Server' or Name = 'Symantec Antivirus'") For Each objService in colListOfServices objService.StopService()...
  11. lance59

    Permission Denied on file copy

    Thanks, but no help as we are trying to do this with a startup script. We don't want to have to manually do this to all 400 plus computers. Also we are doing this under computer startup scripts rather than user startup scripts so it is running as Local System Account rather than the users account.
  12. lance59

    Permission Denied on file copy

    ...<script language="VBScript"> WScript.Echo "VBScript" Set oFSO = CreateObject("Scripting.FileSystemObject") CopyGRC Wscript.Echo "Done" '******************************************************************************************************************************************** 'Copy...
  13. lance59

    Verify GridView item is selected

    Looking to verify that any item or row in gridview is selected before moving to the next page. If GridView1.?????????? = True Then Dim S2 As String = Server.UrlEncode(u) Response.Redirect("Registration.aspx?class_Reg1=" & S2) Else...
  14. lance59

    Output Parameter not working....

    OK. We did get it to work. We had to add the second line to make it work. It seems like you can't add the direction to the add line. Thanks, you got us going in the right direction. MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@Cert_ID_Out", SqlDbType.Int, 5))...
  15. lance59

    Output Parameter not working....

    Hi, Still returns a "1". Bob
  16. lance59

    Output Parameter not working....

    Here is the full vb.net side: Dim Myconnection As SqlConnection Dim MyDataAdapter As SqlDataAdapter 'Create a connection to the SQL Server. Myconnection = New SqlConnection("server=FIREFDM;" & "UID=xx;" & "Pwd=xxxxxx;" & ";database=CERTData") 'Create a...
  17. lance59

    Output Parameter not working....

    We have this SP that we what it to return the value of the @maxid. We where trying to use @CERT_ID_Out to send the value back, but it only returns the value we put in. Here is the SP: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[CERT_Add_Registration] -- Add the...
  18. lance59

    vb.net snippet for Motorola Symbol P370 Barcode Scanner

    I am looking for some code to grab the data from this scanner (via USB/cradle connection) to use in an inventory program we are developing. Not to keen on how to talk with or get the data out from this device. Any help would be appreciated. TIA
  19. lance59

    Weekly Win2003, ISA, SQL status reports to CIO?

    I am looking for some ideas on what should be included on a weekly or monthly status report for our Win2003 servers, MS SQL, MS ISA servers, Exchange 2007, IIS, etc... That gives a snap shot of the servers and applications. Looking for items such as: Status of backups Patches Errors pages...
  20. lance59

    Install raid drivers after OS install?

    Yes, not there. Windows does not install any drivers for SATA drives on install.

Part and Inventory Search

Back
Top