MonthName

S

smgmarino

I am trying to automate the text box to read "For Month Of" & MonthName() &
", " & CurrentYear()
This keeps coming back with
wrong number of arguements. This used to work but it doesn't anymore.
The database is Access 2000 but I am on XP.
Any ideas?
 
L

Linq Adams via AccessMonster.com

It's never worked like that, at least not in Access!

MonthName() as Access told you, needs an argument; the numerical designation
of the month in question. CurrentYear() is not even a VBA/Access function, at
least not thru ACC2003. This code will return the current month/year, which
is what I assume you're trying to do.

"For Month Of " & MonthName(Month(Date)) & ", " & year(Date)
 
L

Linq Adams via AccessMonster.com

It's never worked like that, at least not in Access!

MonthName() as Access told you, needs an argument; the numerical designation
of the month in question. CurrentYear() is not even a VBA/Access function, at
least not thru ACC2003. This code will return the current month/year, which
is what I assume you're trying to do.

"For Month Of " & MonthName(Month(Date)) & ", " & year(Date)
 
L

Linq Adams via AccessMonster.com

Sorry for the double post! I showed no completion of the post submission and
tried again.
 
Top