Recent content by lwill

Hi CJ_London, This is now doing exactly what I need it to do. The after update macro was the final piece of the puzzle. Thank you so much for your help on this one. It's made the whole process that much easier. I appreciate the help and knowledge.

Hi CJ_London, Your first method is working really well and displays the right data in the datasheet. The only problem is that when I hit submit it doesn't update the table in the datasheet. It does if I close and reopen it, but doesn't do it live. Is there an onClick even I can do to update...

I was playing with some scripts from another question and this one started working now. See "Split form not showing bottom pane when form is in data entry mode" in the forum Thanks for your help

Thank you CJ_London. I'll let you know how I go.

Hi Ranman, Can you point me in the right location for this? I'm not sure what kind of update query I need to run. Thanks Luke

Thank you CJ_London for your response. I'm a bit new to access, so can you explain regarding building my own? Build my own form? or Data Entry mode? Thanks Luke

Hi all, I am creating an Access DB, but I would like it to include a modified by column in the table data. Is there a way to have this automatically populated on modification? Thanks Luke I've put a hidden field in a form for this, and tried the following macro applied to the form: Private Sub...

Hi all, wondering if someone can help me with this... I seem to be hitting my head against a wall here. We have a split form setup that links to a Table. We've enabled data entry on the form because we don't want it to add a row until the submit button is pressed. But when data entry is...