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

    Acrobat Reader 9 & .XDP File

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

    General Everyday Printing settings

    Thanks Victor V, some good points that you raise, however this is a server that has all our printers on site on it (many different HP models). so I am unable to try and change values without risking screwing up other printers. I'm going to give up on this idea, its only about 3 more clicks to...
  3. Sylv4n

    General Everyday Printing settings

    by printer server I mean a network computer sharing many printers attached in LAN (PS1) I have tried to change the settings on the server, however I cannot change the default ones (called General Everyday Printing), I can however create a new "printing shortcut" and set all the options on that...
  4. Sylv4n

    General Everyday Printing settings

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

    Printing to a specific Printer

    Ok, I'm slowly making progress. I think they way I'm going to aproach this is create a button on the form to print with the following code: xfa.host.print(0, "0", (xfa.host.numPages -1).toString(), 0, 1, 0, 0, 0); now this is fine, it asks no questions and just sends it directly to the...
  6. Sylv4n

    Printing to a specific Printer

    The problem with that is that I am using the PDF as a form, and so all m users who want to print it get is a xdp file, and I guess if I try and print that directly they will get the equivalent of a text file rather than the Adobe form with the xdp data in it.
  7. Sylv4n

    Printing to a specific Printer

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

    LDAP subtree question

    Tsuji, That does solve the above problem, however I over simplified the question to writing my original post, in actual fact some of the departments do not reside in the Dept OU and they are more than one OU deep, so for example one may be in OU=Finance,OU=Dept whereas another could be in...
  9. Sylv4n

    LDAP subtree question

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

    Excel Hyperlink (Select a Folder)

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

    Locking the macros etc

    to open a sheet when a spreadsheet opens you need to go to the VBA Code of "ThisWorkbook" (rather than the code for a single sheet) then in there you can have Private Sub Workbook_Open() Sheets("Sheet3").Select End Sub where "Sheet3" is the name of your sheet and as for trying to lock macro's...
  12. Sylv4n

    Predict number of Rows/Cols of text

    I have worked up a solution that works it basically searches the clipboard text for 'vbLf' and counts how many it can find (the number of rows) then it counts how many 'vbTab' it can find before the first 'vbLf' (the number of cols) and Skip I even used the code tags =) Public Function...
  13. Sylv4n

    Predict number of Rows/Cols of text

    okay sorry for the late reply, Skip - for one cell ranges there is no problem becouse when they selct a cell I store the old value, so when its changed I can report what it was and what it is changed to. I have got that working xlbo - I am using the selection change event to store the values in...
  14. Sylv4n

    Predict number of Rows/Cols of text

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

    Problems importing from text file

    ahh figured it out, I needed to remove the end of line marker of '/r' and use '/r/n' which is a windows way of ending a file Working fine now =)
  16. Sylv4n

    Problems importing from text file

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

    Infinite WaitFor

    the only question I have is do you REALLY want a never ending loop, sounds like a bad idea, anyhow this code will continue to loop: While True 'insert code here Wend I'm just not sure thats what you want to do, a little more information on the problemm and I may be able to give you a beter...
  18. Sylv4n

    Global Hotkey

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

    Return Computer Info

    Wow thanks Mikaki, I must admit I had given up hope of finding this information. So all this informaiton is comming from the BIOS? Is there any other particularly usefull infomation that I can pull out of there? Good job :) :) Many Thanks Sylvan
  20. Sylv4n

    Return Computer Info

    that is why I am colecting this infomation to put into a asset register, we are using the opertunity of transfering everyone to XP to ensure that the asset register is up to date.

Part and Inventory Search

Back
Top