(I'd like to try this in VB.NET so I can TRY to use the program on my pda)
I'd like to write a database that would contain a client's name, the contact points, & billing info.
Billing info would include:
-type of bill (letter, telephone call, faxes, copies, etc)
-amount of time (ex. 10 minutes for a phone call or .10ths of an hour)
-amount of this portion of bill
What kind of database might I want to use for this?...mysql maybe?
Quote from: CrAz3D on January 27, 2005, 02:40 PM
(I'd like to try this in VB.NET so I can TRY to use the program on my pda)
I'd like to write a database that would contain a client's name, the contact points, & billing info.
Billing info would include:
-type of bill (letter, telephone call, faxes, copies, etc)
-amount of time (ex. 10 minutes for a phone call or .10ths of an hour)
-amount of this portion of bill
What kind of database might I want to use for this?...mysql maybe?
If you want to use it on your PDA, then you'll most likely have to go with SQLCE (mini-SQL Server). I don't know exactly how you could go about getting it, and I know that PocketPC has Pocket Access, but I don't know how to get to that either.
Okey dokey...I wouldn't be able to write one that would work on both my PDA & my PC would I?... that you know of?
I decided to use VB6 & the Access Data Object or w/e it is.
SO FAR it is working out quite nicely.
(http://68.35.184.146/images/ado.gif)
Public Sub ClientInfo(ByVal ClientName As String)
Form1.lvINFO.ListItems.Clear
rs.Open "Select * FROM " & ClientName, cn, adOpenDynamic, adLockOptimistic
Debug.Print "Recordset Object Created"
CurrentClient = ClientName
Display
End Sub
"Run-Time -2147217900
Syntax error in FROM clause."
Solution: http://support.microsoft.com/default.aspx?scid=kb;en-us;181489
I recieve that error the FIRST time the program is openned, after that it works. Any ideas on WHY it might be doing this?
Database Program (http://68.35.184.146/db/Database.exe)
EDIT: For some reason my Apache server (installed on my computer) isn't being allowed access or whatnot to the internet so it isn't working right now.