Search results

Right next piece of the puzzle. I have created a text box on my form that updates to the current date (and preferably time but I haven't worked out how to do that yet) each time a button is clicked. I have set the macro ran on the button click to run the following SQL code to update a table with...

I have sorted it through trial and error, I replaced today with now and it appears to work fine. Thanks again for your help.

Hi, I have saved the function in a module but when I try to run the query I am prompted to 'Enter parameter value' for 'today' so I'm guessing Access is thinking 'today' is a field in my table, any ideas how to resolve this? Regards, Ryan.

I am quickly learning that... These forums are a lifesaver. Thanks again for your help. I will let you know how it goes. Ryan.

Hi IssKint, thanks for getting back to me so quickly. Sounds like a good solution, my only question is how and where do I embed / save the function ready to call it with the query? Sorry if this is pretty basic, my knowledge up to this point is writing SQL queries / sub-queries. Fairly new to...

Hi all, This is my first post so be gentle. I have tried searching for what I am looking for but to no avail (if the code is floating around somewhere on here I apologise but I did have a good look prior to posting). Basically what I want to do is something along the lines of the following. I...