Format Date error in Control Source of MS Access 2000

Posted on 2007-10-12
Last Modified: 2013-11-28
Here is a puzzlement.

I have an MS Access database and am using on a report in the Control  Source the default to populate a textbox field with the current date in long format and am using the plug and play of MS access to populate the control source entry.  The Code is
=Format(Date(),"Long Date") & " " & Format(Time(),"Long Time")

Now here is the kicker.  This works on my computer and a user computer and gives them the current date in the report.  However on two other user computers it gives them an error of #Name?

However a previous verision of the MS Accessdata from a couple of months ago prior to some edits that where done works and does not give an error.

Previous and current does not work on some computers.
Pervious and current does work on other computers.
The code for both versions is the same.

Could this be an update issue with MS Office.?
Question by:peggyweber
    LVL 14

    Accepted Solution

    This looks tome like a missing reference.   On the PC where it doesn't work, have a look at the references to ensure none are "Missing" (from the VBA editor, go to Tools > References menu.


    Author Comment

    Missing: Microsfot Windows Common Controls-2 6.0 (SP4)

    So I took it out of the program and reran it on the computer it did not work on  It worked.

    However what is this and by not having it what have I lost.  Or how do I make it so everyone has it.

    I don't recall adding this item but something must have.

    LVL 14

    Expert Comment

    MS Common control library contains many control such as TreeView, ImageList and ListView.  The reference will be added automatically if you insert one of these control in a form.  If you change your mind later and remove the control, the reference stays.

    So you may not need it.  

    If you do, then you need to create a setup program (using Office 2000 Developer kit is the easiest way for you) to deploy your application including these DLL.  It vcan be done manually, but there are many steps involved.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now