Search results for query: *

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...

Thank You.

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...

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...

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.

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...

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...

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...

Sql Server Instance is set to Windows Authentication. Dataman86

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...

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...

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...

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...

That will work, Thank You DataMan86

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...

Yes that will work. Thanks

Also, I have MyDataReader inside a Function so you can't end Sub within a function. Dataman86

Where in my coding should your coding be placed? Also do you not need an End While and End With in your coding?

Hello out there, I need to place an error message with a MessageBox.Show when the Select Statement does not pull any records from the Sql Server. No records will pull if incorrect parameters are entered. I just do not know where to place it in my coding. Any help would be appreciated. My...

Riverguy, This will work, but I have another problem. When the comma is put in, i have to write the number out without the comma just like I did getting rid of the decimal point. See my coding. SDebitTextBox1 = Microsoft.VisualBasic.Right("00000000000000" &...