Search results

I was using an OnUpdate Event at another point in design and used the DLookup function to retrieve multiple fields from the same record. It was commented that this might not be the "best way? " to get this information so I thought I would see if there is a more elegant, efficient, green friendly...

Thanks to all of you for your ongoing assistance Here is what I want to do. I have a fairly standard order management hierarchy. Tables: tbl_Customers: Primary Key= ID tbl_Orders: Primary Key = ID Foreign Keys: Customer_ID tbl_DeliveryDetails: Primary Key = ID...

Order_ID is the Child Key that links the tbl_OrderDetails and tbl_Orders. They are the same string type. SubtotalWithTax refers to a text box with the Name SubtotalWithTax it is a calculated field with the Control Source =([RetailPrice]*[Quantity])*((100-[Discount])/100)*(([...

Thanks for your continuing help. I entered the DSum you provided and I get a #Name? in the field. Sorry to keep pestering

It is the ReplicationID option in the AutoNumber field. It generates a random string. I need this to facilitate offline replication of 4 db instances that will run in physically isolated locations.

Sorry Order_ID is a replication ID.... does this make any difference?

In the form Properties I have set the following code on the AfterInsert, AfterUpdate and AfterDelConfirm Events. Private Sub Form_AfterInsert() Forms("frm_NewOrderEntry").Recalc End Sub Private Sub Form_AfterUpdate() Forms("frm_NewOrderEntry").Recalc End Sub Private Sub...

Thanks in advance your your assistance. I am working on a Order Management Database. In this Database I have a form frm_NewOrders that is bound to a table tbl_Orders with the Primary Key Order_ID. I have within that form a subform called frm_NewOrderDetails Subform that is Bound to a table...

Thank you in advance for your assistance. I am a relative Access 2007 Newbie and am having a problem with a form I created. This is a variation on a Order Database. I have a table Products with a field RetailPrice that gets its value from a table BoxStyle from a field BoxStyleRetailPrice in...