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

    Filter Data in ASP

    Thanks i have done it
  2. aishaaa

    Linking table in two different DB

    Hi, am new to SQL and never use it before it might be easy one but unfortunately I don’t know the answer .. I have 2 table in 2 different database I want 2 link them any idea how to do it ?? thansk
  3. aishaaa

    Filter Data in ASP

    Thanks a lot all ... but shaddow am getting error in the rs.activeconnection = conn .. do u have idea how to sort the extract or downloaded data to excel sheet .. i want to sort the currency and banks thanks again
  4. aishaaa

    Filter Data in ASP

    Hi, any idea how to filter data extracted from DB "table" in ASP
  5. aishaaa

    Download from SQL to Excel sheet

    Thanks alot for your support .... i have done it ... and it's working fine
  6. aishaaa

    Download from SQL to Excel sheet

    Thanks for the reply ... (AGIMA)i expected to open excel sheet with the data and user will save it .... (Veep) i didnt get this one <% 'Change HTML header to specify Excel's MIME content type
  7. aishaaa

    Download from SQL to Excel sheet

    Hi, I have the below coding but it’s only displaying the data not saving it to excel I guess I have a problem with my coding please help me … <HTML> <HEAD> <TITLE>Telex Transfer</TITLE> <% 'response.setContentType &quot;application/excel.xls&quot...
  8. aishaaa

    Automation process

    Thanks alot again VBAjedi .... Now I know what I want exactly .. the data base will be from SMM server and I will run query to get the information I required … but do you think I should develop a small VB program to do the same or write a macro in excel which get the information daily when ever...
  9. aishaaa

    Automation process

    Hi thanks alot for your reply .. I was thinking the same it's difficult to get the information from the email and we cant give the user access to the original DB .. but i didn’t understand the last part i mean the extract from excel can you please explain it to me so i can start working..
  10. aishaaa

    Automation process

    The email &quot;per transaction&quot; is generated automatically from different system ( BA system ) and sent to outlook user .. I want to gather all the data available in this email .. around 4 lines ( beneficiary name, amount, currency, ref (contain branch short name and auto generated...
  11. aishaaa

    Automation process

    Hi We need to automate one of the process but I don’t have any idea which type of code I can use it’s 2 different system one is front end system send auto generated email per transaction ( beneficiary name, amount , branch )and from different branches .. we need to compile all this email to one...
  12. aishaaa

    in oulook .. i want to forward same

    in oulook .. i want to forward same msg again and display the body in excel sheet am using this but its not working Dim ol As Outlook.Application Dim ns As NameSpace Dim folder As MAPIFolder Dim ws As worksheet Dim i As Integer Set ol = creatobject(&quot;outlook.application&quot;) Set ns =...
  13. aishaaa

    VBA for excel

    ...as squer and the number in opposit side .. i dont care about the word but the number i want it to be in opposit for example the current Name ID ******* - 001-350478-0095 - i want to be name ID ******* - 0095-350478-001- please help me on...
  14. aishaaa

    copy data from email to access or excel sheet

    Hi, can any one tell me how to copy a data from email to access or excel sheet .. i think it need a programming to be done on outlook Thanks
  15. aishaaa

    create a email... from an excel vba app...

    if u r trying to send a sheet or more u can try this Worksheets(Array(&quot;sheet2&quot;, &quot;sheet5&quot;)).Copy ActiveWorkbook.SendMail &quot;email@hotmail.com&quot;, &quot;test&quot;
  16. aishaaa

    Date format from second to date

    hi i have tried it but am getting error .. &quot;the remming text dose not appear to be part of formula&quot; .. can u please help me Thanks in advance
  17. aishaaa

    Date format from second to date

    thanks for ur help i will check it and let u know if it's working fine
  18. aishaaa

    Date format from second to date

    ...field in SCR to get it to date format. Formula is as below NumberVar TimeChange :=-5; NumberVar SecPerday :=86400; NumberVar SecPerHr :=3600; ({CALL_REQ.CLOSE_DATE} + (Timechange * SecPerHr))/SecPerDay + DateTime (1970,1,1,11,00,00); but it's not working .. can u help me please Aisha
  19. aishaaa

    sum option

    thanks for your reply .. i have tried this option but it's giving error ( the result must be string )
  20. aishaaa

    sum option

    Hi .. I need a help .. I have a report with amount field which need to be sum but this field in the data base is varchar . so when I use this formula give me error it should be a numeric field ... sum ({fieldname}) I think I need to convert the amount field to numeric field but only in...

Part and Inventory Search

Back
Top