Recent content by AlliCarr

Hi David, That's great! I changed Left to Right as the 'Sub' was at the end and it worked a treat! Many thanks :) Allison

Hi, I have the following code in the form load event of my reporting form: Dim NewValList As String NewValList = "" Dim obj As AccessObject For Each obj In CurrentProject.AllReports NewValList = NewValList + Chr(34) + obj.Name + Chr(34) + ";" Next obj Me!ReportCombo.RowSourceType = "Value...

Hi Colin, I wouldn't really know where to start with updating the code. Although I've learnt loads in terms of VBA programming over the last few months, I'm nowhere near experienced enough to know what to update. I have had a look through the module and wondered whether I need to amend this...

Hi, I am using Albert Kallal's super easy word merge in my database. When I add templates I need to be able to restrict editing of the word document for document control purposes. However, this option isn't available when I add the template. Is this intended or should I be able to restrict...

I've amended the format of the form slightly so the subform is smaller and, yes, when you're on the subform it doesn't scroll the main form but I can easily manage that with the staff who will be using it. I did try your solution but when I tried adding new records in the GrantsF form they...

That's sorted it! Thanks so much Bob. :D

Hi all, I'm hoping you can help. I have recently updated one of the forms in my database which has a tab control. Within 3 of those tabs I have subforms, one of which I have just added as part of the update. The tab control is quite high so usually you have to scroll down with the mouse...

Brill! That's fixed it. Thank you so much for your help. :D

Thanks for the good advice 👍🏻 something I can work on 😊

Ooops 🤦‍♀️ when I log back on at work in the morning I’ll send another copy

Hi, I've attached a copy of the database. I've stripped out as much as I dare so as not to affect the functionality of the relevant forms. On the form that opens up first, clicking on any of the links will take you to the 'OrganisationF' form where the checklists are. There's one on the...

Hi there, I have recently added multiple checklists to my database after following the instructions on Nifty Access. Everything looks great and the correct lists are showing in each checklist sub form but for some reason, when testing, I am unable to tick the checkboxes. When I open the sub...

Hi all, I'm Allison from South Yorkshire in the UK. I started teaching myself Microsoft Access back in September 2023. I wanted to create my own database to replace the current (unsuitable) one I use at work, along with several spreadsheets. Hopefully, I can create something that works well...