Billing/Client info database

[CrAz3D]

(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?

[MyndFyre]

(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.

[CrAz3D]

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.

[CrAz3D]

Code Select Expand

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
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.