Search results for query: *

I found my problem and fixed it. John

I have a DB that works to output stored files with MS Outlook. To make this work I had to add a Reference under VB Tools. "Microsoft Outlook 15.0 Object Library". I then tried to do this again in another DB...same computer. I also added the same Reference in VB Tools. When I Debug the...

Let's say I have a text box on a report that is 1/2 inch high and my text is 1/4 inch high. When this text box is populated the text shows at the top of the control unless it is longer than the control. Then it wraps. What I need is for the text to show at the bottom of the control and then...

sxschech Tried your code. Compile Error "Method or data member not found". And,the compile does not like Me.[Combined2].fontSize = 11 Just in case, I am using Access 2013 Any suggestions? Thanks John

In a DB I have a report that is opened from a Button. No problem with this part. How ever some fields on the report are populated from a query. I have one text field on the report called Combined2, where the text in the field can vary in length up to about 100 characters. The field is not...

Duane, See answers to the right of your questions. Can we assume you imported an image? The use of "form" in Access is something different. Yes it is captured image of a PDF file. Is the image in the Picture property of the report or is it an image control? Image properties = Picture Type...

I have imported a form into an access report and sent it to the back. I over lay this form with text fields that will contain data computed by my DB. My problem is - the text fields move depending on the screen I use. I set this up on my main monitor but if I use just my laptop screen the...

Andy and sxschech (Got the spelling right this time sxschech, sorry) OK. Here is what works. It took a lot of searching on Google to find this suggestion. Note the [highlight #FCE94F]M.SetFocus[/highlight] DoCmd.Hourglass (HourglasOn) fldrPath = "C:\TempEmail\" For X =...

Sxscheh - Same error. Thanks for the suggestion

Thanks Andy - much appreciated but the same fault occurs. I believe this may be because Access does not know when the outputs are complete. It may be the old story of not being able to do two things at once. So #1 is there code that can detect when each output is done? Can we use that code to...

Update. It seems the file selected to fail is more random than I thought. When I move the order of outputs the failing output will change. I have ganged all these outputs commands together as shown in the previous post. Set file path Do Output 1, then 2, then 3, then 4 They all use the...

I have a DB that is set to open to a specific form. This part works. One of the Command buttons on the Form outputs 4 reports to my C: drive into a Folder. Three of these "EOC", "1097A", and "PTEAR B rpt" always work. The fourth, "CLEAR", is failing with "Run-Time Error 2046. The command or...

OK. I fixed this. I don't know why it was doing it but I created a new report using the same data from the same table. I ran the code to send it to me via email and everything looked good. John

In my DB I run code that loads a table. I have a Report that sends the data from the table. In VBA I am using DoCmd.SendObject to send the report as Excel to my users. It does not arrive the same. On Label is incorrect. Troubleshooting by exporting the report from Print Preview to excel: The...

I have an Access Db on a server (a storage server not an application server). There are multiple users using the Db from time to time. In my Db I need to export reports in PDF to their C: drives - to a selected folder. If I code the export to save a file to "C:\Special" folder, as an...

I have built code in my DB to send emails to selected locations (2) with an attachment. This works and the email is sent without showing the email page. I know the email screen will show if I do not have a To: email address in the code. But I do have the Address/s in the code. Now my users want...

Andy, thanks for the feedback. I think I tried that but I am not sure. I will try it. John

Andy, that worked fine. Now I need to add a little twist to my question. I actually need to send the email to two places. With the strEmailDD you solved one. This was based on a selection that could be different every time, on the form. But, I need to send the same email to a group in box...

Thanks Andy, I will give that a try. I understand the strTo part. Why is the strName for? Thanks, John

My DoCmd.SendObject to send a report in PDF to selected individuals. And it works if I type in the email address into the DoCmd.SendObject code. However, I need my form to select the "To:" person with a Combo control. The Combo control then holds the correct email address. In the...