My last question

[Thepieman]

I am a relative new comer to access and am currently developing a db for recording IT incidents which are then picked up by one of our team of engineers.

I have built in a logon screen (staff number and password required) and want to add a button that when clicked on, by an engineer, automatically allocates the engineer an incident and records his staff number in the incident table.

Can anyone help ?

 

[BLeslie88]

stLinkCriteria

when opening the new form... pass through logon # you require and then write it when you write the record.

if this field doesn't exist on the log on table, simply add it, and this is transparent to everything so far and pass it when you open form.

only thing is when creating new users, you need to autocreate this number if you are not using the PK...

 

[Thepieman]

Apologies

Sorry dont think I explained this very well. The logon screen gets you into the database, I then want to create a button on the main switchbord which the engineers will click on if they want a job. Does this make a difference ? If not can you simplify the instructions (sorry bit new at this)

 

[Ukraine82]

Check out the sample database.

If you try opening any data entry form it will ask you for user id and password.

password is password

hth,

Michael