Search results

I revised the sub to be a standalone VBScript. Option Explicit 'This code will need updated if Microsoft adds a version of Office codebase above 16.0 'Instantiate Shell Object Dim oShell Set oShell = CreateObject("Wscript.Shell") 'Set Trusted Location Path and Description Dim sTrLoc...

So here is the registry update subroutine: Sub SetTrusted sModuleName = "SetTrusted" 'This code will need updated if Microsoft adds a version of Office codebase above 16.0 'Define registry key locations and strings Const cRegKey12 = "HKCU\SOFTWARE\Microsoft\Office\12.0\Access\Security\Trusted...

@Pat Hartman - That is exactly the plan. Since I don't have any commercial development/packaging tools, I will be using a vbscript to do the installation. It will create local storage locations, copy relevant files from the server to those locations, create a desktop shortcut to run the...

Thanks for the input. You use a 3rd party installer to handle this, yes?

As I'm putting this together and checking the registry files on my local computer.... I see Office entries for 12, 14, 15, 16...but, only an Outlook folder for 14. If I write a new key to \......\14.0\Access\Security\......\ will that cause a problem if there isn't currently an Access folder?

@KitaYama - As I mentioned in post #1 - I have no admin access to set group policy. That would involve our third party IT company which I want to avoid if possible. Also, as @Galaxiom points out, it's not a solution I'm a fan of even if I had rights to set group policies. @CJ_London - I'm not...

@isladogs - You are cracking me up today! Yes, that would be how it works at a high level. It is more like how do I "add the keys to the registry". I've seen so many posts talk about where to add the locations, and how to format the keys, and stating to "use a script" to add the keys but...

I recognize the text of a registry key. I have used regedit before. I must be missing the key bit of information in, how does having the text file/strings help me updated the registry without invoking regedit? My GoogleFu must be failing me today.

I'm working on establishing the best methods for our company to setup and distribute a basic split DB setup (Jet BE on server share; individual FEs locally). I have my scripts working to copy files to local FEs. The only thing I'm lacking at the moment is an automated way to ensure code can be...

Well, it's not doing much heavy lifting, but my two scripts seem to be functioning and error free! One is an install script that does the initial FE file copying and creates a desktop shortcut. The second script is the database launch script which copies the FE on each launch and writes a log...

Ah...should have commented that out for debugging. That would have saved me a headache! Other thing that burned me was shortuct creation. Three different example code blocks did not instantiate the shortcut object (but did for the shell). That's enough for it to be intentional, right? Wrong...

It looks like it's there to me?

Replaced old code with new code that works. Tried to anonymize the code too. Thanks to all who helped!

So, to the best of my knowledge, this code works! '==================================================================== ' Project: Company Operations Database (Office365 - Access 2019) ' Title: Company Operations Install Script ' Filename: CompanyOpInstall.vbs ' Creation Date: 09/26/2022 '...

Yep, stupid mistake! Whatever I had fixed another time introduced a typo in one of my variable names. Since that variable name didn't exist, setting the array just failed (without an error) and there you have it.

Wow, not you got me thinking I"ve inadvertently done something weird. Hmmm.... Ok, retyped out your sample code and it worked as expected. Now that I know that is WILL work, I can focus on why it's not working. Let me take a deep breath and find the probably stupid, obvious mistake I made...

It appears to do nothing at all. If I MsgBox arr(0) I get nothing (Msgbox doesn't call) If I try to step through the array using a For Loop, the for loop doesn't even start (I have msgbox's embedded in the for loop). If I change from using variables to using actual strings by adding quotes...

Nice catch! I've done some syntax checking and debugging and whatnot. Syntax-wise everything is good. But I'm running into some array issues. I had some variable scope issues that I've sorted out with the help of some msgbox calls. Anywho...here is the main question: Dim arr arr = Array...

No worries! That does look right. My first time using a variable array. I used that to replace a bunch of If/Else If statements. There's some bugs in there too I've debugged through (mostly) before quitting time. Hopefully, I'll see everyone Monday. I'll probably need an assist with the last...

This did work at some point but I haven't tested it after the modifications: '==================================================================== ' Project: Company Operations Database (Office365 - Access 2019) ' Title: Company Operations Launch Script ' Filename: CompanyOpLaunch.vbs '...