[AccessD] MonthName Function Undefined - What's Missing?:

Ron Moore rmoore at comtechpst.com
Tue Aug 24 09:25:38 CDT 2004


Max, not the wrong end of the stick at all.  I had simply always done it the
other way (the function name was self explanatory) but will be changing to
your approach for future work.

Ron

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MG
Sent: Tuesday, August 24, 2004 9:53 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MonthName Function Undefined - What's Missing?:


Ron, I may have the wrong end of the stick here, but if you want month names
then just use the format function, viz. ? format(date,"mmmm") gives August ?
format(date,"mmm") gives Aug 
Max Sherman


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ron Moore
Sent: 24 August 2004 14:38
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MonthName Function Undefined - What's Missing?:

Thanks Gustav! I was beating my head against the wall.

Since it seems there was a lapse in mail yesterday, I tried some string
manipulation and nested IIFs, but it got ugly quick.  So I just created a
static table (1-12 with month names) and used the Month function and linked
to the lookup table.  Probably not the best solution, but time was of the
essence.

Thanks Again,
Ron

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, August 23, 2004 11:33 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MonthName Function Undefined - What's Missing?:


Hi Ron

This is an old bug that may not have been solved yet:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;225956

/gustav


> I installed an A2K app at a remote customer site and found that the
> expression 'Time Period: MonthName([Period_Start_Date],True)' in one 
> of my queries raises the error 'Undefined Function MonthName in 
> Expression'.  I am told it was a full blown install of A2K, but 
> something appears to be missing.

> Any ideas?
> TIA, as always,
> Ron

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004
 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list