Search results

Dear All, I have the below code on a field that contains a date, I don't want user to enter a future date in the field. But unfortunately, it's not working, not sure the reason. I tried the same on lost focus event also. appreciate your advice. Private Sub...

Since you are expert user may be for you surely... but I am at learning curve..:(

how to run this CDO .. I believe I don't need to amend anything in the code... and I cannot even since I am not that expert .. to be very honest.

On thing Minty - even scheduler open access, how the event to send automatic report will occur?

Hi Minty - I believe windows schedule task option is better, will have a look into this. will have to read a bit on how to use this windows functionality. Hopefully will get through many thanks buddy

One more question: I am calculating a future date in query and sending report on that future date, if this date falls on weekend and access application is close it will not send the report. example today (11/08/16) future date (11/08/2018) which is Saturday, surely PCs are shutdown / log-off...

Hello - I checked this, the second last parameter for edit. I put no and the email is going automatically. it is asking for permission allow or deny only... will check and show you screenshot. once again thank you very much my expert friend Minty

Hello Minty, Accept my sincere apologies for yesterday, actually I left for the day from office. I have tried it's attaching PDF only when there are records else it's not. that's really nice. would it be possible that the report will be sent automatically, as of now whoever opened...

Yes my report is based on a query.

Dim Subject As String, Body As String, EmailAddress As String EmailAddress = "XXXXXXXX@gmail.com" Subject = "Action Required" Body = "Policy Due for Review" DoCmd.SendObject acSendReport, "Policies Due for Periodic Review", acFormatPDF, "XXXXXXXX@gmail.com", , , test, , , False I just want...

Dear All, First of all, many thanks to the expert users of this forum those who always helped me to develop access application for my department. Part of continuous improvement :), I need your support again and below is my question I have a query / report which will show the record...

it opens the outlook application while attaching the PDF report, can we also send the email automatically?

thanks as usual my expert friends Arnelgp and Namliam

Dear All, I have a form which has certain drop-down, based on the value in drop-down I am concatenating them to a new field. the below is the code but it is giving me an error on serial "Expected : End of statement" Me.Ref_No.Value = Cntry & "/" & Ctgry & "/" & Lng & "/" serial...

Tried but was not getting the right answer... let me check this one.

How to add new record only using append query?

Dear Expert Friends, I am done with my application, and my management would like to have charts also which I am yet unable to do since I have so much filtering such as year-wise, request type, SLA met or Not Met. I have a query which extract the information by taking year as an input...

I manage to get the pivot in the form, now the problem is that it is not saving the data labels.

I used pivot chart form and added again the label but yet it is not appearing. I don't know how to add in the report. please advise.

I have a query in my database, based on that I made Pivot table and then Pivot Chart View. I have added data labels but once I close and reopen query or filter based on page field labels are disappeared.