Search results for query: *

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.

...trigger CurrentWinModuleInsert on dbo.[Module Log] for insert as --insert on the win module Back Injury Competency only i if (SELECT COUNT(*) FROM inserted WHERE ([inserted].[Module Name]='Back Injury Competency') ) >0 begin insert into...

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

...[Access Practice Time] >= @DateFrom and [Access Practice Time]<@DateTo ) x ON x.[Employee Name] = h.[Full Name] and x.[DOB] = h.[DOB] /** WHERE (h.CC = 'A11')**/ set @tCount=@@rowcount PRINT '1 all all @Cc = ' + @ccName + ' @mName = ' +@mName end if (@ccName='All' and...

Thx. Right now I use dataset and table count. I will check that out return parameter or an output parameter .

the problem is I need to return value from the row count to my web application. Thx.

Any way to do get the record count of the following query. SELECT distinct h.[Full Name],h.DOB FROM annual_edu_2006.dbo.HREMP h INNER JOIN(SELECT [Employee Name], DOB FROM [Module Log] UNION ALL...

module log Name DOB [Access Module Time] [Module Name] ABC 1/12/02 1/12/07 Help ABC 1/12/02 1/12/07 Help2 ACC 1/12/62 11/12/07 Help2 ACC 1/12/62 12/12/07 Help...

I tried that. It did not work. do not know why ? I do not know whether it need to write function to pass the value of selqryOmzetANG.NAAM SELECT selqryOmzetANG.NAAM, Sum(selqryOmzetANG.FACTUURBEDRAG), functionA (selqryOmzetANG.NAAM) FROM selqryOmzetANG GROUP BY selqryOmzetANG.NAAM function ...