Search results

Hi, I have been using VBA to send an email for several years now. The email is generated from a form where payments are inserted for property lots. Things have changed and I now need to include in the email information how much the payment was for each lot. For instance, owner ID number 21 owns...

Hi, I want to open a report and use one of two different queries based on the value of a field in a form. In the code below UseTop100 looks at the value of a field using DLookUp on a form. Based on if that value if True I want to use the query "Startup Letter Query-2-Top100". If the value is...

Hi, this has been driving me nuts for a day now. I have a form called Revenue Input Form. When a payment is received, the Lot Number is entered along with two other items and the amount of the payment. If the customer has an email address, there is a button on the form that displays "Email" and...

Hi, I have a report that has a sub report and that sub report has another sub report. I have in the last sub report in the On Load property the following code. Also, in the Record Source property in the Data tab of the last sub report I have that as blank, nothing is there. When I test the code...

Hi. I have a customer that has a printer that prints in both color and B&W. Because of they way her supplier charges she only wants reports printed in B&W. I've changed the default printer in Windows, (which is the one reports use), to make if only print in B&W. However, it appears that Access...

Hi, I have a relatively simple vba code but it generates the above code. I believe the problem is on the line that begins: Set rs = CurrendDb.OpenRecordset("Temp Daily Table Query for Form") What am I doing wrong? Chuck Private Sub SendEmailsX_Click() On Local Error GoTo SendEmailsX_Error...

Hi, I've been going nuts trying to get this to work. In my form, in the After Update for a control, [LotNbrX], I want the value in that control to be used to establish the value of another control on the form called [EMailX]. Note: [LotNbrX] is a text field. If I use a MsgBox to test this...

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...

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...

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...

I'm sure this has been asked before, but I haven't been able to find the solution. I’m trying to get a popup form to requery after I enter an order on another form, (the order form). The requery will then show an updated number of pending orders. I seem to recall there are some challenges doing...

Hi, I'm feeling kind of dumb this morning. I have vba code that ultimately sends and email. The .Body of the vba has line continuation characters because of the length of the message that will be in the body of the email. I need an if-then statement to include some text or not. I'm getting...

Hi, I have a continuous form that produces typically a small number of records that includes for each record a [CustomerID]. When I see the results I click on the "Find" button that successfully opens the Customer Form and finds the customer that matches the [CustomerID] from the previous form...

Hi, my customer has about 2,000 customers with their postal addresses in his Access db. He enters "order" to do work when they make a request. What he would like to do after he enters an order is to be notified that "by the way, there are X number of other customers who have pending orders...

Hi, I'm stumped. I am trying to get VBA to loop through a table that is created, but it never moves past the first record after the loop. The table that is created for the test I'm running has two records in it. The code writes the first persons contact information to the Outlook Contacts...

Hi, I'm sure this has been answered before but after a few hours of searching, I haven't found a solution. In Access I create an invoice and I then save it as a PDF so I have a record of it. That all works great. What I want to do is after the PDF is created, I want to copy the PDF FILE to...

Hi. I built an Access database for myself to help me, (Chuck), manage business projects. I gave a copy to a friend of mine, (Ed), to allow him to do the same with his projects. The database uses a frontend and a backend. As with any database, the more you use it the more you see the need to...

Hi, I have code that works well from an Access form that takes the data I want and creates a new Outlook email message. The problem I'm having is when the new email message is created, it stays behind Access. Although Windows has a flashing icon on the task bar, it's easy to overlook. What...

OK, this is driving me nuts. I have a report. The main report has two sub reports. If I run the report with the two sub reports, everything displays correctly. See the screen shot below, highlighted in YELLOW. This is on the second page of a two page report. As a simple first step, if I...

Hi, I know this has been addressed before but I can't find the solution. I have a form with a ComboBox. The ComboBox drop-down has the name of contractors and the name of "All". "All" has a value of one and each contractor has their own value, like 2, 3, 4 etc. If the value is not equal to...