Search results

Hi Minty thanks for all your help so far, I've tried lots of combinations with no success. If I understand correctly I am trying to create a procedure whereby the invoice file is saved locally (with the unique invoice number as part of the file name) then I guess there is a second part that...

Many thanks Minty for your swift reply I don't quite get these 2 variables: Variable_Attachment = ? Variable_savepath = ? Where do I call the report Invoices2 and turn it into a PDF? Are you saying I need to save the report in a location and then attach it?

OK I have sussed how to: attach a report as a PDF Change the Caption so it adds the unique invoice number to the name of PDF file Add the Invoice number to the Subject of the email Get the TO email address from the customer record Get the First Name of the customer and write the email Dim...

Brilliant! It needed a slight adjustment as when I start typing where the cursor was placed it pre-pended it to the beginning of the second line. So here is the finished code that works: Private Sub Command83_Click() Me.Note = Format(Now, "d mmm yyyy hh:nn") & " - " & "(" & DLookup("[login]"...

Thanks AccessBlaster but that doesn't really help me. I have a Memo field called Notes that can hold a few lines of text I need it to do the following: 1. Copy all of the current contents (this works) 2. Paste all of the contents inserting a new line of text at the top (this works) 3. Put...

I have created a button that takes the contents of a memo field and adds a new line of text at the top with the date, time and initials of staff member. So far, so good... However I want it to end with the cursor ready at the end of the first line (to type the note) The following code does...