Recent content by John M

Attachment uploaded Sorry forgot to attach attachment, but it is done now

I've been trying to get an answer to this everywhere but with no success. I can't specify Chinese characters in WHERE clause of SQL Statement. See attached file.

Hi, I'm using the following: 1. English Windows XP Home edition 2. MS Access 2000 Issue: In the form coding (visual basic) i want to be able to match for Chinese characters. I'm able to view and edit Chinese in the table. But when i try to program a button in the form to search for a chinese...

I got it working I've got it working now. I upgrade my Office 2K to the latest service pack and the input mask works now.

I think so Yep, i don't have problem with same application running on Chinese Win98. Very strange but true. I've yet to find out why.

I had searched several forums but could not find any Inut Mask question similar to mine. Here is what's happening. When I enter data in the text box with Input Mask the cursor stays at the same position all the time, every digit I entered replaces previous digits. I have to press the Right...

Win2K or Win98 Are you using Chinese Win2K with Chinese Access? I don't have the problem if i use chinese 98.

Input Mask problem Hi, Did you ever manage to find a solution for this? I'm having the same problem as you.

Problem Update Hi, I've change the font in the Access table to a true type font (PMingLiu) but to no avail. If i change content to English, it is displayed properly in test.asp, input Chinese and test.asp displays "????". I'm totally stuck!! I've also tried using UNICODE font in Access...

Follow up question to Doc Man Thanks a million Doc_Man - someone finally has a reply, i'm not alone. There are a few questions that want to you elaborate on you answer (stated below for your reference). Question: Are the Chinese characters generated by a TrueText Font File? Can you elaborate...

Hi, I tried to post this in the ASP forum but got no replies so i'll try here. Database: MS Access 2000 (English) ISP hosting: Envisage Windows site hosted on a full IIS Virtual Server running on an Windows Server 2003 Objective: Screendumps provided in word doc I want to be able to...

Hi All, I have two fields on a form that I want to use in a query: First Field : used to specify operator (i.e. >, >=, <, =<, =) Second Field : used to specify number I want user to enter values in form so that I can run query using these combination of values, i.e. >6 or >=6. How can I do...

GJT, The "AfterUpdate" event populates other fields based on the value in the field. For your information, the field does not need to be bound to a table for "AfterUpdate" to work. Thanks for asking.

Sorry, I meant the "AfterUpdate" event the text field and not the "onupdate" event of the form. I don't know how to trigger the "AfterUpdate" event from the first fiorm. Thanks.

Hi, I have a form that the asks the user to enter "a book id". When he presses the OK button the "book id" is inserted in another open form. But now I want to trigger the AfterUpdate event without any user intervention. How can I do that?