moved: Update record dialog with exact confirmation on which fields to be updated?

[tmc]

message to mods: please don't delete as a duplcate post again - i only moved it here because i put the original post in the wrong section. I explained there that i have moved it here. I really need help with this and deleting it won't help! thanks!
Hello,

I hope you could please help. I'm setting up a simple access programme for work but one particular problem i'm stuck on.

Basically before i update a record with persons employee id, work location, duties etc i have got it to come up with the 'you are about to update record, ok to continue' dialog box.

Thant's fine, but what would be really usefull is if i could get a dialog box to actually show what details exactly are about to be changed i.e. 'you are about to update record with employee: Smith; location: office; duties; cover, ok to update?'. That sort of thing.

I'm really stuck on this one,and would really appreciated some help.

Another problem i'd also like help with please, is that on my report form when entering details i only have the employee id entered for ease of use. However, i'd love it if as soon as the employee id is entered then the employees name is just displayed somewhere on the screen to check correct id has been entered.

However i can't think of a workaround as access only recognises the id number that has been entered after i have pressed the button to update the record and not immediately after filling out the id field and prior to entering all other fields.

Hope i've explained myself ok, i've honeslty tried googling all over but i'm limited in access experience and have found myself at a dead end.

Please help, and many thanks for your time.

Tom.

 

[DCrake]

From a users point of view I would find this more of a hinderance. You are telling them something that they already know. How do they know, beauce they have just changed it. I don't know how busy your screen is but lets say it has 20 controls, there is a possiblity for at least 20+lines in your message box, a more simple aproach would be to tell them that the changes they have made are about to be updated.

If they user was very diligent and actually read the impending changes and realised one was wrong then they would have to re edit it.

David

 

[tmc]

Dcrake,

Thanks very much for your reply - i understand what you are saying and my form has only 8 controls but one of the controls is the employee id number, lets say No: 14. Then i''d like the dialog box to say - 'about to update No: 14 - John Smith' without the user having to type john smith into the form.

Another reason is that i'm trying to mimick an old dos system as much as possible. People don't like change around here!

I understand it might not seem ideal to you, but if you could help with a few lines of code i'd really appreciate it!

many thanks,

Tom.

 

[DCrake]

How is the user selecting the employee id in the first place. The best method is to use a combo box based on the employee table. You can also include extra columns but set their widths to zero effectively hiding them.

Now lets say you have a control on the form that says Employee Full Name, which is real terms is made up ofr their title forename and surname. All of which are individual fields in your table.

In your underlying query for the combo you would have a column

FullName:StrConv(Trim(fldTitle) & " " & Trim(fldForename) & " " & Trim(Surname),3)

Then on the after update of the employee combo box you can code

Me.TxtFullName = Me.CboEmployee.Column(1)

And when you come to display your msgbox you would code

MsgBox "You are about to update employee no " & Me.CboEmployee.Column(0) & " " & Me.TxtFullname & "."

David