Recent content by Damo1412

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