Solved

Access form date appears in Chinese

Posted on 2011-03-08
7
372 Views
Last Modified: 2013-11-28
I created a text box on my menu form, default value = Now(), I open the menu and it does infact display     3/8/2011 1:30:00 AM     then i create a query with a column     expr1:[forms]![frmMenu]![txtDate]      when i open the query, it shows Chinese characters in that column,  I see this happening in dozens of other places that have been working fine up until now
0
Comment
Question by:rick_nicholsfarms_com
  • 3
  • 2
  • 2
7 Comments
 
LVL 84
ID: 35074535
Have you performed maintenance on the database?

First, make a backup, then Compact the database. You didn't mention what version of Access you're using, but:

Access 2003 and earlier: Click Tools - Database Utilities - Compact
Access 2007: Office button - Manage - Compact
Access 2010: File tab - Compact

You might also try importing the database into a new, blank container.

If that doesn't work, then please post a screenshot of the issue you're having.
0
 

Author Comment

by:rick_nicholsfarms_com
ID: 35074752
I am using Access 2003.   I did do a Compact and Repair, I also tried importing the form and query to a new blank DB.  Its still happening on both our Windows 7 and Windows XP PCs.
Untitled.jpg
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 35159207
In my experience, when you start seeing Chinese characters in a table, it is badly corrupted, and you will probably have to go back to an earlier version.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Accepted Solution

by:
rick_nicholsfarms_com earned 0 total points
ID: 35159515
FIXED IT      you have to use  CDATE(......)  around your expression.  Thanks folks
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 35184552
Is the control bound to a Date field?  If so, just use the field itself in the query (if possible)
0
 
LVL 84
ID: 35197571
CDate will NOT fix this issue. It may have masked the issue you have, but CDate does nothing more than convert the string to a Date datatype.
0
 

Author Closing Comment

by:rick_nicholsfarms_com
ID: 35221284
i actually got the answer from a local tech
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

760 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

16 Experts available now in Live!

Get 1:1 Help Now