help needed with a database project I am making:

Hi, I would like to make an application in VB6.0. Right now, for all of my open cases (I do cell phone repair and people send me broken phones to fix), I use pen and paper. I have a forum I fill out manually. Whenever I get a customer who needs my services I fill the forum out to help keep my attention focused, so I can see exactly what I need to do to get the job done. I am horrible with book keeping however, I often loose or misplace my pages. (I also have ADHD which helps contribute to my dis-organization) I was thinking if I had this on my computer it may keep me a little more organized. I have used VB6 for small projects in the past and I am sure this could help me here also.

Basically my ideal program would look like this: http://img.photobucket.com/albums/v2...openscreen.jpg

“new case”- I could press the new case button, and enter the info just as I would enter it on a new sheet of paper.
“open cases”- this would show all open cases, once a case is complete it would not show up here. The program would know if a case is closed by the “case closed” checkbox being selected from the main template.

I designed the “new case” template; this is what it looks like:
http://img.photobucket.com/albums/v2...0/template.jpg

After I fill in the details, I would press the “save” button. Because the checkbox at the bottom is NOT checked, that would mean the case is still open. I can do this with all of my cases I have. Once I complete a case, I would check off the bottom “case complete” box.

Once a case is closed, I would like them to disappear from this list, so if I completed 1 case, it would only show the remaining 4 cases open on the main screen. I would however like to be able to view closed cases if I ever needed to, but don’t want to see them every day when I check my open cases.

I understand this may take some time to complete, if anyone could refer me to info that could help me design this, it would be greatly appreciated. Also, if someone would like to help me themselves, I would be willing to pay them for the help they provide. If anyone needed a Verizon cell phone accessories or something, I would even be willing to give them accessories or parts in exchange for help. My credentials can be found on eBay, my user name is mds33200 and I have a feedback score of something around 1,700.

First you have to decide what kind of database you'll be using - Access, SQL Server, mySQL, etc.

Then you have to decide how you're going to connect to the database (http://www.connectionstrings.com/).

Then you can start thinking about your code. Try Beacon's tutorial to learn how to manage databases in code.

Hi, I think I would use access, but thats just because I used it before. I dont need to view this from other computers- mainly just on my laptop. I will check that out though, thanks.

Hey mds33200:

Just looking at your "MDS33200's Handy Dandy Kustomer Keeper" application you are thinking about making.

I was wondering if you have an idea of about how much text you would ordinarily have in your "Case Notes" and "Comments" areas?

If you have Access that should work fine particularly since you are only going to have it on your laptop.

Take Care and keep fixing those phones.

I could most likley help you out with this project.

you can see some screenshots of my upcoming project located

http://www.vbsoftware.biz/forums/ind...4&st=0&#entry4.

Join up and have alook at the upcoming ebay system im making.

Let me know if you are intrested in me given you a hand.

Thanks

Jamie

Hi AIS4U, to answer ur question about how much space I need, it usually varies, some times one sentance but some time a paragraph. I wasnt sure how to expand it so I can have a larger text box (not all in one lign) but I figured thats just a basic layout how I would like it. But Yep, I got a few put together tonight haha.

Jamie- I will PM you to get some of ur advice, that eBay program looks great.

Thanks for the replies.

-Mark S.

have you made your mind up yet?