472,119 Members | 1,502 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

Need Help: Displaying Records

Hi there, good day! i need some help in displaying my records,,, my assignment is i have to display a database records in a labels.

Its like this in my database i have a table called "SUBJECTS" that is consists of 4 fields, SUBJECT CODE, SUBJECT, TYPE, & UNITS, i have input their all the data for my fields that have unique identifier. My problem i dont know how to display in my form.

No in my form i have several of labels. in each fields like "SUBJECT CODE" i have 14 total labels and the same with my SUBJECT, TYPE, & UNITS. my problem is i dont know how, my professor want that if he click the button namely "GET Subjects" all the subjects must be displayed in a specific labels, if i have 10 subjects, 10 subject code, 10 type & ten units, the output must have 40 labels. can u teach how? i have this code: but am not sure with it:

Expand|Select|Wrap|Line Numbers
  1. If cboSubject.Text = "Tourism" and cboSem.Text = "1 sem" and 
  2.    cboYear.Text = "1st year"  Then
  4. SELECT * From dbTimeSchedule.mdb WHERE PrimaryID Like "T0101*"
(this is the part i'am having difficulty, i dont know how i willl be able to
do display all the records in a specific labels.)

i hope you can help with my project vb masters... hoping for your reply and ideas!!! thank you
May 8 '07 #1
0 1139

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.