Search results

As for the craziest one, I seem to member someone suing for a cracked tooth because of peanut (or something) in an M&M. Not sure it ever went anywhere as that was around the time I gave up on televised news. Hmm, I remember that hot coffee one but IMHO it was taken out of context. It was the...

Hmm, wonder why she stopped ISO 9001 compliance is a *real* issue.

ISO 9001 (was ISO 9000) but, you know, new standards) EDIT: Missed a zero!

Still doing today - Internal Auditor (ISO) A lot of paper work, which is not my strong suit, but I do find it interesting.

Hmm, you need to create a subreport with the Recordsource of the Listbox and set it to Can Grow to see the items from you Form's Listbox o the Report.

I use... https://www.access-diva.com/d1.html Since I use use Model Databases with existing Forms not much to do should I add a new control to any one of the Forms. I even names Forms of the like the dame, i.e. frmFilter*** will always be the Form that opens to filter reports by. Naming Forms...

Hmm, missed that. First thing that comes to mind is Start Time and End Time to be added to the table. Only need to fill in if less than a day.

I think we need to adjust the tables first. tblLeave should have a Start Date and End Date with the calculation of days out on leave in a query. If you are looking to exclude Holidays you will need a tblHolidays with the a list of the Holidays *given*. There are also funstions out there for...

Welcome to the Forum! Hmm, perhaps you could us a little background? Like, have you set up any tables yet? How familiar are you with Access?

Hmm, do you have a Set Focus anywhere behind that Form? Also, you did put it in the KeyUp event not the OnChange event right? The code I provided will fail in the OnChange event. EDIT: Stepping away for a bit, dinner and a movie. Will check for replies when I return.

Did you completely remove the On_Change event? You cannot Set Focus to the Control.

Hmm, give this a try. In the KeyUp event procedure of the Combo Box (might need some tweaking)... If Len(Me.Combo0.Text) >= 2 Then 'Set the row source to match user search criteria Me.Combo0.RowSource = "SELECT taglio.[num taglio], taglio.[cod modello], taglio.Quantita...

I took a peek.

You are updating (subtracting) the parts the tblMainItemParts table from tblInventory. Though in your case you might be adding to your Transaction table to be subtracted from tblInventory. Can't say for sure how you add\subtract parts from your tblInventory without seeing it. You need to do...

Not individual tables for each item, so... tblMainItem - wagon tblMainItemParts - linked to tblMainItem includes all the parts and there quantities linked from the inventory table. Then on the BOM you would use the ID from tblMainItem and run a query to UPDATE the Inventory table.

Do you have a tables that hold the four items and the parts they need?

Wouldn't the completed item go on the BOL? Oh, I see @arnelgp has posted a document. See if that helps as I would not be assembling the finished goods on the BOL that is where the completed item gets shipped.

What new data? If it's a simple look-up from the drop down why aren't you showing it in the combo box instead of the ID? Or you could just show the specific column from your combo box in the text control. What am I missing?

Ah, glad to know you are not starting from scratch. Well, not sure this will work for you but this is what I do. In the Inventory table there are two additional fields: iBillOfLadingID and iStatusID (it's shipping status). When the inventory items gets added to the Bill of Lading but has not...

Welcome to the Forum! Hmm, You're new to Access and you are developing a small database for inventory, bill of materials, work order, purchase orders with all the other pieces and parts necessary AND you want suggestions. How new are you? This is relatively a hard business model for your...