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, 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

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

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...

Hi, Anybody know how to run Access project in two machines? We need do working side by side to quick finish the project. Our project is in the network right now. Thank you very much. Jing

Hi, All, I am working with an Access project. I create the form based on the stored procedure, but I couldn't get form, just return the message: "The stored procedure is successfully but not return record" Why? How should I do? The following are my stored procedures: declare...

Hi, All, I am working with an Access project. I create the form based on the stored procedure, but I couldn't get form, just return the message: "The stored procedure is successfully but not return record" Why? How should I do? The following are my stored procedures: declare...

Hi, Can I do this way: select name from (execute sp_student). I really want to get this field from sp. Many Thanks. Jing

Hello, All, This is my stored procedure, but doesn't work. The error is: "subquery returned more than one value". CREATE PROCEDURE qrycount AS update complaints set num_of_complaints = (select count(compli_num) from complaints where compli_num is not null group by compli_num )...

Hi, all, I have the format date info.: " =(Format([Start],"General Date")) & " " & Format([TimeOut],"Short Time")" and "pickdate =CDate([Start])+[TimeOut]" I want to get after 24 hours date base on "pickdate". Thank you very much...