Fremskrivning af dato

you can use the dateAdd function

= DateAdd(\"d\", 30, [dato])
you should also look in help for further parameters

In this example 30 days were added, it could just have well have been -30

the \"d\" is for days

Others are>

yyyy    Year
q    Quarter
m    Month
y    Day of year
d    Day
w    Weekday
ww    Week
h    Hour
n    Minute
s    Second

If you are trying to do this when creating a new record then you cant!

The record doesnt exist until all fields are entered, so [dato] is not known!

Kunne det være navnet \"Dato\", Access falder over?

Hvis du kalder feltet f.eks. \"D\", burde du kunne sætte \"Fremskreven dato\" til \"=[D]+10\". (Det virker her)

If you do it in  a form then you can do it in code. In the forms before insert then you could use the dateAdd as mentioned

Tak, men jeg får flg. besked når tabellen arkiveres:
\"Databasemotoren genkender hverken feltet \"Dato\" i valideringsudtrykket eller standardvædien i tabellen \"Tabel 1\".

Jeg har skrevet linien i \"Standardværdilinien\", men det er måske ikke der den skal stå..?

Yes! as I mentioned in the comment 17:32 you cant use the Standardværdilinien for exactly this reason!

Rigth, get your point.
But 17:34 you say I can do it in a form.
Could you give me a hint on how to work with that..?

Well you can use the form wizard to create a form using the table where your dates are.  There should then be at least two fields on the form, one being dat and the other being \"Fremskreven
Dato\"
Right click on the dato field and then choose properties (This is in the english version)
Then select the events tab and then select the after update event. When you do this you will notice little button to th eright of the field. Press this button and then select code builder form the window which appears.

You should then see code which looks like this

Private Sub Dato_AfterUpdate()

End Sub

Add this to the code

me.Fremskreven_dato = DateAdd(\"d\", 30, me.dato)

It should now like like this

Private Sub Dato_AfterUpdate()

me.Fremskreven_dato = DateAdd(\"d\", 30, me.dato)


End Sub

NOTE: Although the field name is Fremskreven dato I think Access will change it to Fremskreven_dato when you start adding the code.

You should try to refrain from using names such as Fremskreven dato. Use FremskrevenDato instead.

Thanks mate!
I can see that points is what you get out of this.., then one last question... How do I add you another 100...?

well thank you very much!

you create a new question, refering to this to keep everyone happy, and then wait until I answer it.

mvh
Terry