MonthName

  • Thread starter Thread starter smgmarino
  • Start date Start date
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?
 
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)

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted 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)

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Sorry for the double post! I showed no completion of the post submission and
tried again.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Back
Top