Search results for query: *

Hi, I'm having a problem with .xdp files. We have a blank form hosted on a server data files are passed by e-mail 1. A User goes to that form fills it in and clicks submit 2. The form is then e-mailed to their line manager who opens it up reads what they have written adds some more then...

Hi all, We have a print server with several printers on it. I want to setup one of these printers (HP LaserJect 5100) for a specific job. this will require it to only print in A3 with duplex and a few other options set. the problem I'm having is that the printer seems to want to use "General...

Hi, what I want is for my end user to be able to click print and the printout will always come to a single specific printer on a A3 page with booklet printing. I have setup the printer so it only has A3 paper in it and it defaults to booklet printing the problems I am having are as follows...

Hi, I'm trying to get all the members of a group. most of the groups are in the Dept OU but there are some elsewhere. I am using VBA behind a Excel worksheet I have the following syntax that works: Public Function getUsersInGroup(strGroup As String) Dim myResults() As String Dim objGroup...

Hi Guys, I have a question about hyperlinking, I want to open a folder with a hyperlink and thats fine, easy job! However I want a select a folder/file within the folder I am opening, so for example I want to open: s:\data\Defect and then select the folder: s:\data\Defect\PHOTOS\ so basically...

Ok here is my problem, I am unable to use the Excel track changes in my application as it restricts other Excel functionality. so I have written my own VBA code to handle this, it works simply by using: Private Sub Worksheet_SelectionChange(ByVal Target As Range) so that when the user selects...

Hi, I'm trying to import values from a text file into a mySQL database, the table I'm using is ------- CREATE TABLE tblAllocate ( AllocateID int not null auto_Increment primary key, AllocatedUSer varchar(35), AllocatedComputer varchar(6), AllocationChecked date ); ------- and I'm importing...

I am writing an application (In Excel)and I want to be able to track what keys are being pressed form outside my application, so for examplle the user loads up the application, then uses another applicaition and presses CTRL + SHIFT + G Now I want to run a method in my applicaition so for...

Hi I am looking for some code to return some information about the computer that it is run on. I want to return: Computer Make Computer Model Computer Model Number Computer Serial Number I am aware that this information may not be avalable but I was wandering if anyone could help. Many Thanks...

Hi, The problem I have is this, I have a table as follows: AreaID - RoomID - RoomType 1 1 A 1 2 A 1 3 A 1 4 B 1 5 C 2 1 A 2 2 B 2 3 B 3 1 A 3 2 C 4...

What I want to do is loop through a variang number of controls that all have the same prefix &quot;select&quot; but with a incrementing number on the end. and if it is there it will be = to &quot;true&quot; here is what I have so far: for ($i = 0; $i < $howmanyfields; $i++) { if (...

I am trying to make a reusable bit of code that can (regardless of how many cols there are) make a table in HTML from a databas, What I have so far: $server = &quot;server&quot;; $username = &quot;user1&quot;; $password = &quot;pass1&quot;; $database = &quot;database&quot;; $tablename =...

Hi, I am Shelling two commands out to Dos and then exporting that into a text fille then reading in that file, Just wandering if anyone had a better solution. COMMAND1 Dir &quot; & Range(&quot;Search&quot;) & &quot; /A:D /S /B >C:\Temp\DirCommand.txt The /A:D will bring back only Directorys...

What I want to do is: I have Row 1 with information in it from Column B onward, I dont know where it finishes as it will vary. What I want to do is Select From Colum B to the last entry. I have found one way of doing this, with the command...

How can I create a loop that will go through each day in any se month and print that in column &quot;A&quot; and print what day of the week it is in Col &quot;B&quot; What I have at the momebnt is: -------------------------- Dim strDate As Date Dim strMonth As String Dim lngRow As Long 'Gets...

What I want to do is convert a remote computer name into the IP address for that computer so for example I want to turn: \\RemoteComputer into 192.168.0.1 The reason is that I want to ping it and I have only found VBA apps that ping the IP address only and not the computer. Note: I am aware...

I am trying to remoteply edit a computers registery in VBA (thru Excel). I only have one way of doing this at the moment that is using the NT Resouce Kit with has a reg.exe that does this, now I can shell that command out, but it is a ugly way of doing things. What I want to do: Read A Remote...

How do I get the user access rights for a folder, What I want is the list (it only needs to be read only) of a particular folder, and to get a list of all the groups that have access to it. Ie. Going to properties, Security, Permissions and getting that list

Is there a way to have a window always on top of another? I have created a image manageing application and the image is on one form in the backgound taking the whole screen, then there are up to 3 sepperate forms that are toolbars that the user can move arround, the problem is if they click on...

I have had a problem when trying to get my label (but same logic would work for a text box) to autosize dependant on what text is in there. I have found a simpe(ish) solution There are two text boxes - TextBoxA & TextBoxB then you type into TextBoxA and press a button it autosizes TextBoxB...