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 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: pvcc
  • Order by date
  1. pvcc

    Problem printing large report with images

    I’ve created a 2-page report going to 3000 clients (7000 pages ). Page 1 of the report contains typical text and numeric data and page 2 has an individualized map (based on 3000 .jpg external files-each file about .8MB). The problem is that after approximately 200 pages the map image no longer...
  2. pvcc

    Custom Validation Criteria Problem

    Gavin, I overlooked the ignore blank checkbox. Once I removed the check the data validation worked as expected. Thanks for your help.
  3. pvcc

    Custom Validation Criteria Problem

    Gavin, I tried =AND(B2>=0,B2<=15,ISBLANK(C2)) and still do not get an error message when I enter a value such as 25 in cell B2 and C2 is blank. I also tried =AND(B2>=0,B2<=15,LEN(C2)=0) and again do not get an error message when I enter a value such as 25 in cell B2 and C2 is blank. any...
  4. pvcc

    Custom Validation Criteria Problem

    I am trying to apply a custom validation criteria formula which allows a value in column B between 0 and 15 as long as there is no value in the corresponding cell in column C In the custom formula I have =AND(B2>=0,B2<=15,C2=””) when I enter the value 25 in B2 and C2 is empty the value is...
  5. pvcc

    Creating Hyperlink using VBA

    Tony, the files weren't in the same folder when the hyperlink was originally created. When the hyperlink was created with both files in the same folder the hyperlink opens the second workbook. Thanks for your help, Roy
  6. pvcc

    Creating Hyperlink using VBA

    I'm trying to create a hyperlink in one Workbook to open a second workbook. As part of the code i have the follwoing lines: strFileName = "SmithJobDesc.xls" Activesheet.Hyperlink.Add Anchor:=Selection,Address=strFileName,TestToDisplay="Position" When the code is run a hyperlink is...

Part and Inventory Search

Back
Top