poppy Wrote:
Good Day All

Previuosly I had the following request:
1. I want to be able to restrict to unique records. For example if a
employee with the #87 is created and the user tries to create anothe
employee with the same #, then the program should inform them that tha
# 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 uniqu
employee data. I want the program to search the sheet to find th
employee # and all the data related to that employee and dislpay it i
the FlexGrid.

I have been able to display data from a sheet in the Grid, however,
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 bee
able to display the data in the sheet in the grid. I used the followin
query:

Code
-------------------

MyMainRecordset.Open "Select * from [Sheet1$] ", MyConnection, adOpenStatic, adLockOptimistic

-------------------


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


Code
-------------------


MyMainRecordset.Open "Select * from [Sheet1$] where Persal_Number =""55""", MyConnection, adOpenStatic, adLockOptimistic

-------------------


Where the Persal_Number is a defined range.

Any help would be appreciated.

Thanks and Kind Regard

--
popp
-----------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145
View this thread: http://www.excelforum.com/showthread.php?threadid=55182