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 SkipVought 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: *

  • Users: amal1973
  • Order by date
  1. amal1973

    Return the week and month of year

    thanks for your soulotion , it got me closer to what i need . thanks
  2. amal1973

    Return the week and month of year

    I have a date filed in an access report , i would like to find a function or something that will take the date value and return a string that tells the week number and the month's name ... appreceate any help
  3. amal1973

    Automation Process -Outlook and Access

    I am so sorry for not being able to thank you for your help . with little customization , i built a very smoth process . thanks
  4. amal1973

    Automation Process -Outlook and Access

    I have a Folder that has around 300 Excel Workbooks. I also have a table in access that has the email addresses for every workbook that should be sent. Please help me develop a code that will attach the Excel File to the specific email. Ex.. Excel Workbook Name: OZ3.XLS Access Table ...
  5. amal1973

    Excel Vba Or Function ?

    Thats what i was looking for .. cant thank you enoght thanks
  6. amal1973

    Excel Vba Or Function ?

    Thanks a million , I did not think it would be so easy , problem solved , But if i wanted to have something like that in a vba function is it dowable ?
  7. amal1973

    Excel Vba Or Function ?

    Hello , I would like to write an excel function or a VBA function in Excel, What it will do is: If the amount in column N is more that zero, Go and look at column D and E and F by choosing the latest date from these three columns and then putting the difference in dates between that latest date...
  8. amal1973

    Access and out look

    Any Sugestion s??!
  9. amal1973

    Access and out look

    I receive 100 emails a day, same subject but with different information in the body. I want to be able to create a Macro or VBA code that will open every email with the specified subject and populate an access table with the data. This is how it looks.. Appreciate any help...
  10. amal1973

    String Manipulation !!!

    TonyJollans --It worked perfectly – thanks a million CajunCenturion— This description comes from a mainframe system like that, it does not change., what might change is the Characters and numbers Ex.. ACCR could be ABBT or ACT. The date would come 9/30 and RECR BNS are two words with a...
  11. amal1973

    String Manipulation !!!

    JunglesMcBeef.. Thanks for your reply, Two thing I need to understand cause I started to have all kind of errors J . My String is in a record set, and about yelling out if you don't get it I am yelling now. I am missing how to put the string in the where clause. And yes the last number's...
  12. amal1973

    String Manipulation !!!

    Hello I have this string “ACCR 9/30 RECR BNS 03058864” I need to build the where statement in a query that will look at the first 4 characters and the characters after the date. So in this example it should look at “ ACCR” and “RECR BNS “ This is an example of what am trying to do … strSql...
  13. amal1973

    Insert Into Problem Error

    thanks for your fast reply . this is the error i get . HTTP 500.100 - Internal Server Error - ASP error Internet Information Services -------------------------------------------------------------------------------- Technical Information (for support personnel) Error Type: Microsoft JET...
  14. amal1973

    Insert Into Problem Error

    I created this Registration Form , its little primitive , but I am having problems with the insert into statement , I tried every thing , appreciate any help <HTML><head> <TITLE>New User Registration</TITLE> <FORM action = &quot;Register.asp&quot; method=&quot;post&quot; id=form1 name=form1...
  15. amal1973

    Login Form

    medic, I managed to make it work , you r example did the trick, thanks
  16. amal1973

    Login Form

    medic ... thanks for that nice example, but i am having a problem telling me that Canot find file C:\MyDir\MyDB.mdb although i did change the data base to access and did create the database on the C drive ?? can you tell me what am doing wrong
  17. amal1973

    Login Form

    Medic ... Thank you for your fast reply.. I think I have got the DB part, but how can I do that using ASP. And how to redirect the user to the write place..Please advice
  18. amal1973

    Login Form

    Lets say that I have friends and family .I would like to create an ASP login Form that will direct the user if he has family to the family page And if he was a friend to the friends page. I would really appreciate any help in developing this form. Also if there is a ready scripts that I could...
  19. amal1973

    Union atuomation !

    Thanks for your replay.. Any Code will help :-) Thanks
  20. amal1973

    Union atuomation !

    Hello .. I receive three databases every month. Every database has a table that is exactly the same in the other databases. What I would like to do is create my own database and to create a table that has the same structure as the other three tables and start appending data to it. I rally would...

Part and Inventory Search

Back
Top