Quick Search for:  in language:    
ADO,PSC,DONT,VOTE,CODE,COZ,ROCKS,miss,guys,co
   Code/Articles » |  Newest/Best » |  Community » |  Jobs » |  Other » |  Goto » | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
Visual Basic Stats

 Code: 3,011,557. lines
 Jobs: 117. postings

 How to support the site

 
Sponsored by:

 

You are in:

 
Login



Latest Code Ticker for Visual Basic
Click here to see a screenshot of this code!Advanced Mailprogram
By Henrico Bloemhof on 7/1

(Screen Shot)

Click here to see a screenshot of this code!A Simple Database WIth XP Design ( Without XP )
By Osen Kusnadi on 7/1

(Screen Shot)

Fractional Addition
By SAEED HASSAN on 7/1


Defrag at certain time
By Michael Nipper on 7/1


Click here to see a screenshot of this code!Extended Find Ver 2
By Roger Gilchrist on 7/1

(Screen Shot)

Y! Module
By NightCrawler on 7/1


Files Comperator (the right way)
By Jarry Claessen on 6/30


Simple UDP example
By Mick Walton on 6/30


CAPS Trigger
By Trevor Burley on 6/30


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!





Affiliate Sites



 
 
   

SALES & INVENTORY PROGRAM using ADO & Crystal Report (A must see..)

Print
Email
 
winzip icon
Submitted on: 2/4/2001 4:32:48 PM
By: Walter Narvasa  
Level: Advanced
User Rating: By 159 Users
Compatibility:VB 6.0

Users have accessed this code 47468 times.
 

(About the author)
 
     Don't miss this guys coz' this is a corporate code that i developed before using ADO with complete Login Entry,Masterfiles,Transactions such as Sales Order, Purchase Order,Receiving Order, Reports such as Inventory Report,Sales Report,Critical Report and Backup/Restore/Password Security features. Using this example you can learn a lot about how ADO really works without using any data controls. This is the best contribution of mine in PSC so far so you better not miss this coz' this code really rocks. PLEASE DON'T FORGET TO VOTE FOR THIS CODE COZ' THIS CODE REALLY ROCKS!!!

 
winzip iconDownload code

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

Virus note:All files are scanned once-a-day by Planet Source Code 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.
3)Scan the source code with Minnow's Project Scanner

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
1) You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.   
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 18 submission(s) by this author

 

 
Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
Reason:
 
Your Vote!

What do you think of this code(in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
2/4/2001 4:38:32 PM:Author
Message to all: This Login Entry is 
encrypted so you better use this 
username: "admin" and the password is: 
"admin" also, you can change the Login 
Entry after you have entered the 
program and go to the Password Security 
Menu and change it if you want. GOOD 
DAY TO ALL OF YOU !! HAPPY LEARNING!!  
DON'T FORGET TO VOTE FOR THIS CODE..
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 2:44:13 AM:Chris
Your code have simple GUI but your code 
really rocks coz' some of them are very 
new to me. I think i will vote 
excellent later, coz' i have to go to 
my office right now. Keep it up man!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 4:04:02 AM:Manas
Hi, I thought crystal report was with 
VB5 and VB net. I did not see any 
library for crystal report. Pardon my 
ignorance , how do I get crystal 
report?.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 4:14:09 AM:Author
I have included all the reports in my 
code and the extension name is "*.RPT" 
. The Crystal Report 7 OCX control is 
not a shareware you have to buy it just 
like what you did to your Visual Basic 
unless your Visual Basic is a pirated 
copy. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 7:45:13 AM:Carlos
5 Gloves for the fantastic code only 
for you man!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 8:33:00 AM:roseta
hi walter
i just saw your code , it 
realy worths voiting. it really is 
something clear and clean?? i always 
wished that my project were like this 
one???
wish you best of luck.
roseta
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 11:12:33 AM:Pete
Excellent program! I'm still a bit of a 
newbie and your code has helped 
understand a lot. I had trouble with 
Crystal reports at first but found 
information on MS's site,I would like 
to share that info with other 
"newbies"
"To install Crystal Reports, 
run Crystl32.exe. The location of 
Crystl32.exe depends on which version 
of Visual Basic or Visual Studio you 
own. In all cases, it is in the 
following relative path: 
\Common\Tools\VB\CrysRept\Crystl32.exe
Use the following table to determine 
which CD to use: 
   Product         
               Disk
-----------------------------------
 Visual Basic Professional      1
Visual Basic Enterprise        1
Visual Studio Professional     2
Visual Studio Enterprise       3 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/5/2001 4:47:40 PM:Jon
Not sure why the DB is password 
protected... it's "MFSC" however.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/6/2001 11:03:50 AM:Author
I intended the database itself to be 
password protected to demonstrate how 
to connect to a password protected 
database in which i included in the 
code itself. Anyways, thank you very 
much for all the people who vote for me.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/8/2001 10:28:30 AM:Philip
Nice Code, i have  cryst report version 
is 4.6, so its not working properly, is 
their any way to rectify the 
problem....any how accept my 
vote.....The code helps me a lot...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/9/2001 11:24:40 AM:Richard Simons
Hey Philip,
   This code rocks man!! 
If you want the code to run properly 
you have to have the Crystal Report 
Version 7. What an excellent job 
Walter!!! Keep it up dude!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/10/2001 12:39:27 AM:Nyambu
Greetings from Nairobi!
I am a newbie 
myself in a place where there are a 
hand full of VB 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/10/2001 12:43:44 AM:Nyambu
Walter,
This code is FANTASTIC!
Very 
Clearly done and easy to 
understand!
thanks a bundle!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/11/2001 11:20:54 AM:vbcodeguru
What can i say....this code is simply 
the best and most of all the most 
complete code ever sent here at PSC. I 
gave you man a rate of "Excellent" for 
a well done job.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/12/2001 4:19:10 PM:Kevin Doherty
Excellent bit of coding and really 
clear screen design. I am in the middle 
of a similar project for Pubs & Nite 
Clubs here in Ireland and couldn't 
resist having a peek at the code. Class 
Stuff !!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/12/2001 11:54:39 PM:Author
To all:
   This program simply 
demonstrates all the distribution of 
ingredients according to it's recipe 
and from there it will automatically 
adjust the inventory according to sales 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/13/2001 10:49:20 PM:DT
Hi,
Excellent Job 
Done.
Question:
When running the 
progtam, it prompt Compile error: 
User-defined type not defined. and move 
to line under:Private Sub 
Toolbar1_ButtonClick(ByVal Button As 
MSComctlLib.Button)
Please 
advise.
Regards,
DT
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/16/2001 2:22:04 PM:Author
DT, 
   There is no error in my code. 
Probably you have an incomplete VB6 
Components that's why you encountered 
such problems. If anyone is curious 
where to look for the Crystal Report 
Website...this is it. 
http://www.seagatesoftware.com/homepage/
 I am not endorsing thier product i 
just want to help others.
And thanks 
for the compliments.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/17/2001 10:51:47 PM:Chris Hatton
Excellent Job, its a very nice and 
clean program to use. Keep up the good 
work.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/20/2001 10:15:21 PM:ROD
when i load your program i encounter 
error message 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/24/2001 9:04:23 AM:LinuxDude
Outstanding effort Dude!!!, I have 
tested your program and it really 
works. This is the most professional 
and useful code ever sent in PSC. Keep 
up the good work and more power.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/2/2001 6:46:12 AM:Cesare Imperiali
Now, I was just looking for some 
example on how to use Crystal Report 
inside VB. So I am very happy to 
discover out your code. I have not seen 
it yet, but I give you 5 globes on 
believe it will solve some matters I 
have with passing parameters to the 
OCX. See you in the net.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/7/2001 4:13:38 AM:houari cheikhi
Excellent bit of coding and really 
clear screen design.
thank you
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/7/2001 9:57:02 AM:GRJ
How can this code be changed to work 
with ACESS 2000?
I wanted to be able 
to use ACESS 2000 to edit the database, 
but when I converted it
the program 
crashed.  Also I have problems with the 
password.
I am certain that I enter 
admin, but it does not accept it.  I am 
using VB6 with SP5
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/7/2001 12:00:36 PM:Steve Dude
Hmmmm - Since Walter took all the 
credit for his Comic PageMaker, which 
he ripped everything that actually 
worked from Stu-Paint, I have been 
leary of this guy. This Award Winning 
Code looks amazingly similar to 
DynasticSoft's Commercial Accounting 
Code. Could this be the beginning of 
the end? I may be wrong...Walter?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/7/2001 7:07:19 PM:Peter
Walter
This looks very good. 
However, I can crash the menu 
information screen. I get the message 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/7/2001 7:16:45 PM:Peter
Walter
This looks very good. 
However, I can crash the menu 
information screen. I get the message 
"Row cannot be located for updating. 
Some values may have changed since it 
was last read." This message has been 
the bane of my life for a while in the 
ADO databases that I write. Does anyone 
know what this means and how to fix it. 
It always seems to happen on forms that 
have a parent/child format. Thanks.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/8/2001 8:22:19 AM:Author
This Award Winning Project of mine is 
100% originally created and designed by 
me (Walter) only and i am not a credit 
grabber just what Steve Dude is 
implying to me. The Comic Pagemaker is 
a modification of Stu Paint and i 
re-created/re-programmed it in a more 
useful way so that it can be useful to 
any programmers here at PSC. But this 
Sales Inventory Code was my project 
from my previous client here in the 
Philippines. I just donated this code 
to help those programmers around the 
world especially the beginners. Steve 
Dude is just jealous of me coz' he 
cannot come up with this kind of code. 
To other people who voted for this code 
i personally thank them...The database 
password is 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/8/2001 8:30:02 AM:Author
The database password is "MFSC" and to 
convert the SQL Connection to Access 
2000 just follow this line -> db.Open 
"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data 
Source=" & strDB
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/8/2001 11:17:48 AM:Steve Dude
I forwarded the link to your code to 
DynasticSoft. We'll let them be the 
judge. If I am wrong, I apologize. In 
any case, how do you justify taking ALL 
the credit for Comic PageMaker and 
making yourself the sole copyright 
holder? Is that not an illegal and 
Credit Grabbing act? You tell me, how 
that makes you look.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/8/2001 5:14:34 PM:Ryan
Hi there..excellent job man..
but, i 
get problems whenever i want to add 
something.. the PO, or receiving note 
or menu.. i can edit and save .. but, i 
can't add (create a new) .. say create 
a new PO.. or new Menu..
i get the 
following error.. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/9/2001 9:22:40 AM:vbcodeguru
Steve Dude, Hey man...listen to me!! I 
think Walter is right on what he is 
doing coz' he just want us to learn 
some of his coding or enhancement 
regarding the Comic Pagemaker. Anyways, 
Walter is a database programmer and he 
just try to do some experiments with 
some of codes here in PSC but most of 
his submissions that i haved already 
checked are all original especially the 
database programs. So, i gave Walter 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/9/2001 10:40:42 AM:Mike
Walter <====RULES!!! 5/5 What a perfect 
code. I haved checked the program and 
reviewed it and i don't find any 
problems. Walter, your code is original 
and clean!!! So, Steve Dude get out in 
PSC coz you are one hell of a looser!! 
And Steve Dude don't bother to destroy 
Walter's reputation coz' he already 
earned his rights here in PSC. More 
Power Walter!! I'm one of your biggest 
fan.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/10/2001 8:52:19 PM:James H.
Steve Dude...you are one hell of a 
looser. In fact, you are the one who 
have no morals because you judge a 
person as if you are 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/10/2001 9:00:14 PM:Author
I agree James. Mr. Steve Dude!! Get a 
life and stop destroying my reputation 
because no one believes on your 
accusations. This code is originally 
made by me only without the help of 
anyone so stop your jealousy about my 
code ok. And get a life Steve Dude!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/10/2001 10:34:07 PM:Steve Dude
If you guys think I am full of it, take 
a look at a new posting from the actual 
author of the code Walter CLAIMS is his 
under Comic PageMaker...Who is the real 
looser here, Walter? :) The proof is in 
the pudding. If you are right about 
anything, it's the fact that this is 
good award winning code, too bad Walter 
didn't do it. How would you guys like 
it if someone ripped you off and 
claimed it was theirs? I have just 
shown you the FACTS! Grow up and get a 
life children.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/11/2001 4:27:13 PM:Robert Shawn
Steve Dude is a 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/11/2001 4:35:56 PM:Mr. John Smith
Steve Dude is not a programmer but a 
COMPLETE M O R O N,I D I O T,E M B I C 
I L E,B A S T A R D & R E T A R D E D 
ever lived in this planet!! Everyone!! 
don't ever listen to this Steve Dude 
for he himself is a THIEF!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/12/2001 10:02:53 AM:Author
To Childish Steve Dude: For your 
information, this award winning code of 
mine has been reviewed and tested by 
PSC officials so there's no way that 
this code will be noted as stolen. This 
award winning code of mine will not win 
if this is stolen so you better think 
of your childish accusations Steve 
Dude. Better do some productive way of 
living than doing this malicious 
accusations.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/12/2001 4:20:06 PM:Fatima
Walter, your code is an excellent aid 
for learning for newbies like 
mysef...however, i have encountered an 
error while trying to load it..i have 
crystal report installed with vb6.0 yet 
when it loads it says :-crystal32.ocx 
not found...could you tell me where i 
am going wrong???
rgds
fatima
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/12/2001 4:21:23 PM:mbrill
it's cool whom ever it might belong too
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/16/2001 10:26:38 AM:tom
when going through access what is the 
password
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/16/2001 3:47:50 PM:computrz
dude your code is sweet.  only one 
person has a problem with it, you have 
talent and nevermind someone being 
jealous of your work.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/20/2001 12:15:17 PM:Bernz
Excellent works!!!
I can use your 
code's for my new study project in 
university here... Malaysia 
student.
TQ!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/22/2001 7:41:27 AM:Theo
I have 3 books on ADO and numerous 
others. Using this project I've managed 
to learn more in a night of working 
with it, than I've learned in using the 
books. Well done man. You got my votes. 
TC
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/27/2001 1:42:17 PM:Jim
I can not get the "admin" password to 
work. what do I do?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/28/2001 4:09:00 PM:wissam
when I tray to load the project I get 
the following error message:
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/28/2001 4:16:00 PM:wissam
when I tray to load the project I get 
the following error 
message:
"..\\CODE_UPLOAD14534242001\MF
SC\crystl32.ocx could not be 
loaded"
while crystal report is alrady 
installed in my system and also I have 
Trying to copy this ocx file in the 
specified directory but the problem 
still.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/29/2001 11:55:55 AM:Author
The version of Crystal Report that i 
used in this project is Version 7 so 
you better update your Crystal Report.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/31/2001 10:37:51 PM:Elena
When I try to run program I am getting 
compile error "Object does not source 
automation events" for line "WithEvents 
adoPrimaryRS2 As Recordset". 
I am new 
in VB and don't know what I should 
do...:(
 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/1/2001 12:24:40 PM:Author
Elena, Open the MFSC.VBP using notepad 
and cut and paste this ff. line to 
MFSC.VBP and save it afterwards Start 
here => 
Reference=*\G{00000200-0000-0010-8000-00
AA006D2EA4}#2.0#0#..\PROGRAM 
FILES\COMMON 
FILES\SYSTEM\ADO\msado20.tlb#Microsoft 
ActiveX Data Objects 2.0 
Library
Reference=*\G{00025E01-0000-000
0-C000-000000000046}#4.0#0#..\PROGRAM 
FILES\COMMON FILES\MICROSOFT 
SHARED\DAO\DAO350.DLL#Microsoft DAO 
3.51 Object Library
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/3/2001 10:20:21 PM:Elena
Walter,
thank you very much!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/30/2001 10:11:40 AM:Pradeep
Hi Walter, I tried your code. Excellent 
Work Man! But when I tried to add a new 
S/O, P/O or R/O it gave me this error 
message: 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/30/2001 10:12:11 AM:Pradeep
Hi Walter, I tried your code. Excellent 
Work Man! But when I tried to add a new 
S/O, P/O or R/O it gave me this error 
message: "Can not find the row". And 
the debug focused to Public Sub 
xTransfer_Timer()section. I can't 
understand why is that? Can you help me 
to solve?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/13/2001 8:55:32 AM:shubie
Great Stuff but I have some 
problems;
a) before it loads it says 
errors during loading. refer to c:\ 
FrmMain.log for details and if I press 
yes it msg box 10 times syaing VB 
error
and then when I finally run it 
again prompts me of error FrmMain.log 
and then if i edit anything in PO or SO 
it gives this
run time error 7009
can 
not find the row
please help me. 
Anyway your code and effort deserves a 
big five votes from me.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/21/2001 7:30:39 PM:Jonathan
Walter,
Thanks for writing this code.  
However, I run into the same error that 
Peter posted a message about on 
3/7/2001 : "Row cannot be located for 
updating. 
Some values may have 
changed since it 
was last read." This 
message has been 
the bane of my life 
for a while in the 
ADO databases that 
I write. 
Do you have any 
advice?
-Jonathan
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/15/2001 9:57:05 PM:Noel
Walter,
  nice work its really a big 
help 
  for me.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/24/2001 4:47:45 AM:Rick
When I tried to add a new sales order, 
it gave me an error - 'Can not find the 
row'.
Can somebody help me
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
8/30/2001 8:39:21 PM:Guy
Your code is very good. 
Congratulation!!
Were do you find your 
icon? Their look very nice?
Au 
revoir!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/5/2001 8:16:45 AM:Mark Houghton
I was interested in your code because I 
wanted to learn about creating 
reports.But I have had the same error 
msg as others re : Crystal32.ocx not 
found. I have installed Crystal Reports 
from VB Prof cd so what next ? Please 
advise. Also after creating a new user 
and password it says that the passwords 
do not match even tho' it accepts it.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/14/2001 12:52:16 PM:Danny
Walter, 
can you provide us the fix 
for the Sales' row problem when adding 
new items...
I think it is a good 
system.
Thanks.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/15/2001 4:32:09 PM:Rajan
Walter your code is very nice 
it 
helped me a lot in learning VB
But I'm 
not being able to add records in forms 
that uses the datagrid
Error 
is:No.7009 -Cannot find the row
Please 
help
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/17/2001 9:27:29 PM:Allan
I jst viewed ur program and it is GOOD! 
Do you have other example's on dbgrid? 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/21/2001 5:29:53 AM:tono
Your code is very good. 
Congratulation!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/21/2001 5:45:15 AM:tono
Walter,
can you provide us the fix 
for the Sales' row problem when 
adding 
new items...
I think it is a 
good 
system.
Thanks you...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/18/2001 2:39:08 PM:Matthew
Cool Code very helpful and is a step 
above the rest
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/22/2001 4:59:34 PM:sasa
Error 20533
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/22/2001 5:00:58 PM:sasa
Hi, when I try to open your report I 
got Error 20533 Unable to open database 
error.  Please help.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/25/2001 1:42:30 PM:José Solís
I think that the code is helpfull, but 
I haven't time enough to read it 
now.
Probably I'll vote it excellent 
when I read it.
Congratulations and 
thank for your help !
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/22/2002 2:11:33 PM:Kit
Hey dude...ur prog is cool...I'll give 
it a 5 out of 5. keep up the good work!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/28/2002 9:32:19 PM:Lee
Hi, I 
got Error 20533 Unable to open 
database 
error.  Please help. Thanks 
You...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/1/2002 9:53:49 AM:St.Chai'z
Wow, verry nice code u got there 
man...
it helps me a lot. Thanks and 
keep up
the good work!!! I'm a fan of 
no one but
let just say that I like 
u'r work.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/2/2002 12:32:49 PM:rizal
It's a helpfull for everyone who wants 
to learn vb
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/8/2002 12:13:12 PM:Saeds
u better write a book, man! wag mo na 
lang pansinin si Steve dude, KSP lang 
yon (Kulangot Sa Pader). U rock! 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/8/2002 9:57:52 PM:PHillips
I believe I will learn alot from your 
codes. I appreciate it.
Thank you so 
much
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/17/2002 5:43:29 PM:Mithril
I too have a problem that I cannot 
access the program as the password 
admin or even ADMIN will not be 
accepted... what am i doing wrong?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/19/2002 12:57:24 AM:AndySulz
"corporate code"??  What kind of 
corporation codes with global database 
variables?  Not a very good coding 
style to use global database vars... A 
better design would be a 3 step process 
Open Database, Write/Read, Close 
Database....I dont' even think you have 
code in your project that actually 
closes the db.  This is a joke.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/5/2002 4:13:35 PM:Ziom
I think atleast  6 others have already 
sent this same message that there is a 
prob in S/O, P/O etc that when u try to 
add a record it gives 'runtime error 
7009 cannot find a row' in 
xtransfer_timer module please help if u 
can walter. also fantastic code, thank 
you for posting it
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/7/2002 5:51:08 PM:
Hi,
Good programme I learn a lot...but 
why the database password is 
protected....I like to see the database 
can U send me the password for it. 
thank's
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/12/2002 2:45:13 PM:Lucky
When I run the program, it has 
error
PO/SO ADD ERROR:
No.7009 
-Cannot find the row
Anyone could 
help me in this problem?
Thanks in 
advance.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/24/2002 5:53:22 AM:Mark
I cant run the program, i opened it & 
theres a error message appear 
"CRYSTL32.OCX cannot be 
loaded",
"Error during load: refer 
FRMMAIN.log for details", what will i 
do? Anyway Mabuhay ka pare, Pinoy 
Rules!!!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/6/2002 2:56:20 AM:Lingswaran Singh
Hi..i could not download your code due 
to restriction here in my college. I 
hope you can let me know about what 
your program is..in detail, how it 
works, how is it usefull to other ppl, 
you know something like a briesf 
descrition of what your program really 
does. Thank you in advance.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/21/2002 1:57:36 PM:
vb info-i was strict to use this 
module,any clue?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
9/24/2002 6:37:00 AM:
pangit ng program mo
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
10/6/2002 9:05:06 PM:
great code! mabuhay
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/11/2002 11:52:30 PM:
Hi,
From the look, the code seems to 
be good. I have error as stated below 
and Please provide me solution to 
it.
Run-time Error '3704'
and this 
error stops at all WithEvents 
adoPrimaryRS3 As Recordset 
statements. What could be the problem 
and how can I solve the problem.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
11/11/2002 11:57:11 PM:
Hi,
I have problem with the following 
statement...
run-time error '3704' and 
this stops at all the statement written 
in code adoPrimaryRS3 As Recordset at 
every place. Please help me to look at 
what you have designed that looks good 
to learn and cherish.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/12/2003 3:28:14 AM:
If anyone has found the fix or has 
updated this code to work properly with 
the ROW BUG and the DATABASE access 
bug, especially during the sales 
transaction - can you please email me 
the fix or if you have updated or fixed 
this code in anyway can you please send 
me the code so I can get it working 
properly?  I love this code and wish I 
could get it working, thanks for your 
help everyone.
My email:  
burfordj@mailcity.com
Cheers.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
3/19/2003 3:37:08 PM:
bro try clicking add, click undo and 
see the result.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/8/2003 10:05:30 PM:Walter Narvasa
if you guys want to get in touch with 
me email me at 
customized_programming@yahoo.com
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
4/29/2003 11:29:08 AM:
Greetings from Zimbabwe. 5 gloves from 
me Ja. Woltez. You simply don't know 
the amount of value I have derived from 
your two submissions thats is the Point 
of Sale and Sales & Inventory prog. But 
I am looking forward to seeing more on 
VB and Oracle Connectivity. You seem to 
be concentrating more on the Access 
Database. God bless. It is pple like 
you who keep Planet Source Code humming 
and those of us in the remote third 
World where a VB book is the equivalent 
of Gold learning.  
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/7/2003 5:51:19 PM:
Agree with this thread on most 
accounts...
code is great for 
learning
i also get the same error on 
cant find row
for the crystl32.ocx 
problem - 
get a small prog called 
"dependency walker" - it will check the 
dependant files for crystl32.ocx and 
give a report on the status of the 
ocx.
theres also a patch for crystal 
called "crystl32-ocxpatch.exe"
that 
might help. both are free for 
download.
hope it 
helps...
fred fenster
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/7/2003 5:59:37 PM:
also if u want access as admin - simly 
load up the proggy make sure no name is 
highlighted in the login and use 
3773
the DB password is MFSC.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/28/2003 4:52:13 AM:
THANK FOR THIS  CODE BUT CAN YOU SEND 
PASSWRD 
PLS 
THANKS 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/5/2003 12:15:31 PM:
very good, 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
Add Your Feedback!
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
Name:
Comment:

 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | Visual Basic Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright© 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.