Search results

Something weard happens... Variable "Field" gets a Null value because there are no records for the year specified. So I introduce a new field to calculate the new sequence. Dim NewField as Integer If Field = Null then NewField = 0 Else NewField = Field NewField = NewField + 1 However the...

Thanx Roku, this does the trick. :-)

I have a data entry form to add new records to an Access database file called Claims. An auto-incrementing sequence number (SeqNbr) needs to be kept PER YEAR. If the user enters a date the sequence number pertaining to the year of this date needs to be incremented. The first record within a new...

Dear forum users, My name is Dirk Van Giel, I live in Flanders, the northern region of Belgium where we speak flemish, a language similar to Dutch. My professional carreer as a software developer started in 1981. I have been working on S/38, AS/400 and iSeries machines for 29 consecutive years...