Code Repository

Code Repository (Full Version)

All Forums >> [Scripting Technologies] >> General Scripting

Message

dthomson -> Code Repository (10/23/2003 9:20:36 PM)
We would like to introduce users of this forum to the myITforum Code Repository. The myITforum Code Repository is a collection of Batch Files, Command Scripts, HTML Applications, HTML Documents, SMS Installer Scripts, Jscript Scripts, Jscript Encoded Scripts, Kixstart Scripts, Perl Scripts, SQL Scripts, VBScript Encoded Scripts, VBScript Scripts, Windows Script Components, Wise files, SMS 2003 custom reports and MOF files, and Windows Script Files. (Some areas may have limited exposure.) The database is currently populated with over 1400 items running the gamut of code you may need in supporting your systems. We suggest you download the database because, if you find yourself frequently asking for assistance in writing code to complete a given task, chances are that something has already been developed and is in the database. You can read about the database in the myITforum Code Repository** article. We will be releasing Code Packs on a routine basis as we continue to accumulate code to share. Links: myITforum Code Repository article myITforum Code Repository download

nfulgencio -> RE: Code Repository (12/8/2003 2:55:34 PM)
Dan, Since you are an expert with WMI, is there a way to find out the site a client is reporting to using WMI? It is the registry but in hex. Thanks.

dthomson -> RE: RE: Code Repository (12/10/2003 3:23:07 PM)
Is this SMS 2.0? Let me know where you' re pulling that info from in the registry and I' ll see about digging out the hex conversion code snippet I have. BTW: There should be a conversion routine in the Code Repository.

swood -> RE: Code Repository (12/15/2003 4:12:28 PM)
Can' t quite locate error I' m getting here..........Opening the Code Repository on my XP Pro system with Jet DB SP 8 I repeatedly get this error.....running Access 2003.....any clues... [image]http://www.myitforum.com/forums/upfiles/2277/Hf99821.jpg[/image]

dthomson -> RE: RE: Code Repository (12/15/2003 4:48:44 PM)
We have code that does some button highlighting. This code has proved problematic for 3 other individuals. We have been unable to replicate the problem on our end but have a fix for those who experience this. Basically, the fix is as follows: You' ll have to hold down the shift key when you open the database. This will keep the form from autoloading. Follow these steps once the database is open: 1- Be sure you are viewing the list of available forms 2- Highlight the frmScripts form 3- Select View from the toolbar 4- Select Code from the drop down menu 5- The Microsoft Script Editor (or something) opens The code in question is in the procedures named fSetFontBold and fRemoveFontBold. These procedures are located in a number of forms used in the database. The workaround is to remove these two procedures from the code for all forms. HTH

swood -> RE: Code Repository (12/16/2003 9:29:32 AM)
Thanks for the note and the detailed help. I' m afraid I' ve mucked it up real good now. I remove both procedures from all the forms and upon starting the Repository I now get the error below........so many times I need to Task Manager to get it to stop.......... I' d like to work with all the scripts and will probably try to pull the tables out of the db and work with them manually... thanks for the help [image]http://www.myitforum.com/forums/upfiles/2277/Vt56338.jpg[/image]

rcrumbaker -> RE: Code Repository (2/2/2004 8:22:02 AM)
Go and get the database again. Start with a new one. If you have any scripts in the current database you need, email the database to me and I' ll extract all your scripts and send them back to you. After you have gotten a new database, follow Dan' s instructions and then let us know what happens. My email address is r d c r u m b a k e r @ m p d i n c . c o m without the spaces.

swood53 -> RE: Code Repository (2/2/2004 11:56:54 AM)
Ron, Thanks for the help and heroic measures....I downloaded the file again and searched every form for the two subs and removed them. Unfortunatley, I' m still getting the same error. I' m sorry, put me down to a lost cause. The bright side however, is I' m starting to use Microsoft One Note and create a repository of my own and although not as full-featured and professional looking as your creation, it seems too server my purpose. Let me know if I can try anything else.

rcrumbaker -> RE: Code Repository (2/2/2004 12:00:43 PM)
Email me and I' ll send you an edited version of the blank DB. If this one works, I' ll then send you the one with all the scripts. We won' t give up that easily. We will resolve your issue one way or another. [:D]

rcrumbaker -> RE: Code Repository (2/2/2004 12:06:57 PM)
I just now was able to duplicate your error message. I' ll resolve it shortly (hopefully) and will get you the neccessary changes.

swood53 -> RE: Code Repository (2/2/2004 12:09:00 PM)
I' ll hold off on the email for now.....

rcrumbaker -> RE: Code Repository (2/2/2004 12:25:59 PM)
I have it resolved in a blank version of the db. There are a few references you have to remove on the forms. If you want, I can email a copy of the blank db to you. Or I can upload it (Rod willing) and give you a link to download it. The zipped file is 594K. But it contains NO scripts. You can export all the scripts from the current version you have by opening the DB while holding the shift key down. Then exporting the table called scripts and importing it to the blanked version of the db.

swood53 -> RE: Code Repository (2/2/2004 12:29:51 PM)
So, the " No Scripts" version that' s out there is different from the one you' re talking about here?

rcrumbaker -> RE: Code Repository (2/2/2004 12:33:30 PM)
Sort of. The version on the web is the version I started with a few minutes ago to fix your problem with the On Mouse move. The no scripts version on the web is Exactly the same as the other verion expect it contains no scripts. The reason I choose to edit this version for you, was so you wouldn' t have to worry about receiving a very large file. So, I took the no scripts version and made the necessary changes for your problems. However, I have not uploaded it to MyITforum yet. Did that make sense? Of did I confuse you and me both?

swood53 -> RE: Code Repository (2/2/2004 12:54:10 PM)
I think I have it...let me edit the " No Scripts" version and see how I do...

rcrumbaker -> RE: Code Repository (2/2/2004 12:57:57 PM)
This is NOT a copy that is on the web. It' s a copy that I just edited myself to resolve your issues. We will be releasing an article soon with the latest version of the Code Repository. Which will include the latest changes to the database.

rcrumbaker -> RE: Code Repository (2/2/2004 1:12:34 PM)
The new update will be posted to www.myITforum.com as a new download shortly...along with an article explaining the steps required to move the scripts.

swood53 -> RE: Code Repository (2/2/2004 2:23:20 PM)
I' ll check the downloads and see what I can come up with.

rcrumbaker -> RE: Code Repository (2/2/2004 2:26:33 PM)
There will be an article released tomorrow.

rcrumbaker -> RE: Code Repository (2/3/2004 6:23:14 AM)
The updated code is in the download included in the following article: http://www.myitforum.com/articles/11/view.asp?id=6864 Here is the direct link to the download: www.myitforum.com/inc/upload/9056Code%20Repository.zip Please let us know.

swood53 -> RE: Code Repository (2/3/2004 9:11:43 AM)
Thanks for the quick work! I' ll download it and let you know how I do.

rcrumbaker -> RE: Code Repository (2/3/2004 9:39:56 AM)
We are here to please...or at least try to please. Let us know if you need anything else or if you still experience issues.

swood53 -> RE: Code Repository (2/3/2004 9:41:22 AM)
Well here I go...I just unzipped it and opened it and got this message about an ActiveX control......do I need to download any controls before running it?

rcrumbaker -> RE: Code Repository (2/3/2004 9:44:14 AM)
Post the error message, please. You should not be getting any errors. For users of Access 2003, you may be prompted to update the Microsoft Jet 4.0 database engine to service pack 8. Here' s a single KB article with the download links: http://support.microsoft.com/?kbid=829558 What version of Access are you running?

swood53 -> RE: Code Repository (2/3/2004 10:04:56 AM)
Ron, I added a *.jpg in my previous post with a picture of the error message...I' m running Access 2003 on two machines I use. I get the error on both of them and one has the Jet DB update, the other doesn' t.

rcrumbaker -> RE: Code Repository (2/3/2004 10:11:17 AM)
I' m checking in on the error now. I' ll let you know as soon as possible.

rcrumbaker -> RE: Code Repository (2/3/2004 10:21:02 AM)
You' ll have to hold down the shift key when you open the database. This will keep the form from autoloading. Follow these steps once the database is open: 1- Be sure you are viewing the list of available forms 2- Hit ALT + F11 3- Click on Tools 4- References 5- Verify they look like the same as what is in the attached picture. 6- Let me know.

swood53 -> RE: Code Repository (2/3/2004 11:25:09 AM)
Exactly! It looks the same.

rcrumbaker -> RE: Code Repository (2/3/2004 11:40:28 AM)
The command that is causing conflict is the Maximize on open command. Open the Database using the Shift Key. Then Right click on frmScripts Form and choose Design View Then in the upper left hand corner, Right Click on the square. Choose Properties. This will bring up the FORM Properties. Scroll down about 3/4 way down until you see: On Activate = DoCmd.Maximize Remove the DoCmd.Maximize Save and Close. Reopen the db. Let me know.

swood53 -> RE: Code Repository (2/3/2004 12:53:58 PM)
Well, you' re going to think I' m a moron, but right-clicking the frmScripts form gives me a menu with Properties but doesn' t quite follow - I can' t quite go to a square in the upper left hand corner....sorry for the grief on this one....see the jpg for my view...

rcrumbaker -> RE: Code Repository (2/3/2004 12:55:37 PM)
Opps...I left out a step. Go into Design View of the frmScripts. Then within there Right Click on the square in the upper left.

rcrumbaker -> RE: Code Repository (2/3/2004 2:14:30 PM)
I corrected the steps above. I have been unable to duplicate your problem, but this fix should resolve your issue. It removes the On Activate function, and hopefully fixes your issues. Please let us know.

swood -> RE: RE: Code Repository (2/4/2004 10:44:04 AM)
We have sucess! It works good now. Thanks for all your help

rcrumbaker -> RE: Code Repository (2/4/2004 11:12:32 AM)
Thank you for your patience. Glad its working for you.

tharg -> RE: Code Repository (10/12/2004 6:23:23 AM)
I' m speechless! This is outstanding. Enough praise. I have found one snag, when adding quite a long script: " The text is too long to be edited" The field size can be modified in Access but will this affect performance and/or file size?

rcrumbaker -> RE: Code Repository (10/12/2004 8:08:05 AM)
I ran into that once, and it does not effect the performance. We have some big plans for the Code Repository...just keep an eye open!! [:D]

bkelly -> RE: Code Repository (2/2/2005 5:57:27 PM)
I' ve created a wizard for ASE that lets you browse the myITforum Code Repository and insert scripts within the Editor. Note: I' m not distributing the database- you have to download it separately and supply its location on your system. 1) You need ASE (free trial version works fine) http://www.adminscripteditor.com/editor/download.asp 2) Then get the myITforum Code Repository Wizard from http://www.adminscripteditor.com/wizards/view.asp?id=24 3) You can run the wizard from anywhere, but to have it appear as a wizard within ASE- place it in the following folder: " %ProgramFiles%\iTripoli\AdminScriptEditor\addins\wizards" If you don' t have KiXforms installed, it is included and you will be asked to install it. KiXforms is a freeware DLL that you can use in your VBScript or KiXtart scripts to create GUIs. This wizard was written in KiXtart using KiXforms for the display. Click on the " about" button for details. Any feedback appreciated! Bob

rcrumbaker -> RE: RE: Code Repository (2/2/2005 10:28:35 PM)
Nice. I' ll have to give this a look. We have been discussing what we should do with the next update to the Code Repository...this just might be something we use. Thanks!!

dthomson -> RE: RE: Code Repository (2/3/2005 2:25:19 PM)
I really appreciate your efforts Bob. I haven' t yet checked it out, but I will try soon and give feedback if something comes to mind.

bkelly -> RE: Code Repository (2/7/2005 9:31:32 AM)
I' ve just posted the source script for this wizard here: http://www.adminscripteditor.com/scriptlibrary/view.asp?id=448 There are lots more things that could be done with this, but before investing the time I wanted to judge the level of interest for such a thing. It' s pretty straight-forward; for now it should serve to bring the code repository to the attention of more people.

rcrumbaker -> RE: Code Repository (2/7/2005 9:46:42 AM)
Nice work!!

hunter -> RE: Code Repository (1/18/2007 11:55:51 AM)
[:@] It works. Thank you so much!

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.3911133