Solved

Access form date appears in Chinese

Posted on 2011-03-08
7
383 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

710 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