Skip to main content

Advanced Cable Billing System Using Visual Basic

Language


The cable billing system with source code contains an advanced coding specially on how to manipulate data using SQL language. You will appreciate how I use the WHERE Clause statement to SELECT, INSERT, UPDATE record from the database using a combination of sql statement.

Basic features include:

  1. Monthly Charges
  2. Receive Payment
  3. Customer Ledger
  4. Collectibles
  5. Paid Charges
  6. Payment History
  7. Reporting
  8. And a lot more...

Account information

username: admin
password: a

For the database password please read FAQ.

Download Billing System v1.0 Installer here.

Note: If you come from pscode.com just to download the ocx file please download the full source code below. The ocx file is included in the zip file.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byhophopon Tue, 11/25/2008 - 23:50

nice very nice

Itz better if i cud get ur ID so tht i can chat wid u on this.

A Company takes Raw material of imitation jewellery from Market(Vendor).

Turns it into Finished Product.

And Returns tht product to the Market(Vendor) back.

I need a Database to keep a track of this Transaction.

The Raw material is parts of Ear rings like Diamonds,beads,Strings , etc...

& turn them into Finished Ear ring.

Like wise itz for Neckless, pendents, bracelet,etc.

Submitted byKhalnayakon Tue, 12/23/2008 - 00:26

Itz better if i cud get ur ID so tht i can chat wid u on this.

A Company takes Raw material of imitation jewellery from Market(Vendor).

Turns it into Finished Product.

And Returns tht product to the Market(Vendor) back.

I need a Database to keep a track of this Transaction.

The Raw material is parts of Ear rings like Diamonds,beads,Strings , etc...

& turn them into Finished Ear ring.

Like wise itz for Neckless, pendents, bracelet,etc...

PLz Bro i need ur Help.

I want Finish Designing tht Database PArt by 3rd Jan PLz...

Therefore, i want ur hepl to crate the Database.

I wnt to knw wht shud be the Tables in it???

Wht shud be their Feilds???

Submitted bykatariaon Wed, 12/24/2008 - 18:52

When i load this project it shows can't find project dll.

Please advice me.

Submitted byKhalnayakon Sat, 12/27/2008 - 01:11

PLz Bro i need ur Help.

I want Finish Designing tht Database PArt by 3rd Jan PLz...

Therefore, i want ur hepl to crate the Database.

I wnt to knw wht shud be the Tables in it???

Wht shud be their Feilds???

Please do not post multiple messages with the same content.

What do you really want to achieve? Whole project or just the database schema? May be I can help you if you only need the database. Explain thoroughly what you need.

Submitted bySandeep1on Sat, 12/27/2008 - 14:23

When I run your Inventory System source code I get the error at:

Dim mTest As CRAXDRT.Application
Dim mReport As CRAXDRT.Report
Dim SubReport As CRAXDRT.Report
Dim mParam As CRAXDRT.ParameterFieldDefinitions

The ERROR is: COMPILE ERROR USER-DEFINED TYPE IS NOT DEFINED.

Please help

Thanks

It seems that you do not have crystal reports installed in your computer. I'm using crystal reports 8.5 for this source code.

If you don't have a crystal reports just download the billing installer here so that dlls for crystal reports will be register to your computer.

Submitted byAnonymous (not verified)on Wed, 01/07/2009 - 15:06

What's the Database Password.., Plz Tell Me. I'll be very thankful to you if u provide me.

You can find the database password under the module called modADO. Search for the connection string and the password is there.
Submitted byAnonymous (not verified)on Tue, 01/13/2009 - 18:24

what is the password of access database?

anyone help please?

Submitted byAnonymous (not verified)on Tue, 01/20/2009 - 02:30

Database password is jaypee How is it.................!!!!!!!!!!!!!!!!!!!!!!! mappu unaku apppu
Submitted byAnonymous (not verified)on Thu, 01/22/2009 - 17:52

pls help me...give me a code for inventory system...or even a link page that will show the codes...id like to use vb.net and ms access database...or just send the codes to my email..([email protected]).that is my email add..thnk u guys...i nid ur help
Submitted byAnonymous (not verified)on Mon, 01/26/2009 - 02:22

We search this kind of project for us

Please send u r mail id mine is [email protected]

-Unnikrishnan

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 14:15

hello Sir, i would like to ask if you have some Manual or a user' guide for this Billing system you had created....and also what kind of program u used for this....

thanks...God Bless....

 

Actually Sir, im working at the tv cable company and our billing system is a dos-based program using the clipper 5.2d programming language...it's nice look at it when it's a windows-based programmed like what u did....wish to know more about this visual basic so that i can create a windows based program using visual basic....by the way sir i would like to know ur email add so that i wil send to u our billing system for helping me how to do this in visual basic....the bilng system i' send to u had already some data...what im going to do is i will do a fresh billing system...i hope u will help me in doing this....if our company will gant me a reward in doing this...i will not hesitate to give some reward to u also....

thanks and God Bless u always... 

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 15:48

Actually Sir, im working at the tv cable company and our billing system is a dos-based program using the clipper 5.2d programming language...it's nice look at it when it's a windows-based programmed like what u did....wish to know more about this visual basic so that i can create a windows based program using visual basic....by the way sir i would like to know ur email add so that i wil send to u our billing system for helping me how to do this in visual basic....the bilng system i' send to u had already some data...what im going to do is i will do a fresh billing system...i hope u will help me in doing this....if our company will gant me a reward in doing this...i will not hesitate to give some reward to u also....

thanks and God Bless u always... 

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 17:05

Sir, will you permit me to edit ur billing system coz i would like to copy all the info of our billing system here to ur program...and can i ask from you if ever i don't know how to do it?

thanks...thanks...

Yes you can do whatever you want in my source code as long as you retain my credit to the original author. That's include of course where you download the source code.

Thanks Sir, of course sir i will retain ur credit as the author of this program....i hope u will answer all my concrns about ur billing system....coz there's a little bit different in our billing system here....if im going to add some details...i will do that in the source code...? is the source code with an extension of .vbp?

 

I suggest you learn the basic of visual basic in order to modify the source code. This source code is not intended for beginners since it has an advanced coding.

Learn visual basic step by step then ask question as you go along. Don't jump right away to the source code if you don't know how to edit it.

Search google for tutorials on how to learn visual basic then start modifying the source code here.

It really has a lot of features that you need for a billing program.

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 17:27

Sir, will u permit me to edit ur program? so that i can transfer all the info of our billing system to your program made...and i can i ask if there something i cannot understand?

thanks Sir...

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 17:35

Sir, i would like to ask this situation, when i add my name as a user and i edit the user data in MS Access..i permit all the forms to my username but the problem is...when i tried to delete a subscriber there's a warning that only the admin can delete the subscriber...but i'm already an admin user...what i'm going to do about this....

thaks

Submitted byadminon Thu, 01/29/2009 - 21:34

In reply to by Anonymous (not verified)

Sorry for the misconception but the admin checkbox in the user account under manage users do not relate to the code where only admin users are allowed to delete a record.

I just embed the admin username in the source code to check if the current user is an admin or not.

In this case if you want to delete the record based on the value of the checkbox in the user account you need to change the following code:

If LCase(CurrUser.USER_NAME) <> "admin" Then
MsgBox "Only admin user can delete subscriber.", vbExclamation

                Exit Sub
End If

This code can be found in the frmCustomersList form.

So change the first line to determine if the current user is an admin user or not from the users table.

Submitted byAnonymous (not verified)on Thu, 01/29/2009 - 17:55

Sir, i have a problem in your billing...where i'm going to encode the payment made by the subscriber paid in check, check number, and the mode of payment...where i'm, going to edit this..?

thanks 

Submitted byAnonymous (not verified)on Fri, 01/30/2009 - 13:03

Sir, good day...i would like to ask on how to compile a Visual Basic Program to .exe file...what are the buttons that i click to compile....

 

thanks....

Submitted byAnonymous (not verified)on Fri, 01/30/2009 - 14:39

in the modADO.bas line indicate below:

CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath & ";Persist Security Info=False;Jet OLEDB:Database Password=jaypee"

: when i change the password "jaypee" to my own password there's ad error and stated this way when i run the project:

error message: Error Number:-2147217843; Description: Not a valid password.

: then when i retry there's a dialog box appear and i click the debug, then the modProcedure.bas was opened and there's an statement highlighted in yellow:

RS.Open srcSQL, CN, adOpenStatic, adLockOptimistic

what i will do to this situation...sir, can u solve this problem...thanks....

 

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Project
Yes