Search results

Hi, I have a database with a large number of reports based on a template. Thanks to help previously provided by this forum (https://access-programmers.co.uk/forums/showthread.php?t=288559) I have managed to link all of the images in the template so I can dynamically change or update them as...

Thanks, I've got it now

Thanks Ranman, I'm not completely sure what you mean. Do I add a new Field Name to the "Client" table called "RGB" and for the relevant client enter this as "255, 153, 255" or whatever colour I want it to be. Finally change the VBA on the forms to read: Me.ClientURNComboBox = .colour

Hi, I have developed a database for work with (a lot) of help from this forum to record and process jobs. As the database has developed, there are now a lot of forms for different inputs / searches etc. On quite a few of these forms, I have created a sort of conditional formatting using VBA...

Hi, I know that this is an old post but I've just come across it and would really like to implement this into my database but I am doing something wrong, I'm just not sure what. I have created a new database with a table called "Table1", a form called "frmScheduler1" and a module called...

Thanks for the help. You have laid that out so that it is very clear and easy to follow

Hi, I am running an Access 2013 database where the user can export certain reports as a PDF. I would like to set the name of the PDF to a "user friendly" name such as "Additional Works Summary" instead of the report name of "RClientAdditionalWorksSummaryV2" but still allow the user to chose...

Hi CJ_London, You're right in saying that JobDueBy is a date however I chose this field at random out of all of the fields I would like to use this function on. These fields include reference numbers, text and check boxes.

Fantastic, thank you so much

Sorry, I missed the End If over when I copied the code. It's actually part of a nested If...Else but only copied the relevant section over. I'll have a look in to lostfocus and setfocus and have a play around with them. Thanks

Hi, In our database, we have a number of reports based on the same "template". These reports include standard images such as company logo, tag line, accreditations etc. Is there a method to automatically update these images in a similar way that SSI works in html? Thanks

Hi, I would like to move to a specific tab stop location after update if the current field is left bank. I have tried using the code: Private Sub JobDueBy_AfterUpdate() if Me.JobDueBy = "" then DoCmd.GoToControl Me.JobsLive Me.Refresh End SubBut if the user presses "Tab" or "Enter" the...

Hi Brianwarnock, Thanks for the feedback. Unfortunately the query was created using Access' query design as I know nothing about SQL and merely posted the code in case it assisted with resolving the problem. To hopefully explain the layout, this is the form that the user uses to select the...

Hi BlueIshDan, Whilst playing around in between your posts I realised that I had done something that affected the query so I re-created it from a back-up and have tried both of your criteria again. Using either of your codes, entering the criteria in any field works perfectly apart from the...

Hi BlueIshDan, With my code, if the user enters the criteria in any filed the search works fine but no matter what they enter in the address field (full or part address) the result is always blank. Unfortunately, with your code entering any address produces no results but entering any other...

Hi JHB, Unfortunately that still shows every result if the "[Forms]![SearchJobs]![SearchAddressLine1]" field is left blank. I also tried using: [Forms]![SearchJobs]![SearchAddressLine1] Is Null Or Like "*" & [Forms]![SearchJobs]![SearchAddressLine1] & "*" but this had the same result.

Hi, In a database am building, I want to run a query with the criteria dependant on which field the user populates in a form. The form has a number of fields that the user can select from including our reference number, the client's reference number and the site address. I would like the user...

Got it. Thank you once again so much for your help.

Sorry, I've just realised that I copied the wrong code there. As a trial, I cut the code down to the minimum. The actual code I'm having problems with should be: strOutputPath = objTempFolder.Path & "\""Our Quotation Ref "" & [Forms]![CreateNewQuote]![EnquiryRecordNumber] & "".pdf"""I also...

Sorry to be a pain but I've just got just one more thing I've found when playing with the code. There's nothing wrong with the code, I'm just not sure how to modify this one. When the quotation opens it runs the code: Reports("Quotation").Caption = "Our Quotation Ref: " & [EnquiryRecordNumber]...