I am looking for someone to tutor me on database programming in Visual Basic 6.0. I have done plenty with SQL in ASP pages and other dos languages but not really in VB yet. I need to work with databases and tables in VB 6.0 and after reading many times on it, I get so confused with ADO, DOA, etc. And I assume I will be using an Access database because its not going to be setup to have MSSQL or anything else that big installed.
Although there are many reasources on the internet, I would much rather pay someone to help me get started and ask some direct questions along with making up samples for me to follow. For the questions below, here is how the program will be structured. A main form for the program will have menu options to open additional forms for database operations such as adding new records, searching, etc.
Here are some questions I will need answered:
Do I only open the database / table when I need to use it and close it? And if so, do I do this in the form that uses the table? Or do I open the database in the main form when the program starts and then just open the tables as needed and close them?
I have a form with text boxes that are filled in for a new customer. Once the information is filled and validated, I need to add this to the table as a new record. I need an example of this.
How do I do SQL and list records based on the results? Can I use SQL to update records with a matching field like all records that has a customer number of 3? I need an example of this.
Here is some code I found online for ADO - I do not know what the parameters are for the rs.Open. I need help with this also.
Set cn = New [login to view URL]
[login to view URL] = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "c:\[login to view URL]"
[login to view URL]
Set rs = New [login to view URL]
[login to view URL] "Customers", cn, adOpenKeyset, adLockPessimistic, adCmdTable
I hope this explains basically what I need. Just someone to hold my hand through learning some of this database stuff and creating examples as well for each part I need to learn.
PLEASE ONLY BID if you know how to do all of this easily and for more than one computer to utilize.
Thanks
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Visual Basic 6.0