Recent content by Jordonjd

@The_Doc_Man Hi there, just a quick fyi. I ran into a similar issue on another form, followed the steps on the link and it worked. Thanks again for the info

Thanks for the advice and the link, I've just a read through. I will give this a try on a copy and see how it goes Thanks!

I just made a copy of the form and everything works fine. Sorry I should have just tried that before posting. I am not sure what was wrong with the original form but this seems to have fixed it, A quick rename and everything is working as it should be.

all of the control names are normal, no strange letters or symbols. The macro event works fine as well but I wanted to change it to vba, only once I change it does it go wrong

Afternoon everyone, I have a button on a form with a macro to open another form. This works fine. I want to change this to vba, so i open the macro, delete it and save, remove macro event and add the vba.. when i save the form and click the button it pops up with the following: Once this...

ahhh i see, i completely forgot about that, i was losing my hair over the error message about needing related records in PO_ID table. well again, thank you both very much, i will have another try tomorrow

That is very helpful, I think I am going to call it a night, sketch it out again tomorrow and have a fresh look at it before I move forward. Thankyou both for the advice and your patience!

I just realised this is in the Query thread and I have moved into another set of questions really. I can start fresh tomorrow and post new threads in their relevant threads etc

Thanks both for your replies, I was thinking of a inventory "in" transactions table and an inventory "out" transactions table as opposed to having both in the same table, I am not entirely sure why now, but that was what i was thinking. For a transactions table, storing +5 of x and -10 of y...

Afternoon, There is now smoke coming out of my ears, I am completely second guessing everything now, could someone please advise as to whether the structure of these inventory_in tables makes any sense? whether the ID fields are ok and whether two tables is a good idea.. my brain is fried and...

Yep that's the plan, but I was hoping the display and each order line at the same time in a datasheet style subform, which is why the unbound text box isn't suitable (unless I'm wrong about that). Anyway, I'll build a few drafts tomorrow and see how it goes, at least if I have any more...

Ah ok I think I see what you mean. I will have a try tomorrow and see what I can do. Thanks very much! Would you have any advice for the record source of the 'qty in' field? it can't be an unbound text field, so I wasn't sure whether to use the genuine field from the related "qty in" table I...

I see what you mean, but when you use your receive partial, does it not display an outstanding qty if someone has already partially received against it? The restriction on the extra qty is so the po can be amended by another user before the extra units are receipted.

I put a dsum and calculated text field in, the Qty_in unbound text field doesnt work, but maybe i could just make a field in the table that i clear once i've used it to append the qty in transaction.. or something along those lines. anyway i will have more of a rummage through it all on monday

Hi, the process would be to select the po and only receive against that po/order, if there were multiple deliveries they would be processed separately. Im not 100% sure what you mean on the listbox approach, I did think about a dlookup textbox but i wasnt sure how that would work on a...