Recent content by chrish47

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...