Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shabbarankers

    Powershell script with menu\console - struggling with the code

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

    Powershell script with menu\console - struggling with the code

    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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...
  3. shabbarankers

    Check if folder(s) exist - if not make them

    How do you edit a post?
  4. shabbarankers

    Check if folder(s) exist - if not make them

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

    Using an SQL Query to get field\table info

    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 :)
  6. shabbarankers

    Using an SQL Query to get field\table info

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

    Delete local IP based printers with a VB Script

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

    Delete local IP based printers with a VB Script

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

    Delete local IP based printers with a VB Script

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Formula to work out user ID based

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

    Help Needed - PDF Printing via command line

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

    Mapping Drive based on group membership

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

Part and Inventory Search

Back
Top