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.
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.
