B
Brad Pears
I am working on converting an old Excel application to an Access 2000 app.
In a nutshell, the users have been used to entering hours for "clients" in
certain categories. The client names were listed down the page on the left
(cells 1-???) and the categories listed across the top (cells A->???).
They have asked if they can still retain this type of entering as they are
used to it and it's fast...
I could ask them to tell me exactly what each category will be and directly
enter them into the table (and create a few extras as new categories are
needed), but I would like to be more generic so that they can add categories
as they see fit without me having to modify the table, forms etc...
I would like to use some kind of a grid control that looks similiar to an
Excel spreadsheet to list the client names down the left side and list the
appropriate categories across the top. Then they could just tab through the
categores for each client and enter the appropriate hours. However, I have
never used a grid control and am not sure how much work is required to load
and save this type of data into a relational database format (Access of
course)...
Have you ever done this type of thing before and do you have any
suggestions?
Thanks,
Brad
PS... I have used DBgrid in VB before but did not really have a lot of luck
with it....
In a nutshell, the users have been used to entering hours for "clients" in
certain categories. The client names were listed down the page on the left
(cells 1-???) and the categories listed across the top (cells A->???).
They have asked if they can still retain this type of entering as they are
used to it and it's fast...
I could ask them to tell me exactly what each category will be and directly
enter them into the table (and create a few extras as new categories are
needed), but I would like to be more generic so that they can add categories
as they see fit without me having to modify the table, forms etc...
I would like to use some kind of a grid control that looks similiar to an
Excel spreadsheet to list the client names down the left side and list the
appropriate categories across the top. Then they could just tab through the
categores for each client and enter the appropriate hours. However, I have
never used a grid control and am not sure how much work is required to load
and save this type of data into a relational database format (Access of
course)...
Have you ever done this type of thing before and do you have any
suggestions?
Thanks,
Brad
PS... I have used DBgrid in VB before but did not really have a lot of luck
with it....