Search results

The only problem with a list box is that over time, I could end up with 100's of tools, and to have to scroll throw them and select each one could become a problem. The items I have in the database right now are just junk filler pieces to have something to fill the tables to test searches with.

well, maybe not that bad, since the drop down boxes only bring back values that are in that column.

The way I had it set up before, was that you'd have to know what column you put the tool in to know where to put it to search. That would completely suck and you'd never get any results.

Yes, up to 8 tool combo boxes to select as search criteria.

What I'm trying to say, is have multiple combo boxes to select different Tool #'s from, and then look in each of the Outside/Inside Tool # fields to see if that tool is used in any of them, and if it is, results are returned.

As I look at that function you just made for the search to look for a specific tool # in any of the columns, I wonder if that shouldn't be the way it does it in the first place. That way could look up multiple tool #'s no matter what Outside/Inside Tool # place they were in. Does that make sense?

Is this the only thing I would really need to add to create that check box search feature? Private Sub chkSearch_AfterUpdate() If Me.chkSearch = -1 Then Me.cmbOutsideNo2.Enabled = False Me.cmbOutsideNo3.Enabled = False Me.cmbInsideNo1.Enabled = False...

The other search I'm looking at, is one using the "Individual Tool Information" subform in "Tooling Information". I'm not sure how to set that up since it has a different record source. Do I need to create a different search form? Because Ideally I'd like it to open in the same type of form...

Thanks. Appreciate that.

Yes, exactly. Preferrably on the same form as the one I've created.

One other thing I've noticed I may want is a search function on the form to give me all the records of drawings that use a particular tool no matter what place it is on the form. If you notice I have 3 outside profile areas and 5 inside profile areas. As I think about it, that could be...

The both of you were a great help. You both got me farther then I could have imagined so quickly. I did notice one thing as I've tested my database a bit. On the "Drawing Search" form. The "# of Passes" criteria doesn't return the correct results, it always gives every record as a result...

yeah, I think so. When I first started here, told people what I was going to be doing. Basically getting all their CAD drawings to more professional looking set of standards and creating a database of all the drawings and tooling needed to create our product line. When I would tell them I was...

I'm a CAD Drafter for a manufacturing company. Just started here about 2 months ago. Moved to allow my 1 1/2 year old daughter be close to both sets of grandparents. Again, thanks for all your help. Hope I wasn't too bothersome.

KeithG... Oh ok, got it working. I swore it had to be simple to fix and it was. Thanks again. So I guessing you're a database administrator, or how do you know so much about Access?

Which form?

KeithG... Here I thought I had learned something and could do another search form on my own with all the help you gave me. I swear I did everything you showed me, but for some reason, when you hit the "search" button on the new form (Drawing Search), it opens the Drawing Information form, but...

Well, just want an easy to use interface that people would just click on to open a particular function, i.e. add a new record, view all records, search records. That way they don't see the tables in database window, etc. Ultimately, would like the database file itself read only and password...

Ok, next question I have is switchboard related. I've created a switchboard with the appropriate links I want on it. In design view there are extra lines that I don't need created by the wizard, but I can't delete them without a bug issue coming up. Any ideas? And why can't this be edited in...

Well, was totally discouraged until you started helping me out. I guess I thought it was going to be much easier then it turned out to be to create what I wanted. I've come to think of Access now as a sado-masochist type of thing, and enjoy it a bit now, if that isn't scary. I mean, banging...