Recent content by anandan.cr@gmail.com

Sub Salary_Slip_Email(fileName As String, ToEmail_ID As String, EMPL_NAME As String) Dim Email_Obj As Object Dim Email_Configuration As Object Dim Mail_Configuration As Variant Dim Email_Sub As String Dim Message_From As String Dim Message_To As String Dim Email_Cc...

While clicking on button "Email Salary Slip" as attached in *.mdb file we are getting the following error (Snapshot attached) Description: The System cannot find the file specified.; Error Number:-2147025894; Source :CDO.Message.1 Unable to send Salary Slip Email in PDF format with password...

Done ,tried with setting in CDO Email Tester it work with setting : SMTP PORT : 587 SSL : FALSE \Please suggest the VBA code to change the SSL Setting to false or Please correct the code to send email using SMTP PORT : 587 , SSL : FALSE Attached is the sample

Dear Sir, The Below mentioned VBA Access Code is working in Windows 11 O/s but the same is not working in Windows 7 O/S. Similarly respective setting of Email Accounts of different Operating System i.e Windows 11 O/s & Windows 7 O/s is attached here as Image. Unable to send the Email , We are...

Thanks for your instant reply, but I want if both user name and password is successfully Entered then on ENTER KEY press open Main Form

On Enter Key Press , check the validation if User Name and Password is perfect open Main Form Kindly suggest the VBA Code. File attached.

Requesting you to please provide me VBA Code

Dear 561414 How to get all the dates of the month after selecting the certain month and weekdays? VBA-Access: Selecting the weekdays "Combo box" Select: Weekdays (Eg: Wednesday) Input the month "TextBox" (Input Receive Eg : FEB-2023 (MMM-YYYY)) RESULT Get all the dates : "List Box" Display...

In Ms Access (VBA) , How to get all the dates of the month after selecting the certain month and weekdays?

Received your File with thanks , In your attached file it is working. Pls find my attached File. It is still not working .

As Suggested , I have changed the code , still the same error received. Syntax as follows : Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm, "Form1"

Dear Sir, In MsAccess 2007 I have two Forms, Form1 and Form2 The code written :- Dim stDocName As String Dim stLinkCriteria As String DoCmd.Close acForm, "Form1" stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria I have also used the following syntax :-...

arnelgp, Awaiting for your reply

Perfect, Adding one more query : Table : dbo_Menu_Sectors_Mast Please create a Form based on above mentioned table. Please suggest : VBA CODE On Modification of any form's Field , It will store modification Data and Time in the Filed dbo_Menu_Sectors_Mast!Menu_Modified

I Appreciate your efforts and agreed in your suggested case All data is in one page , But for creating One Report I need create 3 Sub -Reports. I am Looking for the Solution in one Report