Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yan19454

    find

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

    export the content of the attached msg out

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

    export the content of the attached msg out

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

    export the content of the attached msg out

    It opens out the message.
  5. yan19454

    export the content of the attached msg out

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

    record did not update the table

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

    record did not update the table

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

    record did not update the table

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

    record did not update the table

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

    delete duplicate column in the excel from MS ACCESS

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

    delete duplicate column in the excel from MS ACCESS

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

    insert short date to table

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

    join and count

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

    record count of the query

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

    record count of the query

    ...[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...
  16. yan19454

    record count of the query

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

    record count of the query

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

    record count of the query

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

    union sum

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

    union query?

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

Part and Inventory Search

Back
Top