Recent content by David Bratby

Thank you gemma-the-husky! :) That is working fantastic! Dave

ok that would be good thanks. Dave

Hi, Thank you for your reply. I have attached a copy of the database. Please see the history tab on the product specs form. Thanks, Dave

Hi, Thank you for your reply. This is putting the id number in the comments box rather than the username. Also, it isn't storing the id number (username) along with the message. It is just displaying it at the end of the last stored comments message. Thanks again, Dave

Hi, I am still having trouble with this. I don't know if it was because my original post was unclear of what I'm trying to do. I have a form with a combo box with a list of user names, a comments box and a history box. I have set the comments box to append and the history box uses...

Hi, Its me again. I have a form with a comments box that appends the data and displays it in another unbound text box as a history with a time stamp using =ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0)). I think this is called column history? This is all working well. On the...

Thanks thats perfect. This is solved now! I shouldn't need to bother you again now. Thanks again for your effort. Dave

Can you make the check box values in bold text? Thanks, Dave

Thats brilliant, thank you for your help!

Hi, Thanks for looking at this. It is still not putting the allergens in if I just run the report on its own? Thanks, Dave

Hi, Thanks for getting back to me. I have attached a cut down version of the database. On the form frmProductSpecs there is an Allergens tab. And then in that Allergens tab you will see a bunch of check boxes. Some of the check boxes are duplicated under Contains and Traces of. These are...

Hi Arnelgp, I don't know if you saw my last reply? I need to get this to work when I don't have the form open. How would I go about that do you think? Thanks, Dave

Sorry, its me again. Do you think it is possible to make this work so that I don't need to have the form open to run the report? Thanks, Dave

I can't thank you enough for this. It is working perfectly.

Hi, Thanks for your help with this. It was my fault not understanding how the code works. I have this working now. Only issue is that I have other check boxes on this form that I don't want to include. Is there some sort of exclusion I can do for those? Thanks, Dave