943,782 Members | Top Members by Rank

Software Development > Visual Basic 4 / 5 / 6 > VB6 Database Program
Ad:
Permalink
May 12th, 2004
0

VB6 Database Program

Expand Post »
Hello, I don't know if this is the right place to ask this, its sort've a big collective question on how to go about building a database program =p. Yes, it is a project for school, I've got about a month to do it, I'm quite new to VB and so I'm trying to get as much help as possible :eek:

Pretty much, the program is going to be a program that will the teacher of a class to input data about each student, - course book numbers, telephone, e-mail, name, grade, etc. as well as have a sign out system that will allow the students to sign out equipment. I've got ideas on how to do it, but its applying it which I'm quite lost with.

I've tried a lot of these following things and been quite unsuccessful.

A) Can i use a .mdb with a flex grid? if so, how? I haven't been able to do it- the Data control doesnt seem to work the same way as an ADODC control.

B) Are there ways i can add search functions, add buttons, delete buttons, sorting functions, edit buttons to a DataGrid to make it more usable? OR if A) is possible, can I do so with FlexGrid?

C) In my access database if I have say 5 column headers, and I only want 3 to show up in a main table on the program but all 5 to show up on a "More Info" form can I do so?

D) Related to C: Can I create a button that will allow me to select an entry from a FlexGrid table and have it take the user to a new form by clicking a button which will display more information?

E) Ideally, I would like to input an "admin" section in which the user could edit things about the program (ie. list box contents, database contents, etc) but the database couldnt be modified unless in that admin mode.


I know its a lot, but I'm sure someone knows of some tutorials that could help me or someone could walk me through it themselves. I'm sure I'll think of more to ask hehe. I've got about a month to do it as I mentioned earlier, and I haven't got a clue how long it will take me :-|


Thanks for any help you can offer,
Brodin


[EDIT] I read the sticky you guys have on this forum, I have tried a lot of this, I'm still really new to VB and the only other language I've done is HTML, which doesn't really help anything [/EDIT]
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Brodin is offline Offline
2 posts
since May 2004
Permalink
May 25th, 2004
0

Re: VB6 Database Program

due to popular demand, im back!

Ok, ive got a problem: the following is _supposed_ to search a database and show the entry based on what the code returns..


Quote ...
Private Sub cmdFind_Click()
Prompt$ = "Enter the full (complete) Student Name."
SearchStr$ = InputBox(Prompt$, "Name Search")
datstudent2.Recordset.Index = "Student Name"
datstudent2.Recordset.Seek "=", SearchStr$
If datstudent2.Recordset.NoMatch Then
datstudent2.Recordset.MoveFirst
End If
End Sub
unfortunately, it just tells me there is an error and says "Student Name" is not an index? how can i fix this?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Brodin is offline Offline
2 posts
since May 2004
Permalink
Jun 2nd, 2004
0

Re: VB6 Database Program

Haven't worked in VB6 in a long time, so not sure if something like this would help??
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Private Sub Search_Click()
  2. Set dbindex = td.Indexes(0)
  3. dbrecordset.Index = dbindex.Name
  4. SearchForm.Show
  5. End Sub

After the user dismisses the Search… dialog box, we retrieve the text to search for from that dialog
box’s text box and place that text in the record set’s Seek property, along with the command “=�, which indicates we want to find exact matches to the search text:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Sub SearchTable()
  2. dbrecordset.Seek "=", SearchForm.Text1.Text
  3. ...
Team Colleague
Reputation Points: 211
Solved Threads: 27
Master Poster
Paladine is offline Offline
793 posts
since Feb 2003
Permalink
Jan 6th, 2005
0

Re: VB6 Database Program

hi there i just want to ask you guys if theres already a newest SQL server 7.0 which is im quiet comfortable of using it rather that MS ACCESS. because of its efficiency!!! is there any??
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ZERO COOL is offline Offline
2 posts
since Nov 2004
Permalink
Oct 5th, 2008
0

Re: VB6 Database Program

Hi..I saw your post.I'm making a similar program and i'm really desperate coz ihave less than 2 weeks to do it..can u send me a copy of your program,if its ok. Don't worry, i'lljust use it as reference..here's my email voxviennasierra@gmail.com
Reputation Points: 10
Solved Threads: 0
Newbie Poster
voxviennasierra is offline Offline
2 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Use VB6 to work with ACT by Sage with MiddleWare
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Printing in vb6





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC