Recent content by AlliCarr

So, I have updated the table to set 'Allow Zero Length' to No and I have run a query to identify instances of the field which already had a zero length string and none were found. I have tried everything in the thread in terms of using Is Null and NZ and in various different ways and I still...

Thank you all for your responses. I have tried the easier ones but still having the problem. When I have checked the properties of the column in the table the 'Allow Zero Length' option is set to yes so I think that will be my problem. I'll update this later today once everyone has logged out...

HI, I am trying to save myself the work of creating 2 reports and 2 separate queries for the sake of one field. On one of my forms, I have added a button to export a report of the information on the form. The report has a field 'ManagementDeliverability' which won't always be completed in the...

Hi, One user of my database is getting the error below when clicking a save button. The code behind the button sends an email and I wondered whether this was because the button had been clicked twice which would have caused the code to try running when it already was. However, I have tried to...

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.