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: *

  • Users: sramey00
  • Order by date
  1. sramey00

    pdf api

    hey all, i'm looking for some direction as to where i can find information regarding the adobe pdf api... basically i want to write a prog to automate the removal of multiple pdf's passwords. i have adobe pdf 7.0 installed. will that have installed the references for vs.net?
  2. sramey00

    excel opened successfully

    Ok.. Heres the code incase anyone needs this.... The text file is created from a password cracking program and i use that file to locate the encrypted files and save them as an unprotected version of it... this is by no means to be used as a password decrypting program. the user has to supply...
  3. sramey00

    excel opened successfully

    ok so i think im a bit tired. apparently, my testing wasn't correct and vbscript DOES raise an excel error through vbscript... all that for nothing!!
  4. sramey00

    excel opened successfully

    Mrmovie, thats a good idea. let me see if i can rig somethin to work with that. i still think there's a way to access excel's err.num, but i dont know the proper propertes to reference... i.e objexcel.err.num is my ultimate goal!!
  5. sramey00

    excel opened successfully

    Yea that doesn't work. i've tried that. the workbooks.open is a sub and doesn't return a value...
  6. sramey00

    excel opened successfully

    hello, I have some code that reads a tabbed delimited text with a file path to an excel document and also the password which opens that doc. the script is to open the excel file and save it to a different location without a password. It's working now and I am adding error logging incase the...
  7. sramey00

    recursive loops and counting

    i am using a recurisive loop that counts all items in the folders. when it completes, i would like it to give me a total count. Sub ProcessFolder(ByRef StartFolder As Microsoft.Office.Interop.Outlook.MAPIFolder, ByRef RootFolder As Microsoft.Office.Interop.Outlook.MAPIFolder) Dim...
  8. sramey00

    change password via vba

    figured it out!!! these two lines needed to be changed... CurrentDb.NewPassword "level1", "" 'change database password. can't unless db opened as exclusive. CurrentDb.Close needs to be changed to: ACC.CurrentDb.NewPassword "level1", "" 'change database password. can't unless db...
  9. sramey00

    change password via vba

    found this on a different message board as to why i was getting the dbengine error... manually registered the dll and it stopped the error. http://forums.oracle.com/forums/thread.jspa?threadID=316255&tstart=1 Hi, I believe you are getting the "Method 'DBEngine' of object '_Application'...
  10. sramey00

    change password via vba

    no one has it open and there is no ldb file in the directory. this problem has been troubling me all day!! when i comment out the code line: Set db = acc.DBEngine.OpenDatabase(oldDbPath & "\" & strDbName, False, False, "MS ACCESS;PWD=level1") the only error i receive is the "can't change...
  11. sramey00

    change password via vba

    i tried what changing it to true, but i still recieved the error of 'Error message for previous line: -2147221163 Method 'DBEngine' of object '_Application' failed Mr. Steve
  12. sramey00

    change password via vba

    I am on the right track here, however i can't get the database to open exclusively to allow password changes. can any point in the right direction? On Error GoTo errorhandler Dim strDbName As String Dim strOLDDB As String Dim strNewDb As String Dim y As Integer Dim acc As New...
  13. sramey00

    dtermine access DB version

    thanks... i have a few hundred access db which are password protected.. im trying to write this script which converts them to 2003 and unlocks them. any know how on this subject? i am having problems unlocking the file. im using DoCmd.RunCommand acCmdSetDatabasePassword to pop up the password...
  14. sramey00

    dtermine access DB version

    i would like to determine the version of access the database was created with. i tried using getobject("c:\...").version but that returns the current installed version of access. any help? Mr. Steve
  15. sramey00

    unset password / multiple database

    I have multiple mdb databases and i need to unset all the passwords in them. does anyone know of batch decrypters or some type of code i could write to unset the passwords without having to manually unset them? Thanks! Mr. Steve
  16. sramey00

    restore groupwise to different machine

    thanks for the info. i eventually stumbled upon that answer when i talked to ARCserve salesmen. we used a program called media merge pc and were able to restore it to a windows environment. however, groupwise encrypts everything so that it can't be searched through the file system. next agenda...
  17. sramey00

    restore groupwise to different machine

    I have some arcserve backups i am trying to restore using acrserve 9.0. when i try to restore them to my local machine (not the groupwise server backedup from) the last result states "crashed" but gives no explanation. can anyone direct me how to restore to a different machine outside the...
  18. sramey00

    automate save pdf from report

    here's the original post i found this process from... http://www.forumtopics.com/busobj/viewtopic.php?t=38099 "Instructions below are excerts from one of my specs. Basically, you tell it where to save and not to ask for a filename. Click on control panel and select printers. Highlight the...
  19. sramey00

    automate save pdf from report

    yea i found that process in a different forum... which i will repost here later... i am stuck on creating the folder dynamically based on the name of the file. i think i need a little clarification from management about this issue! Thanks for your help Mr. Steve
  20. sramey00

    automate save pdf from report

    I have some code to create a pdf from an access report. this works fine, however, i need it to save the file automatically. here is my code: 'save default printer information to return to normal when done printing Set OriginalPrinter = Application.Printer 'set pdf printer Set...

Part and Inventory Search

Back
Top