Search results for query: *

Hi, I have just written a small programm, using objects, which sends a mail in Groupwise with an attachment to a certain address. But now i want to save an attachment from a mail. How can i do this with objects? Thank you.

Hi, I have just written a small programm with objects in VBA, that sends mails with groupwise. Now i want to save an attachment using objects in VBA. Thank you.

Hi, I have just written a small programm, using objects, which sends a mail in Groupwise with an attachment to a certain address. But now i want to save an attachment from a mail. How can i do this with objects? Thank you.

Hi, Terry, Yes, the City always separated by " - "(at most four cities). In my table I have three fields, I want to split out "TERRITORY" field separated by city and shared with first two fields info. That means look like the new table. **************** Old table: MC#...

Hi, Terry, I am doing a MS Access project and connection to SQL server. Actually, I am a real newer to face this project. I just need this new table, either way to using SQL or stored procedure or other way. By the way, I will join your group today. Thanks again. Jing

Hi, All, I have the table like that: MC# TYPE TERRITORY ---------------------------------------------- 005 Taxi Chicago - providence - New York ... I want to get result like that: MC# TYPE TERRITORY ---------------------------------------------- 005 Taxi...

Hi, All, I have the table like that: MC# TYPE TERRITORY ---------------------------------------------- 005 Taxi Chicago - providence - New York ... I want to get result like that: MC# TYPE TERRITORY ---------------------------------------------- 005 Taxi...

Hi All, How to cut duplicate data in the table using query? When I inport data from MS Access to SQL server, all data are duplicate in the same table. Other way to avoid this problem? Many Thanks. Jing

Thanks Terry! Jing

Hi, All, When I run this stored procedures more than one times, all data are duplicated in this table? What should I do to solve this problem? Thanks for your advance. Jing The following are my stored procedures: CREATE PROCEDURE qrycount @MC_NUM nvarchar(25), @COMPANY_NAME...

Hi, How to automatic show up AUTO_ID(text box) in the add new form? Example: When I click "AddNew" buttom, the AUTO_ID(auto number) should be showed in this form. Any help? Thank you very much for your kind help. Jing

Hello, I try to compute Total_to_date. eg: FIELDS: FINES DATE $200.00 8/2/01 $300.00 8/6/01 $600.00 8/7/01 ... ... I want to create subform for total fines that means when I select date(8/6/01), the subform total_fines...

Hi, Guys, How to set up total for All pages? I tried to set up pagefoot for total, like "Sum(field)", but doesn't work. Thanks Jing

Hi, friends, I have a report title: " Summary of 2001 Receipt Transactions July 1, 2001 Thru July 31, 2001 " I want to know how to get "July( currentMonth - 1) and LastDate of this Month. Can help me get it? Many Thanks. Jing

Hi, All, I have a report for state informaton. I have three fields: State, NUM_OF_VEHICLES, AMOUNT I set up pagefoot for tatal: like, sum([AMOUNT]), sum([NUM_OF_VEHICLES]), but is not works. I want to get "Whole state" total for Amount, num_of_vehicles. Thanks for your help. Jing

Hi, James, When I click this buttom, nothing come out. What's wrong?? Thank you very much for your advance. Jing

Hi, vz, It works for MS Access(.mdb) not work for Access Project(.adp). I don't know What's wrong I did. Any suggestion. Thanks

Hi,Jeff I already try that, still not work. Thanks Jing

site (Visitor) Aug 8, 2001 Hi, All, I have a Access project, and connect to SQL server. In the form I create "Add New" buttom, but doesn't work. The following are my codes: Sub AddNew_Click() On Error GOTO Err_AddNew_Click Dim strDocName As String strDocName =...

Hi, All, I have a Access project, and connect to SQL server. In the form I create "Add New" buttom, but doesn't work. The following are my codes: Sub AddNew_Click() On Error GOTO Err_AddNew_Click Dim strDocName As String strDocName = "frmComplaints" Docmd.OpenForm...