Recent content by AnnYH

If you use access as your database, before you run the page make sure you access database is closed. otherwise, it will show the error msg that you have got.

Hi,Guys: Here is how I done this part. It is working perfet. I can auto fax hundred of fax at same time. 1. Install the "Fax Mail Transport" on your OutLook.( I suppose you have a moden installed on your computer) 2. at report design view setup your printer is FAX. 3. Modify code...

Hi, EveryOne: Is anyone konw? Why when I used Docmd.SendObject acReport,"Invoice",acFormatRTF,"[FAX:+1(456)2909876]",,,,,False It suppose to open my outlook 2000, but for some reason, it open my outlook express. Any idea will welcome. Thanks advance Ann

Thanks, George. You are great. It's fixed. Do you know about my second problem? :)

Hi, Everyone: I have two problems: 1.Counter: My counter doesn’t work properly. Some time it can count in, some times not. Code in global.asa Sub InCrementCounter() Set fsc=Server.CreateObject("Scripting.FileSystemObject") Set...

Hi, Everyone: Is it anyway to solve this problem? ********* For Access 2000 Default bug and Canceling.I have found if you do the page steps in Access 2000 it works OK for a while. But for some reason, in Access 2000(specially for win 2000, win 98 seems fine.) it will default back to the...

Thank you so much. You are the best. Ann

Thx. There. You are right. The print spooler is not started. One more question, the user don't have permission to start it. I used the admin to change this. When next time it is reboot, it will be keep status to be started. Is it correct? Thanks Again Ann

Hi, There: Is anyone knows what happen? Our workstations(win2000 pro) have some trouble with the network printer. Every day when they use for a while, their desktop will lost their printer, they can't print any more. Only way I can solved this problem was re-start their computer. After...

Hi, Cris: Sorry, yesterday I didn't read your post carefully. I tried in mine. When I linked the table using Access 97. The Memo change to Text(255). If you link the same table using Access 2000, it will show the fields Memo. If frontend is Access 2000. the link table still show the fields...

Hi, Cris: Microsoft is not that smart enough. After you upsize your access to SQL. You must go into the SQL database check the data type and default value. In my case I changed the memo to ntext. A lot of small things you need take care, after you upsized the access. Hope it is can help you. Ann

Hi, Everyone: Is it any way can help me to solve my question? In my main table, I have primary key PID. And another column is WBNUM( data type: nvarchar , allowed Null). For WBNUM, I need this column can be null, after it is entered a data, they are not allowed to be duplicate. What can I...

You haven't got your data. There are so many reason. Check your database is connected. Data fields are match that you want to show..... AnnYH

Hi there: I’m working on Access 2000 front-End, SQL Server 2000 backend DataBase. When I enter the new order through the Access bounding form. It is working fine. New record can be inserted in table. But when I tracing the order that I just enter in and edit it , the Msg show me “Write...

Sorry, You should not have both 'Enable relationship for INSERT and UPDATE' and 'Enable relationship for replication' checked. Both three check box should not be checked. Leave it blank. You will be able to insert new record and edit. AnnYH