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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chrish47

  1. chrish47

    Digital signature not recognized after workbook is saved

    Jazzy, You are correct, anytime you make changes to a signed excel document, you have to re-sign the document or the signature will be discarded. This is to prevent anyone from altering a file that is digitally signed and using the original digital signaure as authentication (such as someone...
  2. chrish47

    Administering old Exchange postoffice

    Hi, If this isn't in the correct forum, I apolgize, but I am not sure which forum would be appropriate as I think I am dealing with an early version of exchange server (from windows 98). I have a client who has a 4 PC local network (users access the internet via individual dial up) that was...
  3. chrish47

    Which tool to choose for PeopleSoft Reporting

    jmanj, I agree with you that SQR is much more versatile than nVision (SQR is basically a report writing language, as such you can do just about anything possible thru normal programming methods - including API calls to other programs which extend the 'power' of SQR), however from an end-user...
  4. chrish47

    Which tool to choose for PeopleSoft Reporting

    nVision is really the best tool for reporting data from PeopleSoft in an end user 'usable' format. SQR's do great at extracting the information and displaying it in a printable format, but don't allow end users to manipulate/work with the data. nVision reports can produce printable reports...
  5. chrish47

    Changing Size of Named Range

    Skip, The range that was selected by the offset command still had a blank row on the bottom (and I didn't understand the offset command enough to figure out why). This is used in an nVision report (nVision uses Row 1 and Column A to store values used by the report generator - which may have...
  6. chrish47

    Changing Size of Named Range

    Thanks for the quick responses. I tried Skips suggestion, but the name wasn't visible, and I wasn't exactly sure what it was doing, so I tried PH's, and it would work except for some strange results. Instead of shortening the range by one row, it shrinks it by one, shifts it left one column...
  7. chrish47

    Changing Size of Named Range

    Hi, This is probably a simple question, but I can't seem to get it to work. How can I resize a named range to be one row less that it was previously defined as? I have a name "Trav" in a sheet that and this name is defined as ='Trav Data'!$B$4:$Q$6, a macro inserts rows from 5 to xxx, which...
  8. chrish47

    ERROR : Oracle LONG fields reformatted in PeopleTools 8.16 Query

    Hi, We are on PeopleSoft 7.52, and I have seen this same situation (we are on Oracle also). Unfortunately we haven't come up with a way to solve this problem. If you do find any soulution, I would appreaicate it if you would contact me or post it to this group. PO comments are stored in a...
  9. chrish47

    Very easy question on "Refresh"

    In the forms I build (with dynamic queries rather than filters) I use: Me.Requery - to re-query based on the changed data Me.Repaint - to update the form with the changed query data This works for me in most parts of my forms, but I had problems when I tried using filters also, so I just built...
  10. chrish47

    Inventory Entry Form

    After selecting the two listboxes, the records in the subform come from a SQL statement (selected from the Master list where Project and Account = what was entered in the listboxes). I think the subform is displayed as a datasheet (but I think I tried other methods as well). Currently the...
  11. chrish47

    Inventory Entry Form

    Hi, This may be something simple, but I am having problems getting it to work in Access. I have a master product list in one table (with a autonumber primary key). I want to set up a data entry page that selects a subset of the data (based on Project and Account fields in the table), and...
  12. chrish47

    Intermitant Excel Automation Error

    Thanks, That fixed the problem. I should have known it was something small that I overlooked. Thanks Again, Chris
  13. chrish47

    Intermitant Excel Automation Error

    Hi, I am fairly new to VBA, I know what I want to do, I am just having some problems getting there. I am creating a routine to automate inserting some data in to an Excel Spreadsheet. I have a "template" set up in Excel that contains format, layout, macros, etc. I want to find the...
  14. chrish47

    Corrupt VB help files?

    Hi, I ran into the same problem in our environment, we are on Windows 2000 with Microsoft Office Premium (whatever that means). I went thru the same things you are experiencing (having IT come over and Uninstall, reinstall, update, etc. with no luck). Finally, I "borrowed" the...
  15. chrish47

    App Designer - Query - Create Expression

    A solution with possible applications in future use. Set up a Tree to store the zip code information in. With Region 1 and Region 2 as nodes on the tree, the zip codes could then be entered into the nodes as either ranges or single values. This would look something like this: Zip Tree All...
See more

Part and Inventory Search

Back
Top