Important alert: (current site time 7/16/2013 3:56:31 AM EDT)
 

winzip icon

Sourcecode Notebook

Email
Submitted on: 12/13/1999
By: Mark Joyal 
Level: Intermediate
User Rating: By 19 Users
Compatibility: VB 5.0, VB 6.0
Views: 31248
 
     This code is a Sourcecode Notebook. I needed someplace to save all the little snippits of code that I've gotten from PSC and others that Ive written myself, so here is the result. Saves the code snippit along with notes about it. Both the code window and the notes window support drag and drop of both files and text from another application. Sourcecode shows basic ADO commands, so is good for beginners or anyone not familiar with ADO. The listview control headers will sort the results of the window, and you can filter code by code type (vb, vc, perl, etc...) Improvements from previous version: Adding ability to print code, simple searching by title, form can now be resized, various ADO SQL statement improvements, and i actually commented the code! Im trying to decide if I should make this a VB add-in even though it stores more than just VB code. What do you all think? Future realease will have bookmarking of favorites and saving of the window location and size. Also, does anyone know of a good way to implement syntax highlighting?
 
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 Winzip to 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 2 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Intermediate 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
12/13/1999 2:10:26 PMNick Marino

was the database that this program uses created using ACCESS 2000? cause it can't be opened by access 97, says unrecognized format.
(If this comment was disrespectful, please report it.)

 
12/13/1999 2:57:57 PMMark Joyal

Yup, I used Access 2000 for the database. If there is enough interest in a 97 version, i'll provide a link to a converted version.
(If this comment was disrespectful, please report it.)

 
12/13/1999 3:12:33 PMMark Joyal

After about 5 minutes of consideration, I realized it was silly to wait for people to be interested, so i converted the database. NOTE: I didn't do any testing of the app with this version of the database, only with the 2000 version. If it breaks with the 97 version, go back to the 2000 version. Here is a link to the file: http://www.thejoyals.net/Sourcecode/sourcebook97.zip

(If this comment was disrespectful, please report it.)

 
12/13/1999 4:20:36 PMRicky

Good program :) ... If you plan to make any modifications to the program/database, I suggest breaking up each code type into sub-types; like class, API, etc.
(If this comment was disrespectful, please report it.)

 
12/13/1999 5:32:36 PMNoOne

Thanks for the code... and my bos just asked, if I knew any access coding..... hmmmm smell a raze now...lmao
(If this comment was disrespectful, please report it.)

 
12/14/1999 12:30:07 AMPridge

Great Code! Been looking for a good example for ADO!! Thanks
(If this comment was disrespectful, please report it.)

 
12/14/1999 6:38:17 AMHilmar Jansen

If you need more functionality, look at Microsoft Office 2000 Development Kit. The Code Librarian gives more functionality like searching and categorizing code.
(If this comment was disrespectful, please report it.)

 
12/14/1999 10:19:40 AMMark Joyal

BUG: I thought I had gotten this one, but I must have skipped it by accident. You'll need to change the shortcut for Copy snippit to something else (or remove the shortcut altogether which was my choice) otherwise it interferes with normal cut and paste ops in the rich text boxes. Sorry about that.
(If this comment was disrespectful, please report it.)

 
1/4/2000 6:43:20 AMMike D.

I never really thought about doing something like this. Great Job & Great Tool!!
(If this comment was disrespectful, please report it.)

 
1/24/2000 3:46:39 PMChad

as a student, i was looking for a way
to organize my code samples, this works out perfect, would like to see any updated versions though Great Job, Very Handy!
ITI Calgary Alberta
(If this comment was disrespectful, please report it.)

 
2/5/2000 4:44:31 PMChris Lighthall

Hi,

I love the Idea of this tool, but I have a small problem. I'm currently running VB5.0 ent and when I try to run the *.exe file I get a error (can't load sstab from tabctl32.ocx, your version of tabctl32.ocx maybe out of date. Make sure you use the version of the control that was provided with your application.)

is there a way to get past this, I'm really more interested in the program then the code. Another Idea tha comes to mind is if someone could compile it again with the dependent files needed to run it and send to me by email I would be most greatful.

Thank you very much
Chris Lighthall
chris@amaonline.com
(If this comment was disrespectful, please report it.)

 
2/15/2000 11:57:33 PMDavid

Excellent. It would be great if the righ click would allow to paste from the clipboard.
(If this comment was disrespectful, please report it.)

 
4/6/2000 8:49:08 AMDevris

I am recieving an error when I start the app. I get
(If this comment was disrespectful, please report it.)

 
4/6/2000 9:22:28 AMgjones

Mark:
I've added your Sourcecode Notebook to David Stevens's code Inserter (it registers your program as an add-in). It it the answer to "Davidylam" request (in comments above) for a paste to VB. Check out the green "C" button.

Isn't sourcecode sharing great!
(If this comment was disrespectful, please report it.)

 
4/7/2000 10:55:23 AMDevris

I am getting an error when I try to run your app.I get "ADO could not find the specified provider" on the " adoCon.Open gblConnectString" line. This is the first time I have used ADO so I really have no idea what would cause this. Any help would be greatly apreciated.
(If this comment was disrespectful, please report it.)

 
4/16/2000 3:31:20 PMMarty

Regarding ADO Provider error:
You are probably missing the JET 4.0 provider for Access 2000. Two choices
download MDAC ADO 2.5 from Microsoft
Jet 4.0 provider is in here plus you get
latest version of ADO help files adO210.chm covers ADO2.5 even though
file title old. Or download the Access 97 version of sourcecode program see messages at begginning for URL.
(If this comment was disrespectful, please report it.)

 
5/14/2000 8:37:00 AMLouis Boldt

Your code provided me with some nice examples for using ADO and SQL to retrieve and update data from an Access2000 Database. The only problem I have is my own doing. I keep my screen resoulation at 600x800 so the notebook fills up the screen and is awkard to work with. The thing I will always use from the the code is the StuffQuote function. This code gets an exelent rationg for that alone. Keep up the goood work. Lou
(If this comment was disrespectful, please report it.)

 
12/30/2000 1:12:11 AMGrabsback

Nice program and very useful. I have 1000's of lines that I can NEVER seem to locate and always wanted a database to store them (but no time at work to do so). I will be sharing it with my fellow developers there also. One quick suggestion- Right mouse click c&p for those who don't use keyboard shortcuts. Once again...great work!
(If this comment was disrespectful, please report it.)

 
10/23/2001 8:17:05 AMJennifer

Hi
I love my SourceCode Notebook, but since I upgraded to Windows Me I get a 'Can't open SStab from TABCTL32.OCX' error message and the Notebook won't open.
Is there a newer version of SoureCode Notebook, or does anyone have any ideas to help?


(If this comment was disrespectful, please report it.)

 

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.