Search results

  1. E

    Form Misread

    I have an application that uses a dataset to collect user information(login and password). I have written a loop that searches the datatable. All was working fine until I reseeded the table. This is my original loop: For i As Integer = 0 To Me.UserDataSet.Users.Rows.Count - 1 If...
  2. E

    Using a listbox to change focus between forms.

    I have an multiform application that lists the open forms (by name[text]) in a listbox on the main form. As a new form is opened a string representing that form is sent to the listbox. What I am trying to do is set it so that when the selected index changes, between form names, that particular...
  3. E

    open Excel file

    I assume this example will lead me to the path of opening a file through vb? I will work to modify accordingly.
  4. E

    Need help with an ADO style update.

    Can anyone tell me why this is not updating my SQL database. Dim updatestatus AsNew SqlClient.SqlCommand("UPDATE Org SET Status ='@Status' WHERE AcctCode = '@AcctCode'", Me.cn1) updatestatus.Parameters.AddWithValue("AcctCode", ComboBox1.Text) If Label67.Text = "Active"Then...
  5. E

    Using enter instead of tab.

    I am just wondering if anyone out there knows of a way to switch from using tab to using enter as the button to rotate through the objects on a form. I have a user that is a one-handed keyer and it would be a lot easier for her to use the enter key instead of the tab. Any help would be...
  6. E

    3.0 Framework

    I am sitting here at work and just got the auto update for the new 3.0 framework. Just wondering if anyone has had any trouble with 2.0 applications on the new edition. I am still installing so I will report any issues I find, but please do so yourself.
  7. E

    Passing values problem...

    I have two forms that I am trying to pass values between. I have referenced each form to the other and am able to use objects from the first form on the second and vice versa. The problem is that I am receiving an error message stating "object reference not set to an instance of an object." Can...
  8. E

    Return Values from a DataAdapter

    I have a dataadapter that looks for previous balances within a dataset. Not all parameters defined for the dataadapter will return values. What I am wondering is how do you reference this null value within the object. What I am trying to do is attach a string to the values within the...
  9. E

    Select Case Vs. If Statement

    Does anyone know if one or the other is faster. For example, it takes my program a little long to run through the following If statement. Try IfCDate(receiptdatetxt.Text).Month = 1 AndCDate(receiptdatetxt.Text).Year = 2007 Then ComboBox2.Text = "200701" duedatelabel.Text = "1/22/2007"...
  10. E

    Moving a row from one dataset to another.

    I am currently developing an application that queries an informix database. After I have loaded the dataset with the information I need, I am attempting to pick out a certain row and move it to another dataset in order to set up a binding for a textbox. Only problem is that I receive an error...
  11. E

    Parameter Collection Question

    I am creating an app that has been using mainly SQL server connections. I now am having to connect to an Informix DB using ODBC. My question is why I am getting an error when I my parameters are in the same format that I had been using. I am assuming that I will have to actually create a...
  12. E

    Need help looping through a dataset

    I am developing a form that will be able to add new account information to a database. The ID values auto increment but my account numbers do not because the type of account varies. I have used a dataadapter to fill a dataset with all existing account numbers and am working on looping through...
  13. E

    sum data from a database

    Can anyone provide me an example of loading an object with data from a database and then sum up all the values in that given object?¿ I have been working on this for days and cannot seem to formulate it quite right. Thanks for any help in advance!
  14. E

    parse multiline textbox

    I am using a multiline textbox to receive data from a database and display the values for the user. What I need to do is find a way to execute operations on the values. Is there a way to read each individual value within the cells and assign them to variables?¿ I will include my code though I am...
  15. E

    Having trouble with a masked textbox

    I have an application that uses the datediff of two textboxes. I changed those textboxes to masked textboxes and gave the masked txtbxs the exact same name as the old txtbxs. Now my datediff does not work (is not recognizing the user input or assigning it to my variables). Can anyone tell me...
  16. E

    I am getting a multiple bindings error...

    I am having trouble binding more than one object within a select case statement and do not quite understand why. I have read the post above for a similar problem, but need it explained as it seems to me that Paszt is using an array and I do not understand why. I am trying to bind several labels...
  17. E

    Uploading a dataset

    I have a dataset that accepts decimal values and it set up to send those values to a table in SQL. The columns in which I am sending the data is set up to accept decimals. I have the dataset bound to a datagrid and within the grid it displays decimal values. My problem is that the SQL table is...
  18. E

    Rounding a decimal

    I am having a problem which seems simple, but to a noob like me it is a little bit complicated. I have an application that I transfered from vs.net(2k3) to vb2k5 and as I understand by all the error messages you cannot use decimal.round on an object. I replaced all of those statements with...
  19. E

    Locating a specific row

    I have an application that receives partial payments (on an account) in order for the user to post a payment on that account within a database. It only receives account information from those who have not fully balanced their account. What I am having trouble with is deleting that row, of...
  20. E

    Detecting the close of a form.

    I am writing a multi form application and the first form is designed to let the user select which form they want to work with. When the user selects a certain form a list box is populated with the name of that form(or rather the function of that form). I am researching a way to detect the...
Top Bottom