Search results

The financial year data is input manually in the FinancialYears table. I add in the start date, end date and the financial year this relates to. So this year the start date is 01/04/2025, the end date is 31/03/2026 and the financial year format is 2025/2026. The Dlookup checks the approval date...

Would this work better with a query? Or would it be worth adding a separate save button which just runs the DLookup?

Thanks @The_Doc_Man Looking at the details in the link, the code should still work. (shouldn't it?) When the approval data has been added and the save button is clicked, there is code to check whether the form is dirty (which it would be if the approval details have just been added) and...

Never thought to check that! Looking at the affected records, yes, the other changes do work.

Hi, I have a control on a form which has an AfterUpdate event which should automatically update another control. See below: Private Sub Approval_AfterUpdate() On Error GoTo ErrorHandler 'Passes financial year ID to grant record based on approval date If Me.Recommendation = "Approval"...

That's strange, the bypass works fine for me and my objects are usually sorted by type. I have opened it in design view and saved it and now it works! It's bizarre how when I did that after creating them and changing the settings several times yesterday, it didn't work. At least I'll know what...

Thanks @Gasman, the code for randomising data worked perfectly. Here's a copy of my DB. I have had to remove quite a few forms, reports and queries as the front end file is too large but hopefully you'll still be able to take a look at the relevant section. In the front end file 'CRT Support...

Hi, I have 4 reports in my database which do not open when opened in report view. The queries the reports are based on have been updated but it was just the change of a field in one table to a field in another and the query works perfectly when run alone. The reports worked fine previously so...

Thanks @Gasman and @Pat Hartman I'll take a look at your suggestions and try them out.

I don't need to view the reports but it would be useful to save them to a folder and to print them too.

The report combobox is used to filter the reports. It is based on a query which selects all the reports in the database and then the report is opened based on the combobox value.

Hi, I'm not quite sure whether what I want to do is possible but, here goes: I have a reporting form in my database which can be used to select a list of reports and the criteria for the reports. The example below will bring up all the grants our organisation has made in a specific geographic...

I have found the information on the Microsoft Support website on how to do this but I'm a little apprehensive as in the 'Allow Trusted Locations on my network' checkbox it states that this is not recommended. Is this due to security issues?

I never thought of this! That would be extremely easy to do. (y)

How would I do that? This is the first time I've built an Access database so am really inexperienced. The information I've found online about making the folder a trusted location mentioned using the windows registry app.

The database is split into the back end, a front end .accdb file that I can use for future development and a front end .accde file for users. I know it would be ideal for me to send out a copy of the .accde file to all users but this isn't practical at the moment as the users don't have Access...

The file is on our network in a folder I set up which I would assume is a trusted location but will check with our systems administrator. There's also no option in the properties to unblock the file.

Thanks, this is the first time I've done this so all info helps!

Hi, I have just split my database and created a .accde file to send out to users. However, when opening the .accde file the warning below pops up. When I click 'open' it takes me to the log in page which is fine but I'm trying to prevent users from having to click the message every time they...

Brill! Thanks, works perfectly!