Re: a bug or an error?(date function)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 12/29/04


Date: Wed, 29 Dec 2004 02:12:05 -0500


"Null" <Null@discussions.microsoft.com> wrote in message
news:C3890CAD-3334-4C2C-8DB0-2AC92243122C@microsoft.com
> I have use date function in my report.it bound to text like this
> "=IIf(Month(Date())>6;Year(Date()) & "/" &
> Year(Date())+1;Year(Date()))",
>
> it works well on my own computer(my computer is install winxp pro and
> office 2003).but it can't run in a computer which install windows2003
> server and office 2003. If i run this report in the windows2003 ,it
> will let me to fill the date.becase it can't recognize the fuction
> date?(). why this happened? is it a bug or my error?

Often when databases don't work on one particular machine, it's because
of a broken or missing reference. See if the steps outlined here help:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)


Relevant Pages

  • Re: Error in Index Reorg in Maintenance Task
    ... index as well as that settings are set. ... I guess it is a bug then. ... can query sys.indexes to find out which indexes has page locking ... Backup Databases ...
    (microsoft.public.sqlserver.server)
  • Re: [Full-disclosure] CertificationMagazine - Blind SQL Injection Vulnerability
    ... You had posted first 1 year old BUG - leeched from MY VULNERABLE Sites DATABASE ... " then records of the databases that u dumped... ... because of the fact that you guys hack illegal into web-servers and dump the databases and do not notify the vendor." ...
    (Full-Disclosure)
  • Re: How many people are using ASM?
    ... with our databases but are considering using ASM for our new 11g ... I'd think long and hard about using ASM in that environment: the list of bug reports and fixes is quite extensive on anything outside Linux. ... Just requires careful wading through lists of bug fixes in the chosen OS for the latest release, then investigation if there are backports of patches. ...
    (comp.databases.oracle.server)
  • Re: Hang VB fast!
    ... 's wild thoughts were released ... Most likely there is a missing reference. ... perhaps some bug in the code. ...
    (microsoft.public.vb.general.discussion)
  • Re: Issues with using .AddNew directly on a Forms Recordset
    ... joke given the subject? ... This is a known bug that MS are working on. ... unexpected behavior that makes a person wonder what's going on, ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)