MSFlexGrid to display Excel data on VBA form

[poppy]

Good day

I have created a workbook that a user can maintain staff leave. I need help with two thing.

1. I want to be able to restrict to unique records. For example if an employee with the #87 is created and the user tries to create another employee with the same #, then the program should inform them that that # is already in use, so they should try a new #.

2. I have included an MSFlexGrid to one of my forms to display unique employee data. I want the program to search the sheet to find the employee # and all the data related to that employee and dislpay it in the FlexGrid.

The problem is that I don't see a DataSource property for the FlexGrid. How do I go about displaying this data in the grid?

Thanks for all your help

Kind Regards

[poppy]

Good Day All

Previuosly I had the following request:
1. I want to be able to restrict to unique records. For example if an employee with the #87 is created and the user tries to create another employee with the same #, then the program should inform them that that # is already in use, so they should try a new #.

I have managed to do this thru trail and error.

2. I have included an MSFlexGrid to one of my forms to display unique employee data. I want the program to search the sheet to find the employee # and all the data related to that employee and dislpay it in the FlexGrid.

I have been able to display data from a sheet in the Grid, however, I haven't

The problem is that I don't see a DataSource property for the FlexGrid. How do I go about displaying this data in the grid?

[poppy]

Good Day All

Previuosly I had the following request:
1. I want to be able to restrict to unique records. For example if an employee with the #87 is created and the user tries to create another employee with the same #, then the program should inform them that that # is already in use, so they should try a new #.

I have managed to do this thru trail and error.

2. I have included an MSFlexGrid to one of my forms to display unique employee data. I want the program to search the sheet to find the employee # and all the data related to that employee and dislpay it in the FlexGrid.

I have been able to display data from a sheet in the Grid, however, I haven't

The problem is that I don't see a DataSource property for the FlexGrid. How do I go about displaying this data in the grid?

I'm sorry I couldn't finish my post. I was called away. I have been able to display the data in the sheet in the grid. I used the following query:

Please Login or Register  to view this content.

I however want ot be able to display only data related to a particular employee. I want the user to enter in an employee num and this number will be used like this:

Please Login or Register  to view this content.

Where the Persal_Number is a defined range.

Any help would be appreciated.

Thanks and Kind Regards