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 Chriss Miller 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 dataman86

  1. dataman86

    Drop Down Lists on a Web Form

    Ok, Table #1 is Issue which has IssueID, and Issue as fields. Table #2 is Resolution which has ResolutionID and Resolution as fields. Table #3 is ResolutionTime which has ResolutionTimeID and ResolutionTime as fields. Table #4 is the Time Table which holds TimeID and Time Received fields...
  2. dataman86

    Crystal Report with Count of Help Desk Issues

    Thank You.
  3. dataman86

    Crystal Report with Count of Help Desk Issues

    I have created a Call Issue Program in VB that keeps track of call issues handled by each computer technician. The MainCallIssue table has these fields: ID. Issue, Resolution, ResolutionTime, Time, WorkOrder#, DateTimeAdded, UserAdded, DateTimeModified, User Modified, Status, and Comments. I...
  4. dataman86

    Identity Seed Auto increment record

    Riverguy, I just wanted to be sure nothing was wrong with my application showing the 0 when I add a record with my login. I never have added a record to the database. This is my first time. Others have added records, but when I save my information added it shows the next record in sequence...
  5. dataman86

    Simple SQL Select Statement

    Markros, I have placed the TSequel Coding in and getting an error message whenI try to execute. ERROR PARSING QUERY.[TOKEN LINE NUMBER = 1, TOKEN LINE OFFSET = 1 TOKEN IN ERROR = DECLARE] ERROR SOURCE: SQL SERVER COMPACT ADO.NET PROVIDER IS ERROR SOURCE.
  6. dataman86

    Simple SQL Select Statement

    CompuVeg, First of all, I am new to SQl and very green in VB as well. I am about 10% and got 90% to learn. I can do a few things, but not many. I am trying to learn the syntax but have a long way to go. I have created my database with a MainCallIssue Table which I am trying to use the query...
  7. dataman86

    Simple SQL Select Statement

    Markros, I am getting an error message that the Declare statement is not supported when I try to insert this code in the Query builder. Do you place the Declare @Enddate smalldatetime, @Startdate smalldatetime along with the set statements in the query builder or the Visual Basic coding window...
  8. dataman86

    Simple SQL Select Statement

    Hi everyone, I have a SQL Select statement I am trying to write to pull some records from a table. I pretty much have no trouble until I get to the WHERE clause. I have fields ID, Issue, Resolution, and DateTimeAdded. I want to pull records that are incomplete less than 6 days old. I have...
  9. dataman86

    SQL Connection String Permission Problem

    Sql Server Instance is set to Windows Authentication. Dataman86
  10. dataman86

    SQL Connection String Permission Problem

    I have developed a SQL DataBase that holds several tables. I have a Main Table, Issue Table, Resolution Table, ResolutionTimeTable, and a Technician Table. The database will hold issues that each Technician is assigned keeping tracking of the times that the technician works on a particular...
  11. dataman86

    SQL Connection String Permission Problem

    I have developed a SQL DataBase that holds several tables. I have a Main Table, Issue Table, Resolution Table, ResolutionTimeTable, and a Technician Table. The database will hold issues that each Technician is assigned keeping tracking of the times that the technician works on a particular...
  12. dataman86

    Date Field

    Andrzejek, I have a data entry form in VB. I just need to load the current date for a row to the database. Thats it. I know pretty much how to retrieve a date after it is in the datebase. I will pretty much load the combo boxes with drop down lists, but I want the data field to...
  13. dataman86

    Date Field

    I have created a VB application which will keep track of call issues and post to a database setup in SQL Server 2005. I have databinded fields and I have combo box fields for Issues and Times. However, my date field, I want to default to the current date and post to the server. The current...
  14. dataman86

    Need to Do Something if No Server Connection

    That will work, Thank You DataMan86
  15. dataman86

    Need to Do Something if No Server Connection

    I have a Sql Statement that is pulling records based on Parameters entered in. I need to place a Try and Catch before the oCn.Open() in my coding so as to handle an exception that occurs when the Sql Connection is down. My Coding: Public Class Pull Dim Irows As Integer Dim _g As New...
See more

Part and Inventory Search

Back
Top