Format Date error in Control Source of MS Access 2000

Posted on 2007-10-12
Medium Priority
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
  • 2
LVL 14

Accepted Solution

ragoran earned 2000 total points
ID: 20066569
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

ID: 20067014
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

ID: 20067623
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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

862 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