Search results for query: *

Hi, Im not sure if this is what Im after - but I am interested to know how you call 1 script from another? I have tried the following: $PSScriptRoot = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition $PSScriptRoot+"\UserCreation.ps1" Both scripts are in the same folder but it...

Hi, Im trying to build a menu system within powershell to do various functions and Ive hit a bit of a stumbling block. I was wondering if someone could assist me with it and say where Im going wrong please? $MainMenu= wrte-host ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...

How do you edit a post?

Hi guys, Im trying to create folders and copy files to a users appdata folder but Im not getting very far. Can someone please put me out of my misery - here is where I have got to Dim objFSO, objWsh, appDataPath, pathToCopyTo, plainTextFile, plainTextFilePath, htmlFile, htmlFilePath Set...

Thanks both - I managed to sort it by using the command function. I've only just learnt this feature\function so I don't want to try and run before I can walk :) but thank you hilfy for the extended explanation - I will investigate :)

Hi, Am I correct in thinking that I should be able to either create an SQL Expression Fields "value" which contains my SQL code and then use this on a report? Also are the joins in my tables relevant to the SQL query if the statement contains the join criteria? For example I have tried to...

Hi Its defined underneath Dim allPrinters(99, 2) ->> Dim foundFlag

Hi Geates, Thanks for looking at this 'Printer Install Set WshNetwork = WScript.CreateObject("WScript.Network") Set oPrinters = WshNetwork.EnumPrinterConnections Set WshShell = CreateObject("WScript.Shell") Set objWMIService = GetObject("winmgmts:") Dim allPrinters(99, 2) Dim foundFlag Dim...

Hi All, I'm trying desperately to delete a local IP based printer from some workstations. I don't want to delete ALL local IP printers just one that's been replaced. When I call up WshShell.Run ("rundll32 printui.dll,PrintUIEntry /q /dl /n " & chr(34) & "Printer Name Here" & chr(34)) It...

Cheers Pete, I literally put into the report what you suggested to get the values and it worked. I think what I am doing wrong is trying to put all values into the report rather than doing it piece by piece, having some values which are incorrect are nulling the report and that is why I think it...

Hi Pete, That's correct "{User_Values.Text1}" will hold more than just the User ID for a particular Employee Record. It also stores the record for all the separate tables which relate to Text1 for example Customer, Customer Invoice (as shown in the image below) and also Text 2, Text 3 etc for...

I thought I had in my second post, but anyway. Just incase I didn't explain it properly. Based on the above image I have 2 tables which are joined as above. What I am trying to do is get a value which is stored within User_Values.Text1 that links to the Employee table, specifically the...

Thanks for the suggestion, Ive just watched a video on sub reports but Im not entirely sure how this would achieve what Im trying to do. I need something like a dlookup to lookup the value on the User_Values table where user_values.text1 is equal to the link value which joins the Employee from...

Sorry that should be user_values. text1 I couldn't see where to edit the post

Hi, no sorry I'm not trying to get the windows account onto the report I'm trying to get the user_values.text value based on the a formula which makes up the first name.last name from the employee table. Thanks

Thanks for the reply Charliy, here is how the tables are linked User_Values are custom fields within the database, Ive used User_Values.Text1 to hold a value for an ID number which links to the Employee table. I know this because if I go into the applications front end within the employee...

Hi, Im trying to work out how I can get an user ID onto a report. The relationships on the tables have been setup and Im confused how to create the formula. I've created a FullName formula and what I would like to do based on the result of that formula is look up Text1 value on table...

Hi..... I was wondering if anyone could assist? I am trying create a VB Script which will print a file to a pdf printer. I am currently using PDFCreator but can change and I am not getting very far at all... Any help is greatfuly appreciated.

Hi, I am extremely new to VBS scripting and would like some help if anyone's up for it? I would like to map drives based on users group membership. I kinda get how its done but would need some pointers. Can anyone guide me through the process? Im keen to learn and understand vbs scripts as it...