Search results

Im still waiting. Please someone guide me.

Hi Minty Thanks for the response. How Can I create a loop and send them. Can you please guide me doing this.

Hi Stopher I went thru your code. It attaches two different reports. Whereas I want to attach multiple records of one report. Each record consists of one page and clicking the send button only sends the currently opened record. Sometimes I need to send more than one record of the same report.

Hi thr I have a report showing one record at a time and a send button on the same report/record. Clicking the button sends a pdf version of the active report/record via outlook. Till here everything works well. The issue arises when there are more than one records to be sent. If we have to...

oh great it worked. Thanks alot

Yes, the button is on the report with the primary key on it and report is based on a query. This code is working perfect except I want the primary key e.g 001 to be displayed as the subject of the email so that the recipient knows the record from the subject and can easily differentiate and...

I have a button that send a report in email. The code behind the button is DoCmd.SendObject acSendReport, "", acFormatPDF, _ "email", "ccemail", , _ "Subject", , True I want the subject to take the the primary key of the opened record. How to change the coding so that it takes it...

Ok got it and done successfully. Thanks

Is there a way to create a report that mimics the form to the tee?? If yes, how to do that? So thr is no way to send a current active form as an attachment?

Someone please help me out in doing this. I can't achieve

Can u plz guide me how to do that.

I have this code but this send all the 3000 plus forms. DoCmd.SendObject acSendForm, "", "(*.pdf)", mailList, " emailaddress ", , subText, message, False just want the active form to be sent as attachment. Plz help me out.

Hi friends I have form where data in entered by data entry operators. For some reasons I need the current opened form to be send as an attachment in email. How to achieve this. Plz help me.

Thanks for the help

Thanks alot I put it in Query and it worked perfectly. Thanks once again

Sorry for being naive but do I have to write this in Query or Coding? If in coding, which event?

Hi friends I have three delivery dates in my form. Customer DD(Given by customer), Our DD(agreed by the us, the company) and Revised DD (in case the DD has been revised). But have one field in the report to show the DD. Now the logic behind is that the field should display the Revised DD but...

How can I get rid of "Could not update, record locked" error? My DB is split into be and fe and record lock is set to No and shared is set to yes. Please help, I tried to find solution online and in the previous posts but in vain.

Thanks Working

Hi friends I have a form where a particular field is required not to be edited once data is entered into it. It means user can enter the data for the first time but after that, he cannot edit/change it. I know about record lock property but that locks the field to enter the data even for the...