Update date to now () in query based on a button click?

[82280zx]

It's been a little while since I've played in access so I'm a bit rusty, Is there a way to update my queries data field called txtDateEmailed to now() on a click of a button? I can do it on a single record using

me.txtDateEmailed=now()

I've also tried this

[FRM_FilterByCompany]![FRM_FilterByCompanySubForm].[txtDateEmailed] = Now()

So the main form is called FRM_FilterByCompany and has a subform in it called FRM_FilterByCompanySubForm and in that subform it has a datafield I want update called txtDateEmailed. Thanks in advance!

[Micron]

In your button click event, execute an Update query on the table for the subform. That query would likely need criteria so that you only update records that relate to the key value in the main form record. You'd also need to refer to fields on the form(s) to get at the form values for the criteria. If you don't use criteria, you'll update all subform table records to Now().

Running action queries from code will raise prompts. If you don't want to see them, turn off warnings (but use a properly written error handler to ensure they're turned back on) or use .Execute method of the CurrentDb object. You can also execute query sql from code. Easier to use .Excecute but also possible to modify the sql property of a stored query then run that. That would not be my first choice.

[82280zx]

In your button click event, execute an Update query on the table for the subform. That query would likely need criteria so that you only update records that relate to the key value in the main form record. You'd also need to refer to fields on the form(s) to get at the form values for the criteria. If you don't use criteria, you'll update all subform table records to Now().

Running action queries from code will raise prompts. If you don't want to see them, turn off warnings (but use a properly written error handler to ensure they're turned back on) or use .Execute method of the CurrentDb object. You can also execute query sql from code. Easier to use .Excecute but also possible to modify the sql property of a stored query then run that. That would not be my first choice.

I guess I'm a bit lost on this, I'm still new with all this. So I have a Form that filters a subform query to list the data I want to use, when I click the email button it generates pdf reports for just that query... but I'd also like to time stamp the filtered data (there is a table record called "Date Emailed" to now() ) I'm able to do this on single records but I guess I'm having trouble time stamping multiple records? Or I'm not sure where to start on that.

[Micron]

Copy your tables before experimenting. Work on the originals, otherwise you'll have to deal with everything that won't work with the copied table name.
The idea would be something like this in the query sql:

UPDATE mySubformTable SET mySubformTable.DateFieldNameHere = Now() WHERE mySubformTable.CompanyField = Forms!myForm!mysubformControlName.Form.ControlNameThatContainsCompanyData AND...

You don't change the red word; you do change my references to the names of your objects. The AND is because I figure that surely more than one criteria will be required. The reference to subform controls is like
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

Best that you use query design builder I think, rather than trying to write your own sql. The end result would be similar however. If you don't know how to create an update query in Access, Google that and try something on your tables (remember to create copies of them first). If it bombs, you can dump the tables and make new copies from your backup (copied) tables.

[82280zx]

Copy your tables before experimenting. Work on the originals, otherwise you'll have to deal with everything that won't work with the copied table name.
The idea would be something like this in the query sql:

UPDATE mySubformTable SET mySubformTable.DateFieldNameHere = Now() WHERE mySubformTable.CompanyField = Forms!myForm!mysubformControlName.Form.ControlNameThatContainsCompanyData AND...

You don't change the red word; you do change my references to the names of your objects. The AND is because I figure that surely more than one criteria will be required. The reference to subform controls is like
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

Best that you use query design builder I think, rather than trying to write your own sql. The end result would be similar however. If you don't know how to create an update query in Access, Google that and try something on your tables (remember to create copies of them first). If it bombs, you can dump the tables and make new copies from your backup (copied) tables.

Thank you, I'll give that a shot, it's been probably 5-6 years since I last coded anything in access so it's mostly gone in my head =/.