Search results

Hi, I've been working on trying to get this code to work as expected for days. I'm trying to find duplicates (I can't use primary keys or indexes alone to weed out duplicates due to the structure of the tables involved) in a subform as a user enters data. As soon as a project number is added...

Hi! I was wondering if someone could help me out with this. I have data that needs to have a running sum for it. The two criteria for re-setting the cumulative sum are: 1) LTA value and 2) fiscal year. Essentially, a query or report needs to sum up a data field called "ManHours" until LTA is...

Hi, I am using a custom record counter in an Access (2007) form and this is what the code looks like: Private Sub Form_Current() Dim rst As DAO.Recordset Dim lngCount As Long Set rst = Me.RecordsetClone With rst .MoveFirst .MoveLast lngCount = .RecordCount End With Me.txtRecordCounter = "Record...