Create append query to allow user to sign themselves up for project

[jzwp11]

The username is based on the employee name in your employee table; the format is the same as before: firstname.lastname

The password is the word password.

[taya621]

Oh no! What did I do???

[taya621]

actually i fixed that, I had deleted those fields in the form because i did not want them to be seen by the user. but then i got the problems attached in pictures

[jzwp11]

The code relies on the values in those control(s) you deleted. If you don't want your users to see them, just change their visible property from yes to no. If in datasheet view, just right click on the column and select hide column

[taya621]

Oh! Got it! That is why I'm afraid to touch stuff
is there a way to hide the navigation pane and restrict access to it from anyone else but my login?

[jzwp11]

There is, but I'm not sure where it is in Access 2007/2010. In Access 2003 it was in startup options. You had the ability to hide the database window (ie Navigation pane). I believe that it might be under file--options--current database, but don't quote me on that. This would hold for all users as they log in. As a system administrator, you can hold down the shift key during opening to by-pass the startup settings.

[taya621]

Got it thanks!
Do you know how I can get the assign employees for to show both the first and last name?

[jzwp11]

In the query that supplies the data, you will need to concatenate the two fields. I've done the same in the combo boxes in my examples. Something like this

t_Employees.txtLName & ", " & t_Employees.txtFName as EmployeeName