[RESOLVED] recorset

[Dbee]

In the design view in access the Month_Num,Year_Num are Long Integers and required is set to NO.

I was using the routine to obtain all of the entry's for the month and day of the year they were put into the database first time was for the month of September and when it went though for Oct it loop twice for some reason. I put the First_time in the loop to stop that.

I thought that recordset count might have added to its self but found it did not.
But it still looped on me twice. I ran debug on this.

Let me add this I am putting all the data in a MSHFlexgrid By cell and row. as it comes from the data base using the SQl call. Found it is a time saver.

You got to remember I am self taught as a programmer still in the learning stage at 65 use to the old ways of programming in DOS.

I still use the random method of file data. Don't grasp the database concept any other way as of now.