Recent content by siddhusingh1968

This is the code I have been using. '========================= Dim db As DAO.Database Dim rst As DAO.Recordset Set rst = Me.RecordsetClone Dim PREVDATE As String ' will hold value of end date from previous record in this variable If rst.RecordCount <> 0 Then End If rst.MoveFirst 'moves cursor...

I have this code to sequence dates in an Access db. It grabs the end date of the first record and pastes it into the start date of the next record and so forth. I need to modify this code to sequence the dates from the current record i.e. where the cursor is instead of going to the first...

Thx Jeanette. I have used the default property where I wanted to carry previous record values to a New Record and hence am not using the default property. Here's the background on the app.. No new records will be generated for this exercise. I have a planning database where an algorithm...

I agree Bob, that is redundant. Specially in this particular scenario the recordset is never going to be null. It is a planning database and always has Backlog. The Backlog may be low, but there are always records there, worse case 9-10 records, never 0. I do need the loop to start at the...

Re: No Current Record Error - move end date from prev rec to start dt of next Guys I got this figured out for the benefit of others. If someone is trying to look for a loop that will hold a value of an end date from previous record and update the start date of the next record (using Access for...

You are right, Paul, appreciate the quick response. However if I move the .movenext to right before the Loop as is normally done then the routine will not copy the previous record's end date to the start of the next record. It will then just copy the end date to the start date of the same...

Move date value from previous record - works - no record error I am a new member (Joined today!!). I have a database that has a basic MS Project structure i.e. for each task Plan_Start, Plan_End, Duration. When assigned to members the tasks are sequential, Plan_End is calculated based on adding...