Search results

Ok, as for what im doing.. The combo/textboxes are for data entry. On the Form I've been using the New Record button and entering the data in the combo/textboxes. I have all that working the way I want it to.. But say I wanted to edit a certain record. I think it would be easier to be able to...

Endless amounts of praise. Thank you very much... that's prettymuch exactly what I was looking for. Just one problem on that, it works for most every ComboBox that I have except one. The Count field on the ListBox. When I write the code out I get the Data Type Mismatch error. I suspected it...

*Bump* Anyone?

Any help would be appreciated.

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...

Alright, the check box didn't have a check, so I fixed that. But now i get a different error. When I click on a record, a window pops up that says "Run-Time Error '3464': Data type mismatch in criteria expression" with buttons that say "End" and "Debug". When I click on Debug, it points to...

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...

Alright.. All of my issues with this project are fixed (so far), except one. Why when I click on any record in the ListBox, it brings up an error? Well, I guess I know why.. But the problem I have is.. When I click on a record, I'd like the information that is in the ListBox populate into it's...

Hmm.. I thought I tried that before, but couldn't get it to work. Either way, it's working now. Thanks

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...

Yeah, exactly. Except why when I open the form, in the listbox there is an occurence of each jobID 4 times and each color displayed? Other than that, it's what I was looking for. Thank you.

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...

Distressing, when talking about wood working, is when you pretty much beat up the wood in a fasion to where it looks like an old or antique piece. There are different styles and names for each type of distress, and it would be nice to be able to store that type of information along with each...

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...

Actually that is a near perfect example of what i want, of course with a little bit of tweaking. But I can't seem to get either the TextBox or the ListBox to work properly. The coding is pretty much the same as in the example you provided.. but it still doesn't work. I have a feeling that...

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...