Using command buttons to set todays date on a table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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...
 
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...
 
Back
Top