I'm modifying the Access version of the Time Tracker app. and I need some help with a ComboBox. I wrote the following code based on page 175:

'Passing the value in the ComboBox to a field
                    objData.AddParameter("@BranchID", _
                     OleDb.OleDbType.Guid, 16, cboUserGroup.SelectedItem.item("BranchID"))

Instead of passing the value in the ComboBox to the appropriate table, it generates a new GUID. How do I modify it so that the values passes to the table?

I made the modification based on the following code on page 484:

MyBase.AddParameter("@RoleID", _
SqlDbType.UniqueIdentifier, 16, _
User.Tables("User").Rows(0).Item("RoleID"))

Any help would be greatly appreciated.

Thanks,
Mark

Mark,

Does the BranchID in the combo box contain a GUID or just a string formatted as a GUID? If the value is just a string formatted as a GUID you can try this: objData.AddParameter("@BranchID", OleDb.OleDbType.Guid, 16, New Guid(cboUserGroup.SelectedItem.item("BranchID")))

Thearon

Thearon,

The BranchID in the combo box does contain a GUID. Both the source and destination fields are "Number (Replication ID)" type.

Mark

Mark,

What error are you getting when using the code I suggested?

Thearon

Thearon,

The error message reads:

Overload resolution failed because no accessible 'New' can be called without a narrowing conversion:

'Public Sub New(g As String)': Argument matching parameter 'g' narrows from 'System.Object' to 'String'.

'Public Sub New(b() As Byte)': Argument matching parameter 'b' narrows from 'System.Object' to '1-dimensional
array of Byte'.

Mark

Mark,

Can you set a break point on the line of code in question, post the one line of code, and post the value from BranchID?

Thearon

Thearon

The value of "BranchID" in a Watch window reads:
Name 'BranchID' is not declared.

Mark

Mark,

In the Watch window you need to add a watch for cboUserGroup.SelectedItem.item("BranchID"). Do that and tell me what the value reads.

Thearon

Thearon

The value reads "empty".

Mark

Mark,

That's a problem. It sounds like your query is not pulling back data for BranchID. Is that column selected in your query?

Thearon