Recent content by jt196

Thanks very much for all your help! I put in =DMin("[Due Date]", "Q_OrdersFinSumNoInvoice", ) To text box and it worked.

Thanks for your reply, Trevor - I need to display this on a form. How exactly do I go about doing this then? I put a text box with the line: "=[Q_OrdersFinSumNoInvoice]![Due Date]" where the first bit is the query and due date is the date I want - but I just get an error message. Sorry - a...

Hopefully this is just a simple one. I have a bunch of records (orders) with dates on them that show up in a query. I'd like to display the earliest date on a form - ie the date the longest amount of time ago. I imagine that this is some sort of text box with some type of sorting, but I've...

Yeah turns out it was a LinkChildFields/LinkMasterFields issue. I remembered that I had a backup somewhere and went over the forms with a fine toothcomb (when you're learning sometimes you forget the things that you'd spent ages getting right with a bit of trial and error) Anyway, the subform...

Hmm thanks for advice along the way - actually during redesign I've managed to change the delivery note form (should have been working with a dummy database, but dummy me, I wasn't) and it has mucked things up for me a little. Before, the delivery notes form had a subform that entered an item...

Bill - again, I really you owe you a few beers when I finally get to PNG... Thought I'd cracked this program but looks like I need to sit down and digest some of that info. I'll refrain from writing the proper reply for a couple of days once I've had some time to think about it all and have a...

OK so my setup at the moment is that I have three tables to manage the first two of the above. T_Orders T_DeliveryNotes T_Transactions An order goes on T_Orders, and its items go on T_Transactions (with a figure against Quantity_ordered). A delivery note is raised and the items go on the...

Aaah VBA - yeah I'm not even close to understanding that yet, it was more like a bunch of cutting, pasting and trial and error - but I'm probably going to get started on the chapter this afternoon... As for combo boxes, I felt that they were a necessity as we have a finite register of...

Phew! Thanks a lot for all that help, Bill. Even though you're on the other side of the earth, I feel like some good mentoring has gone on here and your advice has helped me endlessly to get there. So thanks for this and if I'm ever in PNG I'll buy you a beer. I'm pretty much at the end of the...

Got it with the combo box/query selection! That makes things a hell of a lot easier now. Thanks for that! I'm getting there... Perhaps I didn't explain the autoupdating fields properly. Let me give you an example: There are 3 companies: Company A Company B Company C And 5 Products: Product...

Bill - you're a legend! Thanks for the help here. Looks like we're working at opposite ends of the clock - wait a minute, is it 7am Friday or Thursday there??? Ha ha. Well I think I've got this sussed out here. There is a single table for all of the incoming orders and outgoing items. Each...

OK Bill - I've managed to get this system up and running. A couple of pointers as to things I had to do (that were a bit beyond my knowledge and have taken me since my last post to figure out). In response to my questions: Yes! Yes! I've set up a query that totals the 'transaction' items...

OK so a few questions here to clear up what you getting at here. So you're saying to have single TblTrans to contain BOTH the delivery note and order details? Does that mean that the extra fields for deliveries (eg driver, delivery quantity etc) will just end up being blank if it's an order...

Firstly, I'd like to say that this is my first post on the forum - it seems like a great community - so a big hello to all people on here, and a big thank you in advance. I'm also a newcomer to access, so please treat me with kid gloves and assume that I'm not an expert in the level of detail...