modify button

[imintrouble]

Hello! I have created a login form, where a user enteres their user name, e-mail, user type (E.G. Student Employee) then, using two other text fields, I entered into the control source property for both, date() for the first to show the date the person was on, and format(Now(),"hh:nn:ss") to display the current time in hours:minutes:seconds. In the table this information is to be entered in, I wish for the date and the time to be put into their respective fields, Date_Worked and Strt_Time.



I did have a button which used on-click code to take the time and the date from the two text fields on the form and input them into the table as I wished. However this created a new row with only the time and date entered. Trying to get over this problem, I had to make sure that all of the rest of the information, id, username, email, and usertype were also input into the table. Unfortunatly this would not be allowed because the form already enteres the information from these text boxes into their pre-defined fields of the table, causing my code to error out, and only the information besides the date and time to be entered.


My question is this: Instead of having a log-in button which enteres all of the information, would it be possible to instead have the button modify the row for this particular id/user combination? Or would it be possible to simply use the same onclick code I did before, but instead of using the same control source for the id, username, email, usertype which inputs that information into their default fields of the table, change it to something else, not sure what, but do this so that it will only be my button which takes the information in the form and inputs it to a specified field on the table.

Any help at all would be most welcome. I've been working on this project for a while and am, quite frankly getting tired of it.

[June7]

Use the DefaultValue property of textboxes instead of ControlSource to set date and time of new record. Set the ControlSource to the field(s) data should be saved to. If you don't want users to be able to change these values, set Locked property to Yes. No need to 'save' record, just close the form to commit record to table.

[imintrouble]

thank you so much, you have no idea how long this has taken me >.<; Another question that, if asnwered would be useful, is how I can make sure that when someone is done using the database to enter the current time into a field named End_Time. This can be done from when you close the database or when a button is clicked. Thanks again!

[June7]

Only time, not date? Two ways.

1. If the form with the button has the End_Time field in its RecordSource and the current record is the one that needs update, simply code in the button Click event: Me!End_Time = Format(Now(),"Medium Time")

2. Use an UPDATE sql action.

[imintrouble]

two questions, what is a recordsource, and how can i check to see if End_Time is there and how can I change it if it's not there.

[imintrouble]

never mind, i figured it out :P thanks so much, this project is just about done