Code Repository

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

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.

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?

Attached Image(s)

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?

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.

I' m checking in on the error now.

I' ll let you know as soon as possible.

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.

Attached Image(s)

Exactly! It looks the same.

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.

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

Attached Image(s)

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.

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.

We have sucess! It works good now.

Thanks for all your help

Thank you for your patience.

Glad its working for you.

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?

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

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

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

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.

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.