Search results for query: *

Hi All, I've hit a bit of a roadblock as there are Text files that reside on a SharePoint drive that I initially was trying to download using the method below Set req = CreateObject("Msxml2.XMLHttp.6.0") req.open "GET", url, False req.send Problem is there is security that is preventing this...

Thanks combo, I tooled around and am just doing a Access.run "procedure" and putting the openform inside the Access procedure, seems to work but I'll be finding a use for your suggestion later on as well. Thanks!

Thanks Mark, the .Close prompted an error for me but .Quit seemed to work. I'm just having trouble with the form commands, meaning getting a specific form to open and close. Mainly trying Access.OpenForm "Formname" and DoCmd.OpenForm. Any thoughts on that bit? ThankS!

Hi everyone, I've managed to run the access application I want from vbscript but am having a little trouble with the next steps. I'd like to close a form (if it's open) and re-open it from an external vbscript. Is this possible? Many thanks!

..._ "{\f2\froman\fprq2 Times New Roman;}}" & _ "{\colortbl\red0\green0\blue0;\red255\green0\blue0;}" & _ "\deflang1033\horzdoc{\*\fchars }{\*\lchars }" & _ "\pard\plain\f2\fs24 Line 1 of \plain\f2\fs24\cf1" & _ "inserted\plain\f2\fs24 file.\par }" I then...

Thanks for the response guys, yeah the yellow isn't that quite intense, I see what you're saying though! I did actually dive into the windows themes to see if that would be a viable option and things like high intensity black does change the font, the only problem is that it disables the...

Thanks for the response! Yeah I'm not sure, there's no looping being done and I do release the word objects at the end of execution so it's a bit bizarre. I implemented calling the code from a vbs as a work around and that seemed to work :S

...it. I suppose ultimately my question is, is there somewhere a setting that no matter the document they open that all font shows up as black? *I don't have access to change the templates anyway as it would have to go through an IT request I'm pretty sure, so I was looking for a quick...

Hi all, One user has been experiencing this error that isn't recreatable by other users or myself and happens pretty frequently with them. It's happening in an Access Function where I pop-up a word document and automate some bookmarks within it. That error pops up and references this line...

Hi guitarzan, thanks for replying. That's actually the first thing the script is doing so it's tripping right at the start, it's being executed through the PCOMM environment as a .mac file, written in vbscript. I might be able to generate a better worded error if I have the user run the script...

There's a strange error occurring but it's only happening to some users and not others. They're all running the same OS and same lotus notes version. It's prompting an error on this line Set notesuiworkspace = CreateObject("Notes.Notesuiworkspace") The only thing the error says is: Error...

...just as easy... Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colProcesses = objWMIService.ExecQuery("Select * from Win32_Process Where Name = 'notepad.exe'") For Each objProcess in colProcesses objProcess.SetPriority(NORMAL) Next Any ideas would...

Beautiful, works like a charm as always, thanks again!

Yeah, sorry Guitarzan, I just had a bit of trouble applying it to the area I was trying to apply it for! I'll give it a try again and see if I can work out the kinks. Thanks for your help, again!

Sorry Guitarzan, missed your post. I have something like this going at the moment IF i2C = 6 THEN s1C = s1C & "<TR><TD>TEXT GOES HERE</TD><TR>" END IF So basically it's just slotting in this text once it gets to button 6, I'm just looking to customize the font of the "TEXT GOES HERE"...

Thanks Geates! Managed to have it work decently, not sure if it's possible to change the font and font size of the "insert text here" in the same spot? My knowledge is very limited as I've leveraged this code from elsewhere. Also, not a huge deal but when I try and center the "insert text...

Hey, I was just wondering if anybody knew how to add text in between a row of buttons? I've tried things and haven't been successful as of yet :( basically what I'm trying to achieve is button 1 button 2 button 3 Set of text here button 1 button 2 button 3 button 1 button 2 button 3 Set of...

Thanks for the reply guys. Jges, unfortunately I was looking to utilize a script so I could run it automatically on someone else's PC so downloading a program isn't the most feasible. Thanks

Hi all, I have pilfered through a lot of posts but can't seem to combine exactly what I'm trying to do. I have a bit of code here but basically, instead of the .txt files I want it to cycle through every file in each folder and match them against each other. If the file doesn't exist in the...

I have been invoking this vbscript from another vbscript using the following Set WSHShell = CreateObject("WScript.Shell") WSHShell.Run "wscript " & strFileName, 1, True (Tried the value as 0 as well but same result as below, and the msgbox that returns the value inside the msgbox script also...