Overwriting data

[Charlottew14]

Hi,


I have a database which 10+ people use. I want them to be able to edit their own details (password, email address) rather than having to ask an administrator each time.

I have a form (based on a query) which pulls up just their user name and current password, but I want a field beneath that to enter their new password, and when save is press, that password to overwrite the current password in the tblUsers table.

Hope that makes sense! It's probably really easy but I'm just a novice

Thank you

 

[Alansidman]

Create an update query that fires when you press the command button. Here is a short explanation on Update queries.

http://www.databasedev.co.uk/update_query.html

 

[Charlottew14]

That sounds like a plan, but does it have to be done in vba (I have zero coding experience!) - I've changed the type of query but it now wont let me base a form on it :/

Thank you for your help.

 

[boblarson]

That sounds like a plan, but does it have to be done in vba (I have zero coding experience!) - I've changed the type of query but it now wont let me base a form on it :/

Thank you for your help.

You don't base the form on the query. You create the update query and the part which sets the value would refer to the text box on your form like

[Forms]![Your Form Name Here]![Your Text Box Name Here]

(with the square brackets included)

Then you can just use a macro to run that query.