|
|
|
| |
|
 Download 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 |
|
| |
| Your Vote! |
|
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..
|
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!
|
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?.
|
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.
|
2/5/2001 7:45:13 AM:Carlos
5 Gloves for the fantastic code only
for you man!!
|
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
|
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
|
2/5/2001 4:47:40 PM:Jon
Not sure why the DB is password
protected... it's "MFSC" however.
|
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.
|
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...
|
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!!
|
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
|
2/10/2001 12:43:44 AM:Nyambu
Walter,
This code is FANTASTIC!
Very
Clearly done and easy to
understand!
thanks a bundle!
|
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.
|
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 !!
|
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
|
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
|
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.
|
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.
|
2/20/2001 10:15:21 PM:ROD
when i load your program i encounter
error message
|
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.
|
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.
|
3/7/2001 4:13:38 AM:houari cheikhi
Excellent bit of coding and really
clear screen design.
thank you
|
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
|
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?
|
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
|
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.
|
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
|
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
|
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.
|
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..
|
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
|
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.
|
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
|
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!
|
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.
|
3/11/2001 4:27:13 PM:Robert Shawn
Steve Dude is a
|
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!!
|
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.
|
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
|
3/12/2001 4:21:23 PM:mbrill
it's cool whom ever it might belong too
|
3/16/2001 10:26:38 AM:tom
when going through access what is the
password
|
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.
|
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!!!
|
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
|
3/27/2001 1:42:17 PM:Jim
I can not get the "admin" password to
work. what do I do?
|
3/28/2001 4:09:00 PM:wissam
when I tray to load the project I get
the following error message:
|
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.
|
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.
|
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...:(
|
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
|
4/3/2001 10:20:21 PM:Elena
Walter,
thank you very much!!!
|
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:
|
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?
|
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.
|
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
|
6/15/2001 9:57:05 PM:Noel
Walter,
nice work its really a big
help
for me.
|
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
|
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!
|
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.
|
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.
|
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
|
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?
|
9/21/2001 5:29:53 AM:tono
Your code is very good.
Congratulation!!
|
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...
|
10/18/2001 2:39:08 PM:Matthew
Cool Code very helpful and is a step
above the rest
|
10/22/2001 4:59:34 PM:sasa
Error 20533
|
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.
|
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 !
|
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!
|
1/28/2002 9:32:19 PM:Lee
Hi, I
got Error 20533 Unable to open
database
error. Please help. Thanks
You...
|
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.
|
4/2/2002 12:32:49 PM:rizal
It's a helpfull for everyone who wants
to learn vb
|
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!
|
5/8/2002 9:57:52 PM:PHillips
I believe I will learn alot from your
codes. I appreciate it.
Thank you so
much
|
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?
|
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.
|
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
|
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
|
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.
|
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!!!
|
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.
|
9/21/2002 1:57:36 PM:
vb info-i was strict to use this
module,any clue?
|
9/24/2002 6:37:00 AM:
pangit ng program mo
|
10/6/2002 9:05:06 PM:
great code! mabuhay
|
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.
|
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.
|
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.
|
3/19/2003 3:37:08 PM:
bro try clicking add, click undo and
see the result.
|
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
|
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.
|
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
|
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.
|
5/28/2003 4:52:13 AM:
THANK FOR THIS CODE BUT CAN YOU SEND
PASSWRD
PLS
THANKS
|
6/5/2003 12:15:31 PM:
very good,
|
|
| 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.
|
|
