Search results

If I manually open the report, it’s fine. It’s the PDF that is created that’s the problem. The PDF’s file name is correct but the Quote Nbr in the PDF is incorrect. The code to create the PDF and the code to append the PDF file name to the Attachment Table is in my code. I just can’t figure out...

I changed the code per your suggestion. No change. The display name of the PDF that's created is accurate but the data in the PDF is from a PDF that was created earlier. Below you see the Quote Nbr that ends in 50-50. If you look at the second screenshot that I captured by clicking in...

Hi Bastanu, The LNameLookUp and ShowPDF were after a ' (remark) so they were remarked out. I will look at your revisions after I post this and give you an update. Thank you! Chuck Private Sub PrintPreviewQuote_Click() Dim DateForQuote As String Dim DestPath As String Dim...

Pat, I'm sorry for my delayed response, I was called away. I'm not familiar with FollowHyperLink although I looked a few examples. Can you please shed some light on that vs. what I have in my code? Also, the code I provided is from a command button on a form so I don't know if that addresses...

Hi, I'm stumped. My code does two things. 1. It creates a PDF copy of a report and places that in a folder 2. It adds to the [Attachments Table] a row for the customer ID, the Job ID, the Hyperlink and the RawFileName which is the text of the file name When the code runs, it displays the...

I figured it out. I don't know why but early in the code I run a Macro that runs a batch file called, "delete_Invoices.bat". That batch file deletes pdf files in a folder. I had previously added, "Dim OutputLocation As String" and set it to "C:\HOA\Bulk Invoices". I remarked the macro batch...

I appreciate everyone's input. For sake of clarity, I've removed all of the MsgBox entries except the one that begins with 110. If I leave that MsgBox in the code, (not remarked out), I get both records. If I remark it out, I only get the second record. I have a hard time believing it's a...

One update/observation. I can see in Windows Explorer when the first PDF is created and then I can see when the second PDF is created. Then, the first PDF is deleted. I can't figure out what would be deleting it!

Hi, here is all of the code. Private Sub Command9_Click() On Local Error GoTo Some_Err Me.MoveToX.SetFocus Me.Command9.Visible = False Me.ClsFrm.Visible = False Dim MyDB As Database, rs As Recordset Dim strBody As String, lngCount As Long, lngRSCount As Long Dim...

Hi, they have different BindNbr's. The first one created is 14 and the second one created is 15. If only one is created, it's 15.

Hi, I have a VBA loop that cycles through records, creates a PDF file and outputs the report to a folder. I'm testing on this database and there are only two records in the tables. i have several MsgBox lines in the code below to help me figure out what's going on. Each MsgBox begins with...

Pat, that's excellent and helpful feedback! Thank you for taking the time to write this up for me. You do an awesome job, amongst many others. I appreciate it!

Thanks arnelgp. I found that by putting in the "Close" event for the popup form, "Forms!MainFormName!Requery", it saves the record. It works but do you feel there's an issue doing it this way?

Follow on question. When I make a change in the popup it does make the same/updates the text box on the Detail Form. When that change is made, that form is "Dirty', it isn't saved. I've tried various things but I can't figure out once I close the popup how to save the Detail Form. I know the...

OK, I got it working. When I double-click on the text box in the Detail Form I used TempVars to create a snapshot of the text in the text box. When i'm in the popup form, and when I start to close the form, I compare the TempVars value from the Detail Form to the text box in the popup form...

Sorry dbg, I do that before I open the popup.

OK, both suggestions have been helpful. Based on dbg's suggestion I added a Command button on the popup form to save the record. That's all it does, I wanted to see if it could save it before I closed. it. When the text box had a small number of characters, it saved it without any problems...

Hi, I have a form called "Detail Form" with a text box on it. The underlying field is a Long Text. The text box is formatted as Rich Text. If I double click on the text in the text box, it opens a popup form that is based on the same table as the previous form that holds the text box. The...

Sometimes there might be an exception. For instance, all of the jobs are in the same subdivision, and they can get more done. It serves the customer well. Thank you for contributing.

Here is the screenshot. The order entry form is on the right and the popup form is on the left. On the right, the order entry person gets information about when the customer wants the job done. As she begins to enter the order on the right, she can look at the pending jobs on the left and...