Search results for query: *

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

Ok, now Go to your diagram, check the relationship, uncheck "enforce relationship to replication" and enforce relationship to Insert and Update" after that you can edit you each table from table view. Your table are enforce the relationship. So you can't just put record to one...

Hi, Rott: I haven¡¯t used SQL Server authentication, I used NT authentication. So I¡¯m not sure it will be same or not. For us, first time we got SQL table was not allowed me to make any change. 1; On Access link table, directly open your table ¡°Table1¡±, can you see the record navigation...

Hi, Rott: There are a lots of thing you should make sure. 1. error msg pop out at new order entry or edit record. 2. You said you migrate out of Access 97, you must use dao to work with Access frontend. 3. How did you setup you PK? Autonumber or no? SQL server not like Access, you must change...

I guess your table have PK it is autonumber. And you used Dao to insert new record, SQL server not like Access, you must change to ADO. It¡¯ll work fine. This one happened to me. If my table has a autonumber, the vb code must be changed from Dao to ADO. I hope it can help you. Good luck! AnnYH

Hi, Experts: There is a problem about sending email from Access. It bothers me a long time. Is there any one can help me? Sub SendEmail() Dim strEmail as string Dim strSubject as string Dim strMsg as string strEmail= "accnt@hotmail.com" strSubject = "New Client...