Search results

Can anyone please tell me what did I missed in the below, it is coming as syntax error. Private Sub cmdmailppm_Click() DoCmd.SendObject acSendReport, "PPM table", acFormatPDF, "Sanjay.Joseph@plansee.com" & ";" & "Ramandeep.Singh@plansee.com", "Prabha.Tirupatiananthachar@plansee.com", , "PPM...

Thank you , I made the necessary changes as you said , the file is automatically updates every I am sending the mail as it is in my documents folder. The issue is now solved.

Hai , Thank you for the details I am using Microsoft edge (version: Microsoft Edge 44.17763.831.0,Microsoft EdgeHTML 18.17763) , and also as this is company PC my IT dept. won't allow me to add any certificate .But as I discussed with him yesterday he said the same as above(this is not a...

Dear all, The antivirus is up-to-date. The issue is still not resolved .But I am attaching you the certificate which my system is warning me as invalid .please look into this.

Hello all , With all your help & searching in google the code is completely working . But I am struck where to add this output object in the code & attach it in my mail & also how to auto delete from my desktop after sending. kindly look at the code: Option Compare Database Option Explicit...

Thanks for your time... I didn't used the code from the Link provided..but used from an another Link... found while searching.. I just needed to know what's wrong I made it in the above code... sorry again for rushing..

Can anyone help me with this please I set the edit to false in docmd object ...but still I have 2 issues now 1 the mails sent is not storing in my sent mails folder 2 and the second row is not looping properly.. sometimes working and sometimes not..

Hello I looked at the article & another which had same topic & with somemodifications , it is sending a mail for only first row . But I need it to send a separate email with the same attachment( as it contains all details) for the person assigned .How to achieve this? Private Sub...

Thank you/\.

Dear all , I have a table(name:Tasks) which has 4 columns: 1. Date 2. Task 3. Status(pending/completed) 4. Responsible person(email link) I need to send a mail to everyone only once per week if the task is pending.(Mondays to be precise) Currently I am using a report which filters only...

Okay i'll check & revert back.

Today also I am facing the same problem frequently..

Dear all , Here in India , from today morning (26-02-2020) , several times I got warning saying "This page is not secure go back to your start page" But however after sometimes it is opening .Is it secure to browse or is there any problem with the website security?

Dear all , I have created bar charts in my report using modern chart which has 3 data : 1. Month - in X-axis 2.Sum of complaints: in y - axis 3. Type of issue - category My sql cose of the query(source data) is like this: SELECT DISTINCTROW Format$([Data for issue status].[Complaint Received...

Ohh Okay ..Thank you.

Here is my databse

Thank you for your response ... No I haven't split the database

Hello , I have created a database which I have placed in a common folder for entry by two user at a time . But now when the other person opened it is showing an error message as attached.(it is not having any login form )just a table & entry form and some reports.) Could anybody please tell me...

Thank you for all your responses ...Just saw the steve bishop's video & I liked it … hope this will help me.

Hi all, I am currently reading "Access for dummies" & I also trying hard to write sample programmes as soon as I get to home from office(heavy workload you may say). But still I am not getting that logical perception to write out my own programmes but I can understand the programme written by...