Develop your own software and use billing database as BackEnd

Datastore.vit is where all customer data is stored. Datastore.vit is Ms Access database. You can connect your own software to Datastore.vit to directly manipulate data. For example, you con connect your Accounting System to Datastore.vit to calculate cost and profit.

How to connect:

- Joint to workgroup Account.mdw
- Logon to this workgroup as PabxAdmin
- Logon again with database password of Ms Access to access Datastore.vit . The database password of Datastore.vit is Nha65t&Nguye65t
 

Here is the sample code to link a table from external Ms Access Database to tblGuests table of Datastore.vit

Private Function LinkToDatastoreTables()
Dim dbs As Database
Dim tdf As TableDef
Dim strFullPathToDatastore As String
On Error GoTo LinkToDatastoreTables_ErrHandler

strFullPathToDatastore = "C:\Program Files\Pabxcas\Datastore.vit"
' You can write you code to get the path to this variable.
' The path can be URL. Something like //COMPUTERNAME/sharename/Datastore.vit

Set dbs = CurrentDb

' Delete old table tblGuests
On Error Resume Next
dbs.TableDefs.Delete "tblGuests"
On Error GoTo LinkToDatastoreTables_ErrHandler

' Recreate that table.
Set tdf = dbs.CreateTableDef("tblGuests")
tdf.SourceTableName = "tblGuests"
tdf.Connect = ";DATABASE=" & strFullPathToDatastore & ";PWD=" & "Nha65t&Nguye65t"
dbs.TableDefs.Append tdf

' Do the same for other tables.

Set tdf = Nothing
Set dbs = Nothing

LinkToDatastoreTables_NormalExit:
Exit Function

LinkToDatastoreTables_ErrHandler:
MsgBox Err.Description & ". Error number = " & Err.Number & ". Error is in LinkToDatastoreTables."
Resume LinkToDatastoreTables_NormalExit
 

End Function

 

Translation

The billing system fully support Unicode, you can easily translate it to any other language. The principle is simple:

One English Phrase  <----> One other Language Phrase

Once you active other language, the software will search all interfaces, where it find English Phrase, it will automatically replace with other Language Phrase.

How to user this feature:

  • Go to Application Tools>>Language Phrase Dictionary>>put your language to the right column
  • Go to Application Tools>>Application Settings>>turn to tab named "Option 1">> check the option "Form Interface Uses Customized Language">>Click OK to close Application Settings and make the change to take effect.

Be careful if you haven't finish translation, but your turn on other language, then the interface may be in Vietnamese. You have to remember where to uncheck "Form Interface Uses Customized Language" to return to English. Otherwise, you should learn Vietnamese.

Currently, translation to Japanese, German, Italian, French is in progress and done by my distributor. I do appreciate if you spend time to translate my software to your mother language. The Language Phrase Dictionary can be exported/imported to reuse.