Recent content by bigmac

coped your code to my database and it seams to be working , thank you , i must have done a typo before

working now , will try code on my database

Status not changing to expired neither is stat

can you show me how to do this please?

just tried this , not working, any ideas ?

hello all , can you help please ? i have a form called "sheet1" and a subform called "subform", the form has a text box called "stat" and the subform has a text box called "status", i have a record set to change all status values to "expired" on a set condition, Private Sub Form_Current() With...

thank you all , i will try a sub report

the report is taken from subform

hi all can you help me please , i have a report that shows many rows, on each row is a column showing the name of the person who signed it , and a column showing the persons signature (a png photo) , this can be signed by more then one person so i want to look at the row with the name of the...

hi all, and thank you for your input, i have tried a query update and this works fine as well ,

just thinking aloud

would an update query be better for this?

hi pat , i have changed the name of the field to " twelve month update"

there are a lot more fields on the subform, not just those two i have mentioned, but they are the only two i want to work with, the table is called "subform"