2 Replies - 1220 Views - Last Post: 13 August 2013 - 04:05 AM Rate Topic: -----

#1 prashanthi_poonam  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 13-August 13

store multiple values in single field in access table through vb6

Posted 13 August 2013 - 01:24 AM

we have an access table named Teacher and we have three fields in it which store the name of the book ,Date_of_Issue and Date_of_Return .We want to store multiple values for the book name, Date_of_Issue and date_of_Return for individual teacher.
how can we enter more than one book name in that field using vb 6.0

Is This A Good Question/Topic? 0
  • +

Replies To: store multiple values in single field in access table through vb6

#2 sathish_v  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 2
  • Joined: 13-August 13

Re: store multiple values in single field in access table through vb6

Posted 13 August 2013 - 01:40 AM

View Postprashanthi_poonam, on 13 August 2013 - 01:24 AM, said:

we have an access table named Teacher and we have three fields in it which store the name of the book ,Date_of_Issue and Date_of_Return .We want to store multiple values for the book name, Date_of_Issue and date_of_Return for individual teacher.
how can we enter more than one book name in that field using vb 6.0


hi you can have multiple text box which insert into same field or u can use ".update" which will update with existing text and new text
Was This Post Helpful? 1
  • +
  • -

#3 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 299
  • View blog
  • Posts: 1,768
  • Joined: 26-March 09

Re: store multiple values in single field in access table through vb6

Posted 13 August 2013 - 04:05 AM

View Postprashanthi_poonam, on 13 August 2013 - 08:24 AM, said:

we have an access table named Teacher and we have three fields in it which store the name of the book ,Date_of_Issue and Date_of_Return .We want to store multiple values for the book name, Date_of_Issue and date_of_Return for individual teacher.
how can we enter more than one book name in that field using vb 6.0


Personally I would look at the design of your database instead of trying to do what you're suggesting.

As an example, have the books in a separate table, with a Teacher ID field in it, then set the teacher ID against the book, this way you can have a one to many relationship between the teacher and the books (i.e. one teacher can have many books).
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1