I want to develop multiuser - Activity registry (database) programme in MS Access 2003
My Access programme is enclosed for your review.
The following functions should be done>>
Needed Help1: > > F_ RecordsView:=> should be used to view entered last record of the current user (which user information will come from F_Login )
Needed Help 2 :> F_ RecordsADD: =>should be used to ADD data. When open form, it should be point out the new record in table (T_Records) with form view (F_RecordsADD) and Current User ID
In order to organize the above functions, I have tried to use Form filter functions but it was not work well.
I shall be very much thankful, if you could provide guidance and advice to complete the above mentioned programme.
Thanks
Visva
Note: Combo box functions are work well in my system. So I only expect guidance to link forms with filter records (by User name < => Staff ID)
My Access programme is enclosed for your review.
The following functions should be done>>
Needed Help1: > > F_ RecordsView:=> should be used to view entered last record of the current user (which user information will come from F_Login )
Needed Help 2 :> F_ RecordsADD: =>should be used to ADD data. When open form, it should be point out the new record in table (T_Records) with form view (F_RecordsADD) and Current User ID
In order to organize the above functions, I have tried to use Form filter functions but it was not work well.
I shall be very much thankful, if you could provide guidance and advice to complete the above mentioned programme.
Thanks
Visva
Note: Combo box functions are work well in my system. So I only expect guidance to link forms with filter records (by User name < => Staff ID)
