 |  |  |  |  |  |  |  |
VB6 Database Program
 |
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]
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] 
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..
unfortunately, it just tells me there is an error and says "Student Name" is not an index? how can i fix this?
Ok, ive got a problem: the following is _supposed_ to search a database and show the entry based on what the code returns..
•
•
•
•
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
Haven't worked in VB6 in a long time, so not sure if something like this would help?? 
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)
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)
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??
•
•
Join Date: Oct 2008
Posts: 2
Reputation: 
Solved Threads: 0
Newbie Poster
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
|
Similar Threads
- connecting to sql server database using C++ program (C++)
- Question on how to connect MS access database to C program (C)
- Help with add function for database program (C)
- control textbox input using the mouse (VB.NET)
- "Error in linking List box with the VB6.0 database" (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Use VB6 to work with ACT by Sage with MiddleWare
- Next Thread: Printing in vb6
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
