Recent content by ArmstrongHe

Hi,Ken, I just want to explore a more precise way to judge whether a field does exist or not, sth like a function that looks like "isfield(mayqty)", or some other coding method. It's not easy to find that out? I have seen your personal website. It's last updated in 2000? Now you are a...

Hi, KenReay, Thank you very much! I am a beginner. I have two further questions: 1. How to check whether I am using ADO or DAO if I have just used "dim RS as recordset"? I only know I am using ACCESS-XP. 2. "trap resulting error" means that I should use an "on error goto..." statement? What...

Hi, Gang, Another beautiful Day for you and me in this tips-land! The question is, How to judge whether a field is already added into a table? For example, part of coding like this: qname = "alter table " & ii & " add mayqty double;" myDb.Execute qname, dbFailOnError but an error...

Dear Sir or Madam, One year ago I set password for my user ID in a workgroup, a MDW file. Now I just want to study the coding of that program, but I forgot my password. What can I do? I am using ACCESS-XP. I have tried importing the modules with a new database but failed. Thanks! Armstrong

Dear Sir or Madam, In Windows2000 (English version), an user open his outlook but cannot read Chinese mail-titles properly in "inbox". But if double-click that mail, the mailbody can show Chinese words quite well, including mail-subject. I have also checked "locale", Chinese language is used...

Hello, when I save an office file into local windows2000 file server, or forward a mail with Outlook,Error message "server is busy, your operation cannot be finished,Please click 'switch to' to cancel the operation and retry" sth like that. Then the user cannot even close this error message and...

Dear Sir or Madam, In MS-word2000 file, I see this line: {HYPERLINK "http://www.sohu.com/"} All MS-word files in this computer has this same problem, the real hyperlink just cannot be showed properly. I have tried many ways to solve this, but failed, even after I have removed office2000...

Dear Sir, In a MS-word file, I see this line: {HYPERLINK "http://www.sohu.com/"} All hyperlinks cannot be showed properly in this computer's MS-word2000 file, with just sth like above. But I have tried many ways to get real hyperlink in those "doc" files, even after I have reinstalled...

Hi, Roy, You are very warm-hearted, thanks for your help. Once I also know someone named Roy, Are you an American? Regards! Armstrong

Dear Sir, One ACCESS MBD file is well runing in my computer, but in another computer, also installed with ACCESS2000, with the same MDB file, trim() is not valid in SQL statement of a query, and isnull() is not valid in VBA program. Those two problems are due to the same reason or not? What...

I am working in China, for an American company. I am Chinese, very nice to know you by tektips. thanks again!

Hi, Andreas, Yeah, at least compile is passed well without error. Are you working in Germany? Best Wishes! Armstrong

Dear Sir, What should we do if everytime windows2000 start with safe-mode? problem happens because of unreasonable domain conversion. but that's a new challenge. thanks! Armstrong

Hi, Andreas, You are very nice! thanks very much! I have read the homepage, I can read some German, it's your personal homepage? Thanks! Armstrong

Dear Sir, When I compile the following code in VBA of ACCESS2000, I saw compile error like "method not found or invalid number" due to the line "RS.edit". How to overcome the problem? Dim RS As Recordset Set RS = myDb.OpenRecordset("PL-report")...