Search results

There is a need for it, just what has been requested. So ill go ahead and put that with the vendorparts table and get rid of this side and go from there. With setting up an order form, you mentioned setting up a report first. This is not something im firmilar with in comparison to forms. So...

Okay, so I updated some things and changed what you've said. The only part i'm not understanding is the partdescription, partnumber, and price fields being set in on the table. I have what type of data filled in but should I use the lookup wizard here, set up the relationships? Sorry that part I...

Ha! Yeah thats not supposed to be there. I had that there originally but need to delete it. I wont have either quantity or location within this table anymore. Quantity was moved to part details (because some things come as sets, so its actually quantity per order, not how many we have here) .. ...

Okay so, I see what you mean because the way the we run "inventory" is not a typical way you would think of inventory. Once we get an work order in, we order the equipment for the job and as soon as it comes in it leaves the building so the techs can do the job. So in this case we only care...

In response to jdraw: No problem! Basically we are a security company. We have hundreds of clients and even more projects. The goal right now is to have all of our customers, products (that we have to specially order most of the time), vendors, users, and employees.. etc. We order these parts...

https://www.dropbox.com/s/comwjtrlkcve34y/Capture.JPG?dl=0

Sounds great. So this is what I already had set up. The only link that I am missing is where to get the part information from in the "order details". (well unless you have a better way) Let me know if the link doesnt work. THX

Okay, so once I do that with the look up fields and have them pick from a combo box, would I set the column values to the text boxes through VBA code on the after update event or on click event? Or just make each text boxes control source = column (#) from the combo box. Does that make sense...

Hello, I am having trouble with designing an order form for this database because of the way that the tables are designed. Situation: There are tables "Parts" and "Part details" and "Vendors". I have created 2 one-to-many relationships here, with each Part description having multiple...

Sorry for the late response. I took what you said and applied that here. I'm very new to this so It didnt occur to me that you could do this until you brought it up and I looked into it. Ive separated my "inventory" table into two but have them related so that the user can enter as much...

Actually JK on everything I just said.. I was going to try and do this a little differently but I am no where near at the level where I can do that. So thanks again for the link. I'm going to do that instead of whatever it was I was trying to do haha

Hey! So yes I see what you are saying. However all of this is what is being requested by the company that its being developed for. They would never have more than three vendors (which is something that I thought was odd), but were certain that they wanted to leave it at just three. As far as...

I have a continuous form with my record source as a query. The query has been set up so that the criteria for the field named "Inventory Type" is being defined by a combo box. I have this working just fine by using this in the criteria. [Forms]![Search Inventory]![combotype] OR...

I know this is an extremely delayed reply, but could you post the solution? I am trying to work through this exact issue right now and I cant quite get it to work. Thanks

Hey Colin, Thanks for those links. The layout is exactly what I am looking for. The only small issue with this is that I would like to do everything without a search or filter button. I would like to have the combo box event to be "after update" and the search bar event to be "on change"...

This may sound confusing, however, I will try to make it as clear as possible. I am creating an inventory database system. I have an inventory table made with all of the information we need about each part, including the "type" that it falls under. (the type being "inventory type") There are...

Hi Everyone, I am new to access and currently teaching myself how to create a database for the company that I work for. So far everything has gone terrific and almost everything I've learned has been from this forum or YouTube. You guys are awesome! Now I am at a halt with confusion and...