Recent content by Gladis

Hi arnelgp, Thanks for the help So far. I am able to use this for the most part. I am running into issues here and there. Allocation is still not functioning 100% . For example. Item Number 1570C898. when I enter it in Item number field and click Update data. it calculates the correct...

Hi arnelgp, sorry for reopening an old post. I ran into a problem today. didn't make any changes to your script. everything was working fine until. I added more Item no to the Item Number table. when I don't enter Item no, Processorder 2 script is getting stuck on code bellow. funny...

Thanks for your Help Really appreciate it

hi arnelgp, attached my current data base. Eta look up is working fine. running ProcessOrder2 takes a bit of time. I need to run it quite a bit to get live data. Example: Customer places an order and calling us with in like 30min for eta. it happens a lot and I can't see the order without...

Correct, I am trying to reduce the number of data from the Output2 table. I have close to 15000 Item numbers and 10,000 orders to be able to lookup eta. that table with all the item number getting too big. trying to see if I can filter beforehand.

how would I go about passing the combo box parameters to recordset in your code? Tried this code "where a.[item.id] = '" & [Forms]![frm_Eta]![tbx_itemid] & "' " & _ and I am getting error. Set r_in = db.OpenRecordset( _ "select a.*, b.id from outbound as a " & _...

Thanks for the help arnelgp

Thanks arnelgp really appreciate it. it working perfectly. I tried to do some tweaks and ran into a wall. I want to use a control form to look up by Item id or Order Date, or Order ID. see frm_Eta. running Query on Output2 table, but worried when I try to process more data this way I might...

sorry for the Late reply arnelgp Yes, I did, this is what I am seeing. Different Items numbers are added on running total. also how would i go about looking at ETA for just 1 Item number ? Ex: 1570C945 thanks

Hi arnelgp, Thanks for the prompted reply. still not working as I expected. maybe I didn't explain it properly my bad sorry. I need running total separate for each item. for example 1570C945 15 15 1570C945 10 25 1570C941 1 1 1570C941 1 2 1570C941 1 3 match each Item separately to the...

Hi, Posting here for the first time. I wasn't able to locate what I was looking for. I have 2 tables Inbound table: Inbound Item from Manufacture Outbound table: Orders from customer. I need to be able to provide customers with expected fill dates based on their order type and order date...