Code Repository

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Code Repository

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

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

Page: [1]

Message

<< Older Topic Newer Topic >>

Code Repository - 10/23/2003 9:20:36 PM 1 votes

dthomson

Posts: 1381
Score: 223
Joined: 6/20/2001
From: Eastern Shore Maryland, USA
Status: offline

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

_____________________________

Dan

Please rate my post

My blog
My articles
Code Repository

Post #: 1

RE: Code Repository - 12/8/2003 2:55:34 PM

nfulgencio

Posts: 57
Score: 0
Joined: 1/24/2002
Status: offline

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.

_____________________________

Nicky Fulgencio

(in reply to dthomson)

Post #: 2

RE: RE: Code Repository - 12/10/2003 3:23:07 PM

dthomson

Posts: 1381
Score: 223
Joined: 6/20/2001
From: Eastern Shore Maryland, USA
Status: offline

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.

_____________________________

Dan

Please rate my post

My blog
My articles
Code Repository

(in reply to nfulgencio)

Post #: 3

RE: Code Repository - 12/15/2003 4:12:28 PM

swood

Posts: 414
Score: 5
Joined: 12/6/2001
Status: offline

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

Attachment (1)

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney

(in reply to dthomson)

Post #: 4

RE: RE: Code Repository - 12/15/2003 4:48:44 PM

dthomson

Posts: 1381
Score: 223
Joined: 6/20/2001
From: Eastern Shore Maryland, USA
Status: offline

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

_____________________________

Dan

Please rate my post

My blog
My articles
Code Repository

(in reply to swood)

Post #: 5

RE: Code Repository - 12/16/2003 9:29:32 AM

swood

Posts: 414
Score: 5
Joined: 12/6/2001
Status: offline

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

Attachment (1)

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney

(in reply to dthomson)

Post #: 6

RE: Code Repository - 2/2/2004 8:22:02 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 7

RE: Code Repository - 2/2/2004 11:56:54 AM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

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.

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 8

RE: Code Repository - 2/2/2004 12:00:43 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 9

RE: Code Repository - 2/2/2004 12:06:57 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

I just now was able to duplicate your error message.

I' ll resolve it shortly (hopefully) and will get you the neccessary changes.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 10

RE: Code Repository - 2/2/2004 12:09:00 PM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

I' ll hold off on the email for now.....

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 11

RE: Code Repository - 2/2/2004 12:25:59 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 12

RE: Code Repository - 2/2/2004 12:29:51 PM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

So, the " No Scripts" version that' s out there is different from the one you' re talking about here?

(in reply to dthomson)

Post #: 13

RE: Code Repository - 2/2/2004 12:33:30 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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?

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 14

RE: Code Repository - 2/2/2004 12:54:10 PM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

I think I have it...let me edit the " No Scripts" version and see how I do...

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 15

RE: Code Repository - 2/2/2004 12:57:57 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 16

RE: Code Repository - 2/2/2004 1:12:34 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 17

RE: Code Repository - 2/2/2004 2:23:20 PM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

I' ll check the downloads and see what I can come up with.

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 18

RE: Code Repository - 2/2/2004 2:26:33 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

There will be an article released tomorrow.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 19

RE: Code Repository - 2/3/2004 6:23:14 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

< Message edited by rcrumbaker -- 2/3/2004 6:24:15 AM >

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 20

RE: Code Repository - 2/3/2004 9:11:43 AM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

Thanks for the quick work! I' ll download it and let you know how I do.

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 21

RE: Code Repository - 2/3/2004 9:39:56 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 22

RE: Code Repository - 2/3/2004 9:41:22 AM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

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?

Attachment (1)

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 23

RE: Code Repository - 2/3/2004 9:44:14 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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?

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 24

RE: Code Repository - 2/3/2004 10:04:56 AM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

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.

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 25

RE: Code Repository - 2/3/2004 10:11:17 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

I' m checking in on the error now.

I' ll let you know as soon as possible.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 26

RE: Code Repository - 2/3/2004 10:21:02 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

Attachment (1)

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 27

RE: Code Repository - 2/3/2004 11:25:09 AM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

Exactly! It looks the same.

< Message edited by swood53 -- 2/3/2004 11:25:30 AM >

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 28

RE: Code Repository - 2/3/2004 11:40:28 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

< Message edited by rcrumbaker -- 2/3/2004 12:56:14 PM >

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 29

RE: Code Repository - 2/3/2004 12:53:58 PM

swood53

Posts: 162
Score: 0
Joined: 7/9/2002
Status: offline

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

Attachment (1)

_____________________________

Sandy Wood
Network Administrator
Orange County District Attorney

(in reply to dthomson)

Post #: 30

RE: Code Repository - 2/3/2004 12:55:37 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 31

RE: Code Repository - 2/3/2004 2:14:30 PM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 32

RE: RE: Code Repository - 2/4/2004 10:44:04 AM

swood

Posts: 414
Score: 5
Joined: 12/6/2001
Status: offline

We have sucess! It works good now.

Thanks for all your help

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney

(in reply to rcrumbaker)

Post #: 33

RE: Code Repository - 2/4/2004 11:12:32 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

Thank you for your patience.

Glad its working for you.

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 34

RE: Code Repository - 10/12/2004 6:23:23 AM

tharg

Posts: 17
Score: 0
Joined: 10/11/2004
Status: offline

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?

(in reply to dthomson)

Post #: 35

RE: Code Repository - 10/12/2004 8:08:05 AM

rcrumbaker

Posts: 853
Score: 23
Joined: 5/13/2002
From: Kentucky (aka The Promise Land)
Status: offline

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

_____________________________

Thanks,
Ron
Microsoft MVP - SMS
rdcrumbaker@gmail.com
My Blog

(in reply to dthomson)

Post #: 36

RE: Code Repository - 2/2/2005 5:57: