Problem in printing current month

[arunakumari02]

#Name error in the Report

I am a begginer using MS-Access.

I trying to create a report which display the current month in the report.

Could you please check the attachement.

 

[dkinley]

You could use to display the month ...

=Month(Now())

However since you say you are a beginner, I would suggest the following links to get you past the smaller hurdles in learning Access. Great tutorials and examples to get through the basic learning curve.

http://www.techonthenet.com/access/index.php

http://www.sienaheights.edu/personal/csstrain/Access2007.htm

http://www.functionx.com/vbaccess/


Also, please do not double post.

-dK

 

[arunakumari02]

When I used that it is printing Jan instead of Aug.

Any help

 

[georgedwilkinson]

Then the clock on your PC is wrong.

 

[arunakumari02]

Could you please check the sample attachment I posted and recommend me a solution.

 

[dkinley]

I did ..

I recommended code and 3 links that has tons of great information that is organized and clearly laid out.

-dK

 

[MSAccessRookie]

Re: #Name error in the Report

I am a begginer using MS-Access.

I trying to create a report which display the current month in the report.

Could you please check the attachement.

I noticed right away that your textbox was controlled by an undefined function =FirstDayOfMonth() (I did verify that there was no VB Code in a module first).

1. When I changed the value to =Month(Now()) the field contained Jan
2. When I changed the value to =Now() the field contained Aug

I checked the properties of the field and found the format to be set to "mmm", so I changed the format to short date.

1. When I changed the value to =Month(Now()) the field contained 1/7/1900
2. When I changed the value to =Now() the field contained 8/28/2008

I removed the format entirely, and and the following was displayed.

1. When I changed the value to =Month(Now()) the field contained 8
2. When I changed the value to =Now() the field contained 8/28/2008 11:35:10 AM

I next tried the function MonthName

1. When I changed the value to =MonthName(Month(Now()),True) the field contained Aug
2. When I changed the value to =MonthName(Month(Now()),False) the field contained August

Somewhere in these tests, I hope that there is something that you can use.

 

[wiklendt]

awesome links dkinley!

You could use to display the month ...

However since you say you are a beginner, I would suggest the following links to get you past the smaller hurdles in learning Access. Great tutorials and examples to get through the basic learning curve.

http://www.techonthenet.com/access/index.php

http://www.sienaheights.edu/personal/csstrain/Access2007.htm

http://www.functionx.com/vbaccess/

well ***i*** appreciate those links - i'll be using them for sure - they look great (even on first glance)... i love learning about this stuff :-D