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 Chriss Miller 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: ohmbru
  • Content: Threads
  • Order by date
  1. ohmbru

    Alternative Forms

    Other than InfoPath, what other packages are available for publishing forms for a Sharepoint list, etc. Brian
  2. ohmbru

    Compare two documents

    I have Adobe Acrobat 5.0. I would like write some code that will compare two documents. Does anyone know where I can get info on the syntax for this? Brian
  3. ohmbru

    Create file of directories

    I'm not sure if VBA is the way to go here, but I want to be able to create a file (csv, Excel, txt) that lists all files in a directory/drive on my network and include the file size and date. Brian
  4. ohmbru

    Insert Images (5.0)

    This seems silly, but I could not find a menu item that allows me to insert images into my pdf document. I have looked at FAQs and searched the forum. Brian
  5. ohmbru

    Page 2 of Grouping

    My report groups on a ClientID. Each client should get a detail list (1st page) and a second page that is static information, so page 3 would begin the second client, etc. I've tried to do this by putting a page break in the Client Footer and building the 2nd page there. It seemed to be...
  6. ohmbru

    Close DataSource

    Is there a way to close the MailMerge DataSource on an active document? Here is the code I tried, but it did not work: If ActiveDocument.MailMerge.DataSource.Name = "c:\pol.txt" Then ActiveDocument.MailMerge.DataSource.Close End If The code that follows this copies a file as...
  7. ohmbru

    Print Specific Page of Word Doc

    I want to print a specific page of a Word document using VBA to interrupt the normal print command. When the user clicks the print button, I need to print the document in this order: Page 1 Page 2 Page 1 Page 2 Page 2 Can someone point me in the right direction? Brian
  8. ohmbru

    Bookmarks - Can't find File

    I have created a user manual from Word. The entire manual consists of about 20 chapters, each a separate PDF file. I then created a table of contents that links to each chapter. Each chapter has a unique set of bookmarks that apply only to that chapter. I’m using the Open File Action in the...
  9. ohmbru

    Search Results Window

    I have noticed this irritating issue with the Reader 6.0 When I conduct a search on multiple PDF documents, the results window displays all the documents meetying the search criteria. You are able to expand the tree to drill down to the page/bookmark containg the results. When you do, the...
  10. ohmbru

    Flash drive with win 98

    My win 98 machine does not recognize my flash drive. Is there possibly a driver I could download? Brian
  11. ohmbru

    Hide and unhide all

    I have a document, and for reasons to lengthy to get into here, I hid all rows and columns one of the sheets. Now I can't fihure out how to unhide them. It is not allowing me to select all and get the shortcut menu. This is a development copy of the document, so I have not lost anything...
  12. ohmbru

    Variables in DCount

    Can anyone help me figure out what I'm doing wrong here: RecCount = DCount(strTotTableName & "!effdate", strTotTableName, strTotTableName & "!effdate = " & M & Y) strTotTableName, M, and Y are my variables. I'm sure this has to do with the quote marks, but I have tried several things and...
  13. ohmbru

    Compare 2 documents

    In Adobe Acrobat there is a feature to compare documents under the tools menu. Is there a way to automate this for a list aof documents? For example, compare: c:\Folder1\Doc1 to c:\Folder2\Doc1 c:\Folder1\Doc2 to c:\Folder2\Doc2 etc. The path and filenames would be...
  14. ohmbru

    Limit drop down list based on cell value

    Is there a way to limit the choices in a drop down list based on some other value. The other value could be a cell or another drop down. The dependant cell has a value of 1 thru 7. If the value = 1, then the drop down should be available to the user. Otehrwise, they should not be able to...
  15. ohmbru

    Variable in DMax

    I am having trouble with the variable at the end of this line: intCheckAppr = DMax("[tblCheckApprSum]![TotalChkApp]", "[tblCheckApprSum]", "[tblCheckApprSum]![operator]= " & strCSR) I think I am not properly closing. It works fine when I hard code it or reference the value from a form. Brian
  16. ohmbru

    Cummulative Time

    Can I format a field in my table to allow a value like 181 hours, 20 minutes, 13 seconds (181:20:13). I want to import this from an outside source and have limitations on the output format. Brian
  17. ohmbru

    Send Object code

    does anyone see anything wrong with my code? I'm getting a run time error 2487, "the object type argument fro the action or method is blank or invalid." DoCmd.SendObject acSenNoObject, , , "fname.lname@mycompany.com", , , "*** Weekly Workflow Reports...&quot...
  18. ohmbru

    SQL Statement

    I can't get this code to work. Can anyone help me determine what's wrong with my code? Dim TableName As String Dim strSQL As String TableName = Forms![frmUser]![UserID] DoCmd.OpenTable TableName, acViewNormal, acReadOnly strSQL = "SELECT * FROM TableName ORDER BY...
  19. ohmbru

    Variable name in DMax

    The following code is what I'm having trouble with. The value that should be returned is "1/27/2004" but I get "12/29/1899." There is only one record in the table. If I substitute the variable reference with the actual table name I get the correct value. However, I need...
  20. ohmbru

    Can't Assign a Value to this Object

    Oh, boy. I am at my wits end! I can't understand why this code isn't working. I have this bit of code that executes on startup. The variable EUser, Name, and Team are used on the form and I'm trying top set them in the OnCurrent event. I continue to get run-time error 2448, Can't Assign a...

Part and Inventory Search

Back
Top