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

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

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

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

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

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

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

I have a Budget Application that has Numbers in TextBoxes coming in such as Income1TextBox.Text. The IncomeTextBox1.text Number might be 5000.00. I want the data changed to come in as 5,000.00. Is there a way to make the Income1TextBox1.Text field automatically appear with the 5,000.00 so it...

I have a form where users will be entering numbers in a textbox. I want an error message to appear when the user tabs to the next textbox and they have left the previous textbox blank. I want the error message to say MessageBox.Show ("Must Enter a Number with a decimal") The two TextBoxes are...

I am very new to VB and trying to understand Array's. I am having trouble referencing the contents of the Array in other areas of my application and I ma getting object Reference Errors and the contents of the Array appear as Nothing and I get a null reference error. The Array is being loaded...

Hello everyone, I have written a Visual Basic Application that is pulling data from the Sequel Server into an Array. The Array is used to load data into different pages of a Form. The user enters data isome of into two blank fields on the form. I need to write the data placed in the forms...

I have created a Form Template to use in creationof several forms. I am trying to reference fields on one form with fields from another form. The first form holds 12 lines and the 13 line shows up on another instance of another form by using a Next Page Button. I have an accounting...

Hello, Is it possible to have Visual Basic Coding to create Combo Boxes, TextBoxes, and Labels on the Fly? I need to have these created only on page one of my form and not have it appear on the other pages. I have created One Template Form to use where I am going from page top page with lines...

I want to print out a Landscaped Lettersize Form, and I want the settings automatically set in the code for each PC that the program is installed on where the user does not have to set the printer setting just for this printout all of the time, because the user may want to print other things...

I have a need to have sub routine to count the number of data lines coming from the Sequel Server. Is this a possibility with a sub routine or function in VB? DataMan86

I have a VB Windows Application that I need to add better functionality to. In the Accounting world we have Journal Vouchers that we must do to make adjustments to accounts when errors are made or other problems. I have a Sequel Server 2005 database that holds up to 20 to 30 million...

I have a InfoPath 2007 form that I have created for staff to use with email. The InfoPath Form has checked Boxes and Text Boxes with Borders which does not work in the InfoPath 2003 Version. The Check Boxes show up when the form is pulled up in InfoPath 2003, but it does not allow the user to...

I have a VB Application that has been published to a network location, but I need to do processing within the application but leave the application open to do other processing of maybe the same process. I need to close all forms that are open at once, so as to avoid the error message Appication...

I get an error message saying file not found when I try to publish my app. Coding: Dim Sr As New StreamReader("Test.txt") Dim sLine31 As String = " " Dim SLine34 As String = " " Dim sLine35 As String = "...