Recent content by yan19454

I want to have button when end user click. The Find From the menu bar pop up. Thx.

Dian: I received 1000 emails which the content of the email is another email as attachment. I want to export the attached email to excel. I can export the content of the email to excel but not the content of the email. Thx.

See the posting: I need to open the attached msg file and export to excel file. I can't click more than 1000 message and I can't export the message out. Thx.

It opens out the message.

I get a forwarded e-mail that comes as an attached msg file. It is around 1000 message. I need to open the attached msg file and export to excel file. I am oK with export the regular outlook item. but I do not know how to convert the attached msg as normal email message file. I am ok to dump...

Problem solved according the solution on the link. http://www.vbcity.com/forums/goto.asp?show=reply&tid=154110&rid=505746

do not know why it did not update. the datarow count is 276. the string in query can return select * from NewImportLabChar where Mid([NewImportLabChar]![LabResultString],1,1)='>' or Mid([NewImportLabChar]![LabResultString],1,1)='<' return 276 record ,too. but one thing is strange is...

If LabOutConnection.State = ConnectionState.Closed Then LabOutConnection.Open() End If Dim sqlStr As String = "select * from NewImportLabChar where Mid([NewImportLabChar]![LabResultString],1,1)='>' or Mid([NewImportLabChar]![LabResultString],1,1)='<' " Dim...

If LabOutConnection.State = ConnectionState.Closed Then LabOutConnection.Open() End If Dim sqlStr As String = "select * from NewImportLabChar where Mid([NewImportLabChar]![LabResultString],1,1)='>' or Mid([NewImportLabChar]![LabResultString],1,1)='<' " Dim...

it need to be update daily. I do not think I like to open the file and delete that daily.

I have excel file which has two columns with the same name. I can't import the file into MS Access. Will you please give me the code to delete one of duplicated column first in MS VBA code so that I can import. Thx.

I have one table module log which have trigger association with that. When I insert into [module log]([Employee Name], [DOB], [Module Name],[Access Module Time], [manager login ID]) SELECT [FULL NAME], DOB ,'Back Injury Competency',getdate(), 'abcl' FROM OcchEmp WHERE (Unit...

I have three tables OcchEmp,tblInternalEduModule, tblCurrentWinTrainingLog I want to get the total employee count in OcchEmp group by unit as Tcount I need to the count employee in tblCurrentWinTrainingLog as count group by module name tblInternalEduModule which category is WIN and group...

right now I use Dim myConn As New SqlConnection(ConfigurationSettings.AppSettings("ConString")) myConn.Open() Dim selectCom As New SqlCommand("Find_SClinicals_Training_Total", myConn) selectCom.Parameters.Add("@DateFrom", SqlDbType.DateTime).Value = dtB...

ALTER PROCEDURE [dbo].[Find_SClinicals_Training_Total] @DateFrom datetime='09/04/05', @DateToIn datetime='03/04/06', @mName varchar(50), @ccName varchar(20), @tCount int output AS SET NOCOUNT ON begin declare @DateTo datetime select @DateTo = @DateToIn+1 declare @moduleName...