Search results

Thank you June7 and Cronk! The code works perfectly with the minor fix from June7. For some reason, the simpler version from Cronk caused the attachment to be added repeatedly until the db froze. Maybe it needs an Until clause? Anyway, I'm afraid to ask an additional question... is there a...

'I'm getting a Compile error on "Exit Loop": Expected: Do or For or Sub or Function or Property. 'Here is the code as it stands... Private Sub txtEnvDocsSent_DblClick(Cancel As Integer) On Error Resume Next strTodaysDate = Date Dim OApp As Object, OMail As Object, Email1 As String, Email2 As...

Hi all, I'm trying to attach a invoice (pdf) to an email with vba and I want the code to grab the invoice regardless what else might be in the document name, such as "Invoice 1" or "Invoice approved", etc.. The invoice is always a pdf file. This code works. It grabs the invoice as long as it...

Galaxiom, Why would each user need a separate table? Am I going about this all wrong? Brando

Check boxes are just so intuitive for users! Okay, so I've added a check box to the table data called "Select", and I've checked the box in each record. So when the subform displays the search results, all of the records will be checked (and factored into the average). The user will have to...

Paul, The list of records that result from the search (which include a sale price) need to be looked over by the user who will then select a few of them. The user will then click on a command button that will average the sale prices of the selected records in a text box. Ideal would be to have...

I've searched and searched, but not sure if I'm using the right search terms... I have a search form that looks up records in a table and displays them on a subform (maybe I should display them in a listbox instead). Anyway, I want to be able to look down the list of results and click on...

Thank you all! It was as simple as CJ London suggested. The data type in my table had been set to text. Once this was changed to Number and "#,###" was put in the format property, it worked perfectly. AB

Hello all, I have a user input form with a text box that stores a number. When the user inputs the number, I'd like it to display the comma separator (e.g. "1234" becomes "1,234". I've tried putting "#,###" and "#,##0." into the format property of the text box, but I still get 1234. I've...

Simple perfection! Thank you!

Hello, Thank you in advance for your help. I have a Main form with a combo box that pulls names from a table. Alongside the combo box is a command button that opens a form which allows the user to edit the names in the table. The problem: When a user edits a name and closes the edit form...

I wasn't able to get the above to work, however, my problem was solved when I simply put spaces after each predetermined phrase. For example: .Body = FirstName & "," & vbNewLine & vbNewLine & "Please attend the meeting" & vbNewLine & vbNewLine & "Thank you," & vbNewLine & signature Became...

Thank you for your help on this. I'm a little embarrassed to post the code at this point, but this was my best effort at understanding Hans' solution. Private Sub cmdEmailHO_Click() On Error Resume Next Msg = "<b>Hello " & "John Smith" & "</b><br>" & _ "<i>How are you?</i>" Msg =...

I hadn't seen that one, however, it looks like it was incomplete. I tried it anyway with no luck. The reason I want to set the font is because the user may want to add to the body of the message. But when typing on the end of the words that are auto generated, it uses a different font :(...

Thank you. I found that one too, however, I couldn't get it to work. I'll try more variations.

I've searched several formus with no luck. I would like to have Access launch an Outlook email with a specific font (Arial). How could that be accomplished? Here's my code: Private Sub cmdEmailAO_Click() On Error Resume Next Dim OApp As Object, OMail As Object, signature As String, Email As...

It works perfectly. Thank you both for your time! :) Brando

Thank you Paul. I put it in the row source and the concatenated value appeared in the dropdown of the combo box. However, as with the original post above, I'm trying to have the user's selection appear in the combo box after they've selected it - with both the number and name appearing. As I...

vbaInet said "This will go in the combo box's Row Source." I wonder if someone could explain how to put it there considering the Row Source has only one line in properties? Thank you in advance. Brando

Good news! After weeks of postings and research, I have figured out a way to code a back button! It's not elegant, but it does the job. Here is the code: Private Sub cmdBack_Click() Dim strCS As String Dim strCS2 As String strCS = "=(""\\Files\Admin\Library\" & """)" strCS2 =...