Search results

I can't imagine why I hadn't seen that! Thank you! It is now fixed. And, I appreciate the indexing idea. I will definitely look into that.

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...

I can only sort my data by Month and Year (field called "MonthYr"). If I sort by LTA, the data will be sequenced incorrectly. What I ended up doing is using VBA in a report to produce the running sums that I needed (I had to create three different running sums in all which is why the...

I did try that but didn't get the results I was looking for as the report would separate out the LTA data completely from the year data. That wasn't what I needed. I needed the data to be grouped by year and the sums needed to add up until an LTA value was greater than zero (the data would...

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...