Recent content by Morphies

Yes I believe this is the same issue many users are reporting which has been resolved in the next pre release due for general release today? September 10th. Although this could be October 9th, not sure.

Yep ticked that, I'm not aware of disabling the ability and unfortunately i am the IT :)

Deffo ldb. Yes this app has been in development since ~2004. Apologies yes, trusted locations, but like I said I cannot add the network location. Even with allow network locations, It says it cannot be added for security reasons.

Morning all, Edit: Known bug. Ignore post. Maybe useful info included re batch file launcher. I seem to be having an issue where the ldb file remains after access closes. In some cases there is an accompanying access process and other times, there isn't. I've read about the issues a previous...

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.