Using command buttons to set todays date on a table.

M

Michael B

Hi,

I am using ACCESS 97 and have been completely self taught (and only a
novice) so I am not fully aware of all of the correct terminolgy when it
comes to ACCESS.

What I am trying to do is this:

I have a form that has command buttons on it and one of these, updates a
field (Completed). What I am trying to do, is to also use this button to
update another field at the same time with todays date (Completed date).

I have been trying to set up a macro to do this but to no avail, I hear talk
about "Coding" but have no idea what you lot are talking about so I will stay
away from that for now.

Does anyone have any ideas?

Your help would be very much apperciated as this is for work and I really am
struggling.

Thanks

Michael.
 
O

Ofer Cohen

On the Onclick event of the button write the code

Me.[Completed] = Something
Me.[Completed date] = Date()

When the cursor is on the OnClick event of the button, press the button on
the right with the three dots, and select code editor, and there put this
code.
 
M

Michael B

Hi,

Thanks for that but it doesn`t give me an option for code editor. Is it in a
specific file somewhere?

Thanks

Michael.

Ofer Cohen said:
On the Onclick event of the button write the code

Me.[Completed] = Something
Me.[Completed date] = Date()

When the cursor is on the OnClick event of the button, press the button on
the right with the three dots, and select code editor, and there put this
code.

--
Good Luck
BS"D


Michael B said:
Hi,

I am using ACCESS 97 and have been completely self taught (and only a
novice) so I am not fully aware of all of the correct terminolgy when it
comes to ACCESS.

What I am trying to do is this:

I have a form that has command buttons on it and one of these, updates a
field (Completed). What I am trying to do, is to also use this button to
update another field at the same time with todays date (Completed date).

I have been trying to set up a macro to do this but to no avail, I hear talk
about "Coding" but have no idea what you lot are talking about so I will stay
away from that for now.

Does anyone have any ideas?

Your help would be very much apperciated as this is for work and I really am
struggling.

Thanks

Michael.
Click to expand...
Click to expand...
 
O

Ofer Cohen

Sorry, I'm translating it from another language, It's probably called code
builder, it the third option on the buttom.


--
Good Luck
BS"D


Michael B said:
Hi,

Thanks for that but it doesn`t give me an option for code editor. Is it in a
specific file somewhere?

Thanks

Michael.

Ofer Cohen said:
On the Onclick event of the button write the code

Me.[Completed] = Something
Me.[Completed date] = Date()

When the cursor is on the OnClick event of the button, press the button on
the right with the three dots, and select code editor, and there put this
code.

--
Good Luck
BS"D


Michael B said:
Hi,

I am using ACCESS 97 and have been completely self taught (and only a
novice) so I am not fully aware of all of the correct terminolgy when it
comes to ACCESS.

What I am trying to do is this:

I have a form that has command buttons on it and one of these, updates a
field (Completed). What I am trying to do, is to also use this button to
update another field at the same time with todays date (Completed date).

I have been trying to set up a macro to do this but to no avail, I hear talk
about "Coding" but have no idea what you lot are talking about so I will stay
away from that for now.

Does anyone have any ideas?

Your help would be very much apperciated as this is for work and I really am
struggling.

Thanks

Michael.
Click to expand...
Click to expand...
Click to expand...
 
Top