Solved

Access form date appears in Chinese

Posted on 2011-03-08
7
375 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

821 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