Recent content by chaimribs

You can change the caption if you make it a textbox that looks like a label. If the textbox is set to not visable you could make it visable and change the caption. .visable = True .caption = ???

Unable to write in to record on delete event I'm still trying to find an answer to this unusual situation. I would really appreciate if someone one knows why this happens, how to get around this, and what else can't be done during this event.

I don't want to delete the record. I will write the date in this field. If this field is not null all my queries ignore it. If I ever need it or if I need to know when It was deleted I have the time and date.

It still doesn't work. I just put in dirty for testing. When I took out dirty both fields didn't update. It doesn't seem to make a difference whether the cancel is first or not. I you put the cancel on top other things like msgbox seem to work. I tried all diffrent setting but it would never...

I'm trying to add a date into a field instead of deleting the record. The form delete event doesn't allow me to write the date into this field but the form dirty event does. How can I write this and why doesn't this work? Thanx. Private Sub Form_Delete(Cancel As Integer) Cancel = True...

Reson for adding the second Table All the data I need is in the first table but I need to sort it base in related records in the second table. The second table is a one to many therefore I get repeated results. Is there any other way to sort from a second table without including that in the query?

Duplicate results I have a similar problem. I would like to sort a table through a relationship with another query but I dont want all the results of the query only the first time every record in the table shows up in the query.