Recent content by lokanathas

Use this in build in function FormatDateTime([Table1]![Day],2) & FormatDateTime([Table1]![Day],4)

Thank you very much for your update. 1)is it possible to send a excel data as attachment instead of pasting data on the mail body 2)after opening the new mail, can mail sent with the macro instead of send each mail. i had shared you only sample, i need to send 100 mail data volume of more than...

Pls help me the attached access file..

Hi, i want to create a macro to send multiple emails with attachment, i have a linked data "sample attached is a table" & created a query with necessary fields required with "SOH Sale" Query & have "Mail ID Master" table with Location name in one column & mail IDs in other column. now mail...

Hi, i want to create a macro to send emails, i have a linked data & created a query with necessary fields required with "Location name" & have table a Table with Location name in one column & mail IDs in other column. now mail should get trigger from outlook receptive location to respective...

Its working.. thank you very much

Thanks, its working, but i want the stop the slab/range till 1000, any value >1000 i want it to be tagged as only 1000 or with >1000 sign

Done the same, but the issue is i have value in decimal also, so this is not possible..

Partition function will not allow the negative numbers. " The number can't be less than 0"

=IIf( [Master]![MRPNew] >=1000,">1000",IIf( [Master]![MRPNew] >=700,"700-999",IIf( [Master]![MRPNew] >=600,"600-699",IIf( [Master]![MRPNew] >=500,"500-599",IIf( [Master]![MRPNew] >=400,"400-499",IIf( [Master]![MRPNew] >=300,"300-399",IIf( [Master]![MRPNew] >=200,"200-299",IIf( [Master]![MRPNew]...

If i want to run this code in specific table, where i need to change in the given code by you

Hi, i want to added multiple Column Heading in crosstab, but its through an error only on Column Heading can be added. Basedata Row Heading1 Row Heading2 Column Heading1 Column Heading2 Value 01-Apr-17 5101 Outright 37-SPRING-2017 1 01-Apr-17 5101 Outright 37-Summer-2017 5 01-Apr-17 5101 SOA...

Hi, Kindly let me know is there any possibility where i can import from Portal( with URL) to Access 2010. i don't have any idea is this possible through Macro or SQL

This VBA code working.. Thank u..

Simple update query is working, but every day i need to do this activity for 10 fields 4 tables every day.