Search results

I still haven't figured this out. How do I create a combo box on a form that will allow me to make multiple selections from the available containers?:banghead:

I understand. I will now see if I can figure this form out. Thank you!

Do I make a "drop down" from a text box? It seems the only options are "combo box" "list box" . . . . "text box"?

That did it! Now I have to figure out how to use these queries in a form . . .

I changed the name of the query to Q_Unavailable_Items. It works fine. I saved the available lids query as Q_Available_Lids. It also works fine. The available totes query pulling wrong information and I can't figure out why. The totes that are NOT available are 27 and 1. But they show up as...

it's just like attaching a jpg . . . here you go.

Yes, I may, but how do I do that?

I'm getting this message "Join expression not supported". I am creating this query as a "data definition" type in query design.

I am trying to create the query. And this is the error message I got. I assume I'm creating a text box in the form and then use this query as the control source?

I did watch the video and I use the information in it to create lists (as described in the video) which takes containers(totes) out of inventory on one list and puts them back in in the other list. What I don't know how to do is create a form (or some tool) which our warehouse can use to make...

Any help would be appreciated. I need to be able to have an employee enter info on a form to include the employee name, customer, and where I'm stuck is how do they enter the containers and lids that are being picked up? A sub form? (I've added an "Active? Y/N" field, and also a "Condition"...

Thank you both. I will take this information and do further exploration. You both have given me some direction. I may, however, be back with a question(s) . . . Thanks again!

Now the question - how do I make this work? Shall I enter all the containers and lids we have into the T_Containers table (or two tables if you think I should have both container and lid tables) - to create a list of specific inventory items to choose from when an employee enters/selects the...

We sell non-(human)edible food waste to local farmers for their livestock. We load it in containers which are numbered, and top with a lid which is numbered. They may load into container(s) #3, #2, #15, and top with lid #3, #8, #7. We want to know which containers were used to each customer...

I didn't know if I should have containers separate from lids. I included both of them in the container table, entering them in the item field as (for example) Container_01, Container_02, Lid_01, etc. Shall I make a separate table for them?

Here's what I came up with. I was unsure of what to do with the containers at the table level. (This is a .bmp screen shot of the relationships, with table fields shown - I used the "manage attachments" button below and the image was shown as uploaded, I hope it worked.)

Hello. I'm stuck on how to accomplish this. We have material that we're selling by the container. The material is loaded into a labeled "container" and labeled "lid". We want to know which container and which lid is shipping to which customer. The customer then returns the container and lid and...

Thank you both. I will not use the PK Auto Number as an invoice number. I will now reevaulate the creation of invoice numbers. Thanks again.

I have a table with an auto number PK. This table will contain orders. I'd like to use the PK from this table as the Invoice number on the invoice. I'd like to have it start at a number other than "1" just because it looks better on an invoice. I don't know how to do this. I looked at the table...

I will check out the information in this link and proceed from there. Thank you kindly.