Loading

Billing Software

Submitted by: 
Language: 
Visitors have accessed this post 316990 times.


The source code contain advance 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

good

GIS Programmer

goof

good

good

nice very nice

Hi, Download link is not available. Pls help.

admin's picture

Hi,

Thanks for the information

Hey, i really am stuck. I am developing a ticket printing software with VB and i really need some help. Can you help me please?

M a T.Y B.Sc I.T Student , I Need ur Hepl to create a Database for my Project on Imitation Jewellery.

How can i Contact U ???

admin's picture

How complicated is your requirement on the said project?

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.

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

admin's picture

I'm so kinda busy today and I can't create your project.

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

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

Please advice me.

admin's picture

Which dll is missing?

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

admin's picture

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.

I just want the Database.

Wht Tables should i include, wht should be their Feilds and their Relationships,etc

Which tables should hav Invoice Information.

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

admin's picture

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.

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

admin's picture

You can find the database password under the module called modADO. Search for the connection string and the password is there.

what is the password of access database?

anyone help please?

admin's picture

Please read the instruction below this message with comment id:

Database password is

jaypee

How is it.................!!!!!!!!!!!!!!!!!!!!!!!

mappu unaku apppu

admin's picture

What do you mean? Please clarify.

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

admin's picture

If you'd like an inventory system you can download my Point of Sale program. It has a built-in inventory system plus point of sale.

For vb.net version I will finish hotel reservation first prior to upgrading point of sale.

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

 

admin's picture

Sorry but I don't have a user's guide and or manual for this program.

I am using visual basic 6.0 and a crystal reports 8.5.

Thanks for the info Sir....by the way, i would like u to know that im not a programmer...but i like to do this..is microsoft visual basic 6.0 is the same as visual basic 6.0?

 

thanks....

admin's picture

Exactly the same.

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

admin's picture

I created this program particularly to be use in Cable Company's billing system. My client bought this program for about $650 USD.

I am willing to teach you but I'm so very busy with my work. If you need modification don't hesitate to contact me at the contact page above.

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

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

admin's picture

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?

 

admin's picture

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.

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

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

admin's picture

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.

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 

admin's picture

Sorry but I did not include the mode of payment in this system. Anyway the source code is there and you are free to edit it.

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

admin's picture

It can be found under the file menu.

thank u so much sir......God Bless.......

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

 

Pages

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.