Recent content by MaxMiller

Here's what I did: Private Sub Item_BeforeUpdate(Cancel As Integer) If Me.Line.Value = 0 Then 'Do Nothing If IsNull(DMax("[Line]", "Detail", "[Reference] = '" & Me.Reference & "'")) = True Then Me.Line.Value = 1 Else Me.Line = DMax("[Line]", "Detail"...

I need to digest this over the weekend. Let me see what I can come up with. Thanks for the help CJ!

CJ, if I go with this implementation: Line InputDate Item Quantity 1 1/1/2013 Buttons 10pcs 1 1/2/2013 Buttons 20pcs 2 1/1/2013 Laces 5pcs 2 1/2/2103 Flaps 2pcs Is there a way where I can show the changes made in a side by side view?

Thanks again CJ! The side by side views just makes it easier to spot the changes in the customer's order. What I'm thinking with the side by side view is that the left side is the initial order details. On the right would be a drop down list of revisions. Let's say the customer revised the...

Hi everyone! Hope you can help me with this. I have a field called Line in the Orders table that I use as a reference for changes made to a customer order. I need this field to generate an AutoNumber sequence starting from 1 up to the number of lines (orders) the customer has. Then when I...

Thanks pr2-eugin! I'll do just that. :)

Thanks CJ! You answered one of my other table requirement which is an audit table. Here's a quick overview of what I need: Header Table ProjectID CustomerName ContactDetails ProjectDetails BOM Table ProjectID (Linked to Header table) Line (An autonumber field to give me a reference for each...

@ John Big Booty, is there a way to reset the autonumber back to zero? I will use the autonumber to identify individual item orders of a customer. When I move to the next customer, I want it to reset back to zero. Thank you.

I'm doing a database that tracks customer projects and orders. The Header table contains all the Customer and Project details like customer name, contact details, project leader, etc. A second table BOM contains the customer orders for a particular project. I need a way to track changes or...