Search results

at 1: no, timestamp for Date Created meaning the first time any value was entered in a field was exactly what I wanted. at 2: thank you for this welcoming comment.

In this particular case I wanted to do it without a form. Next time that I do use a form I will try out your suggestion, because until now, in forms I used a "before update" event in the design to create a timestamp, which is much more work than what you suggest.

You are right that refreshing updates it. But that is an extra action. That I wanted to avoid, and also it is easily forgotten. Without refreshing, the existing (old) value is fixed as soon as a value is entered somewhere in the record. On the basis of your message I hoped that access would...

The "IfInsert=True" clause prevents that. Without that, it is indeed changed with every update.

I found the solution! Open the table design view. Click on create data macros. Select "before change". Enter: === If [IsInsert]=true Then Setfield Name Planned Value = now() End If === "Planned" is of course the field where I want the timestamp. The above text is partially generated in the...

In the Form Design I know how to do it, but I want to do it without a form. In the meantime I found the solution! Will describe it in a separate message.

Access creates the new record automatically, with the default values in it.

No, just now(). I tried your suggestion =now(), but the same problem occurs: it works in sofar that a date/timevalue appears, but alas it is the time that the new empty record is created, which happens automatically the moment a previous record is filled out. The new empty created record with...

I want to add a timestamp-field in a table to register when a record is first filled out. I know that this is simple in a form, but in this case I want it in a table-field. As the method with the now()-function in a calculated field doesn't work, I would like a suggestion for how to do that. I...

I applied Matt's suggestion (#14) "To left align right aligning text stick "!" in the format properties of the field in query design view". Also I found out that using "?" aligns text to the right. Does anyone know a similar way to force-align the text to center? ReinM

Hi, Just to say hello: I live in the Netherlands. My profession is nursing home physician. Experience with MS Access: intermediate. I know a thing or two about databases and access, but e.g. Visual Basic is unknown territory.