steve.t
11-06-2007, 06:54 PM
Hi all,
I have a simple Personnel worksheet. Unique identifier is EmployeeNumber. Columns contain Surname, First Name, Position, Phone, Date of Birth, Address, Emergency Contact, etc. Can have a few or a few hundred records.
I would like an Add/Edit UserForm with a ListView control of the type "Report", showing (eg) Employee Number,Surname & First Name (with Headers and a vertical scroll bar), showing about four or five records and capable of scrolling through all records. Picture this Userform:
Near the top of the form, the ListView control, showing the first four(or five) records. Clicking on a record highlights the row.
Above the listView Control, three TextBox controls in a row, one each for the fields in the ListView control. Typing in any of these will find the corresponding record and display and highlight it in the ListView control.
Below the ListView control, a collection of TextBox controls of selected fields (eg Position, Phone, Address, etc). These must be editable.
Some CommandButton controls to add a new employee, save edited data, exit, etc.
Can anyone help with code or sample file. I know as much about ListView controls as I do about rocket science (I'm an HR person), so assume no prior knowledge, ie make it simple to follow please.
Cheers and thanks,
Steve T:bug:
I have a simple Personnel worksheet. Unique identifier is EmployeeNumber. Columns contain Surname, First Name, Position, Phone, Date of Birth, Address, Emergency Contact, etc. Can have a few or a few hundred records.
I would like an Add/Edit UserForm with a ListView control of the type "Report", showing (eg) Employee Number,Surname & First Name (with Headers and a vertical scroll bar), showing about four or five records and capable of scrolling through all records. Picture this Userform:
Near the top of the form, the ListView control, showing the first four(or five) records. Clicking on a record highlights the row.
Above the listView Control, three TextBox controls in a row, one each for the fields in the ListView control. Typing in any of these will find the corresponding record and display and highlight it in the ListView control.
Below the ListView control, a collection of TextBox controls of selected fields (eg Position, Phone, Address, etc). These must be editable.
Some CommandButton controls to add a new employee, save edited data, exit, etc.
Can anyone help with code or sample file. I know as much about ListView controls as I do about rocket science (I'm an HR person), so assume no prior knowledge, ie make it simple to follow please.
Cheers and thanks,
Steve T:bug: