I need help!
Can anyone help me?
How do I put the current month as the default value in a field of access?
Thank you!
God bless you all!
I need help!
Can anyone help me?
How do I put the current month as the default value in a field of access?
Thank you!
God bless you all!
Hi leandrosarno,
If you're referring to a field in a table, then go to table design and select the field, then add this:
to the Default Value attribute on the General tab (lower left of screen).Code:=Date()
Cheers,
May reason prevail!
I am glad that you answered my question about the code, however, I tried to use it. What I need is a code that returns me the name of the month.
Example: 02/07/2010, ie February.
I need the name of the month to make calculations of accountability.
I appreciate if you can help me.
Hi leandrosarno,
Same area as before, add "mmmm" to the Format.
Cheers,
Just fill in the following into the default value of the field you want in the table definition
Code:=Format(Date(),"mmmm")