|
 |
access thread: Access 97 Data Spreadsheet
Message #1 by "KennethMungwira" <KennethMungwira@Y...> on Fri, 22 Feb 2002 19:39:00
|
|
Dear Sir or Madam,
I have a database which has mutliple tables since most of the information
has relationships which are one to many. I would like to put all the
information on one page and be able to update the information. For this
problem do not pay attention to the one to many relationship, I will
tackle that problem later.
Since I do not have very much knowledge in VB6.0, a programmer is linking
to the database and doing what I suggested.
Question: Can this not be accomplished in Access in Datasheet View, have
code to sort , and find.
Thank you
Message #2 by "Clive Astley" <clive.astley@k...> on Sat, 23 Feb 2002 07:10:23
|
|
Can't you make a query from the two tables and use that as a datasheet?
> Dear Sir or Madam,
>
> I have a database which has mutliple tables since most of the
information
> has relationships which are one to many. I would like to put all the
> information on one page and be able to update the information. For this
> problem do not pay attention to the one to many relationship, I will
> tackle that problem later.
> Since I do not have very much knowledge in VB6.0, a programmer is
linking
> to the database and doing what I suggested.
>
> Question: Can this not be accomplished in Access in Datasheet View, have
> code to sort , and find.
>
> Thank you
|
|
 |