Recent content by Morphies

hmm, this is highly annoying! Current "send email button" code is: [code] Private Sub Command22_Click() On Error Resume Next ' Suppress error messages temporarily ' Open the report in preview mode with a filter based on

Oddly enough I already have the following in the onload event for the rptQuote report: [code] Private Sub Report_Load() Me.Caption = [Forms]![FrmQuote]![lookupCustomers] & "-" & [Forms]![FrmQuote]!

I cannot get this to output with the filename how I want it, I've even tried moving to saving then attaching like this? [code] Private Sub Command22_Click() On Error Resume Next ' Suppress error messages temporarily ' Open the report in preview mode with a filter based on

I cant answer that :LOL:. I have insufficient knowledge :( The report isn't always open, it's launched as required from the form controls.

Your diamond. FUR001-13545 was in the report caption The query that builds the report is filtering on: [Forms]![frmQuote]!

Fairly confident that is the subject section of the code.. Adding in the additional ,"" is highlighted "subject" then causes the button to do nothing atall. The button works as expected, creates an email with the PDF attachment, it's just the PDF attachment name is collecting FUR001-13545 from...

Good morning all, I'm battling with some code that takes a report and sends it out to a client, with a filename built from the [Customer ID] and

Hi Gasman, This is a multi user environment, generally up to 6 people concurrently using the system not sure on the duplicate, chat GTP suggested this tidied version Private Sub addNewId() ' Check if the Report No has already been generated If Mid(Me.[Report No] & vbNullString, 3, 1)...

HI Gasman, You'll have to excuse me, I fumble my way through these things and this wasn't an area of our system I was involved in putting together. The last number used is updated to tblreportId The next number is called from a button on our main form: Private Sub Command264_Click()...

Morning all, We are having an intermittent issue with our system We have a main form where the completion details of a record are entered. We log a number of items one of which is a report number. This is a free text field as we denter duplicates on multiple records, but when a new number is...

Well every day's a school day. Worked perfect, thanks.

Morning all, I'm trying to debug this code which worked perfectly with just the [Job Number] field as the folder name, I'm now trying to add in the customer name to the path but when the directory does not exist, the make directory function fails with a path not found error: If I manually...

Thanks for the replies, I utilised the additional string suggest by arnelgp.

Good morning all, I have a little bit of VBA that auto creates a folder for a user. I want to extend this to another area of our system and crate a folder based on a field, the only issue I have is in many cases this field will contain one or more "/" and possibly an "&" which I'll need to...

Morning All, We have an intermittent issue, which are always fun. DB is split with the back end residing on a shared network resource. We have our main table, which records are entered and then updated by users at different operations. The main table has an auto number field which is...