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!

Register Log in
  • Congratulations derfloh 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

    ...from: " & strPassList txtLog.writeline "Save As Location: " & strSavePath txtLog.WriteBlankLines(1) txtLog.Writeline "Starting: " & now() & "****************************************************************" ON ERROR RESUME NEXT DO WHILE txtofFiles.AtEndOfStream <> TRUE IF...
  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

    ...LEN(strPasswordPath) - INSTRREV(strPasswordPath, "\")) 'MSGBOX strPasswordPath & vbcrlf & strPassword & vbcrlf & strFileName '********include error checking here to identify if excel opens correctly**** objExcel.Workbooks.Open strPasswordPath,,,, strPassword...
  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

    ...As String Dim strNewDb As String Dim y As Integer Dim acc As New Access.Application Dim db As DAO.Database strDbName = Dir(oldDbPath & "\*.MDB") ' Retrieve the first MDB file entry. 'Loop though the files in the folder to find MDB files. Do While strDbName <> "" ' Ignore the current...
  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