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 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 ...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.