Search results

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

Without digging around I'm not entirely sure. I don't believe so but if I delete it i'll have to amend a shed load of other queries, snippets of code and god knows what else that has been done to it over the years. Currently much easier to leave it be. I'm fast falling out with the current...

absolutely not sure at all. The table I changed to indexed is the same table I mentioned earlier that has an auto number field that used to be the PK, that then wasn't the PK as the table didn't have one assigned. So i reset it as the PK. To be honest that is the first table that was put in to...

Thanks for the replies - I at home now but still have RA. So, looking at the backup and the current BE files on the backup one relationship is listed as one to many whereas on the current DB it's listed as indeterminate but I don't see a way to change this. I have tried to recreate the...

Gotcha, So I created a new DB, imported the tables did a C&R and created the query with the same net result, not updatable. I can manually add the information to the second table and everything seems correct on the produced reports. So each table is independently updatable, but when I pull the...

Thanks Pat, although there are over 150 tables and and the relationship view looks like a team of spiders with ink on their feet and slid across the screen :ROFLMAO: I just can't get my head around why this query is non updateable. I've had a look at the article The_doc_Man suggested and...