Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

  Return to Index