Thearon,

Yes. Here are the queries I am using:

usp_DeleteLease

DELETE *
FROM Leases
WHERE LeaseID = @LeaseID;


usp_InsertLease

INSERT INTO Leases ( LeaseID, Branch, Due-
Date, StartDate, EndDate, BranchID, LandlordID)
VALUES (@LeaseID, @Branch, @DueDate, @
StartDate, @EndDate, @BranchID, @LandlordID);


usp_UpdateLease

UPDATE Leases SET Branch = @Branch, Due-
Date = @DueDate, StartDate=@StartDate, End-
Date = @EndDate, BranchID = @BranchID,
LandlordID = @LandlordID
WHERE LeaseID = LeaseID;


usp_InsertBranch

INSERT INTO Branches ( BranchID, brName )
VALUES (@BranchID, @brName);

I'm able to insert, update, and delete data using text boxes. Here is some code from the update routine:

                objData.SQL = "usp_UpdateLease"
                    'Initialize the Command object
                    objData.InitializeCommand()

                    'Add Lease primary key
                    objData.AddParameter("@LeaseID", _
                       OleDb.OleDbType.Guid, 16, New Guid(txtUserID.Text))

                    objData.AddParameter("@Branch", _
                                            OleDb.OleDbType.VarChar, 50, txtLogin.Text)
                    objData.AddParameter("@DueDate", _
                       OleDb.OleDbType.VarChar, 10, txtFirstName.Text)
                    objData.AddParameter("@StartDate", _
                        OleDb.OleDbType.VarChar, 10, txtEmail.Text)
                    objData.AddParameter("@EndDate", _
                        OleDb.OleDbType.VarChar, 10, txtPassword.Text)

Mark

Mark,

You parameters are odd. Are you really trying to set a due date using the first name of a user? Anyway, try this; ensure that the parameters are added in the same order in your code as they are specified in your query.

Thearon

Thearon,

After changing the code so that it is in the same order as the parameters, the value from the Branches combo box does pass to the Leases table.

There are two combo boxes used in the UpdateLeases procedure: Branches and Landlords. I also tested the Landlords combo box. This combo box also functions properly -- the correct value does pass to the Leases table.

Here's the code for the Landlords combo box:

                    objData.AddParameter("@LandlordID", _
                       OleDb.OleDbType.Guid, 16, cboUserRole.SelectedItem.item("LandlordID"))

An error occurs with the value displayed in the combo boxes. After a lease item is clicked, the value in both combo boxes does not reflect the value in the Leases table.

An error occurs after resetting the selected index of the Landlords combo box (still in the UpdateLeases procedure).

After the following line of code to reset the Landlords combo box (cboUserRole) is executed, the value of "cboUserRole.SelectedItem.item("LandlordID")" no longer reads "{System.Guid}":

cboUserRole.SelectedIndex = -1

The value of "cboUserRole.SelectedItem.item("LandlordID")" changes to:

cboUserRole.SelectedItem.item("LandlordID") Run-time exception thrown : System.NullReferenceException - Object variable or With block variable not set.

Here's the code used to reset both combo boxes:

                'Clear ComboBoxes
                    'Reset the selected index
                    cboUserGroup.SelectedIndex = -1
                    cboUserRole.SelectedIndex = -1

The value of the Branches combo box (" cboUserGroup.SelectedItem.item("BranchID")") remained "{System.Guid}" after the selected index of the Branches combo box was reset.

The answer to your question about using the first name of a user is no. I haven't had a chance to change the name of the text box controls yet.

Mark

Thank you for your help.