Search results for query: *

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

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

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

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

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

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 ?

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

Any Sugestion s??!

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

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

...And yes the last number's field size is always 8 This what I did so far, but errors as type mismatch Set rstLoad = DB.OpenRecordset("Select * from Tbl_Report_Download") While Not rstLoad.EOF intSpaceChar = 0 strField1 = "" strField2 = "" strNewChar =...

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

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

...& "', '" & Request("password") & "');" conn.Execute sSQL,adCmdText else SQL = "Delete * from TLogin where username= '" & Request.Form("userid") & "'" conn.execute(SQL) end if sSQL = "Insert into TLogin...

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

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

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

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

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

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