Recent content by PotatoDave

I have a table that holds details of all provisional and actual orders. I need to then do a nunber of things with this data: 1) a percentage accuracy of the provisional vs Actual order (which I think I have done) 2) Create a production figure based on the provisional order and the accuracy of...

Thanks Using the tips you gave i found that the following code works: Private Sub Form_AfterInsert() Dim prodq As DAO.Recordset Dim db As Database Dim LSQL As String Set db = CurrentDb() Set prodq = db.OpenRecordset("ActiveProd", dbOpenDynaset) If prodq.RecordCount > 0 Then...

I am trying to add a form where a data sheet is used to add rows to a table. I want the full data in the table to be made up a combination of the combo boxes on the main form, and then also from the datasheet. The situation is for entering orders into the datasheet, the depot, date, order type...

We have 2 mail servers looking after 2 domains. The Users on each appear in the GAL for each company as custom recipients. If we add a user on server2 custom recipient to a Distribution List on server1, when the message reaches server2 it is rejected as it doesn't have the smtp address of the...