Search results

Ok, I have a Form with a ListBox and a number of ComboBoxes that contain information that is displayed in the ListBox. I use the ComboBoxes to enter information into the ListBox. But I would like to be able to click on a record in the ListBox and have the ComboBoxes auto-fill with the data in...

Can anyone tell me how to clear up the error I get when i click on any record in the ListBox? The reason the code is like it is, is because I was following an example database. When you click on a record, it is supposed to populate the corresponding ComboBox with the data, but with the way i...

Ok, when I open my Form, the ListBox displays each JobID four times because of the Color field. It's not supposed to do that. There are four colors in the tblColor that are possible, but the ones chosen for each job are stored in tblPricing. When I change the Row Source code to either...

Ok, I have my Form working the way I want for the most part. But if I wanted to add to the ListBox a field from the Color table, how would I do that?

Ok, I have my Form all set up and working how i want it to, for the most part. I have a table called tblJobs, and that is where the ListBox (lbDisplay) on my Form gets the information from. So my ListBox is displaying four fields from tblJobs: JobID, CustomerID, InvoiceID, and [Piece Done]...

Ok.. (First off, my Form is using this Search method http://access-programmers.co.uk/forums/showthread.php?t=65331) On my Form there is a listbox with 4 different fields: JobID, CustomerID, InvoiceID, and Piece Done (Referring to piece of furniture) And each field takes information from the...

Say I wanted to make a database for a furniture finishing company. One of the tables/sections has to do with doors. I will be storing information about the doors such as color, distress, hours they took to finish, cost to the company, and cost to the customer. For the Doors table, would i...

Ok, on my form i have a ListBox that displays all the data in the table called Beams. The Beams Table contains fields named IDNum, Color, Length of Job, Cost, Cost Charged and Count. I want to be able to enter a color name (Ex. Burnt Umber) into a TextBox and have it list all the records where...