Recent content by Bruno

I chabged the names from Início to Inicio and Emissão to Emissao and it works now!!!!! Still think it's bizarre anyway because there is no trouble with "Situação" Sorry for the time you spent I should have thought about that. Tanks DrallocD!

It changes nothing. I also tried to create the records only with the fields that are not dates and they are created ok, just doesn't work with dates!!!! So until now the records are created ok, the DateAdd works but it won't create accept the data in the date fields either because It doesn't...

I tried this: For i = 1 To nRegistos ' Add a new record rst.AddNew xPer = nPer * i newEmDate = DateAdd("m", xPer, EmDate) newStartDate = DateAdd("m", xPer, StartDate) newEndDate = DateAdd("m", xPer, EndDate) newVenDate = DateAdd("m"...

yes I tried to use "m", Also switched this line with the next n the code and the problem switched acordingly. It seems the problem is no the fieldname. Now I tried rst![Data Início] = Now as you suggested and I got error 3265 Item not found in this collection. I first though the problem was...

well, I did the changes you told me and now I'm getting an "object required" in that same line and rst![Data_Início] = <object not found in this collection> It can't be a spelling problem since the Me.Data_Início woks and the form was created from the table (same names). I've chabge all the...

Hi! I'll try to change it back but actually I had it with Dateinterval.Month first. I'll tell you if it fixes it. For the other two, you're certainly right, tanks. I'll use another variable to store the nPer*i and put the rst.Close where it belongs. Thanks again.

ok, when reviewing the post I realised that for example nDoc is doing nothing in there but it shouldn't be a problem anyway. nDoc is for the number of the document (the bill) witch is one of the fields we'll have to insert when we receive the bill. Until then it will remain empty.

I've been looking for the solution for my problem in the forums but could'nt find what I need. I've read some posts where many of you answer that we should not try to store calculated values in tables but... Here what I'm trying to do. I've a table where I store some recurrent billings like...

Hi! Quick introduction... I'm portuguese and currently living near Lisbon (Queluz) but God nows for how long... I grew up in France near Paris. Why I'm telling you that? Because sooner or later you'll notice my english isn't so good... :) Anyway I'll do my best. My education is mainly...