Thanks for the quick response JohnH.
Here's what I have so far:
Dim daAccess As New OleDbDataAdapter()
Dim dtBeginDate As Date = Today().Date.AddYears(-1)
Dim SQL_RecentWorkOrders As String = "SELECT workorders.CustID as WO_CustID, " +...
I saw another post where jmcilhinney graciously helped another programmer with fixing a coding issue and suggested using parameters. The link to his blog in his post was very helpful and I'm trying to change my code in to use parameters instead of the previous method. In my previous method, I...
Thanks for the reply and the tip regarding best practices.
I am still getting the following error:
"Complex DataBinding accepts as a data source either an IList or an IListSource"
Here is my current code now:
FilterColumns.DisplayMember = "ColumnName"...
I'm trying to setup a form to search for data within an existing DataTable. Please help me fill in the blanks below:
FilterColumnsComboBox.DataSource = WOTable.Columns?
FilterColumnsComboBox.DisplayMember = ???
FilterColumnsComboBox.ValueMember = ???
I could hard-code in the column names...
Thanks for the advice. I also wonder.. would it be better practice to pull in the two tables seperately into the dataset then setup a reference within the dataset? Is that very difficult?
My original query for data from the database was:
Dim SQL_RecentWorkOrders As String =
"Select * from workorder WHERE date>#"
+ "# ORDER BY worknum DESC"
The updated query is as follows:
Dim SQL_RecentWorkOrders As...
I have an Access database I have to retrieve Work Order information from. I have a ComboBox to list the work order numbers and various text boxes to show the data for the selected row of data based on the data shown in the ComboBox. I want the user to be able to be able to select the number...