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!

Recent content by JMSBR

  1. JMSBR

    Move Files to new folder

    Thanks jges, that was really helpful, we tweaked it a bit but the fundamentals are all yours. Final code is: 'find latest version of file, <fileName>_<rev.minor>.<file_extension> Dim strPath Dim FSO Dim FLD Dim file Dim strNewName Dim fileDic Set fileDic =...
  2. JMSBR

    Move Files to new folder

    Hi jges & foxup, thanks for your responses. jges - yes the underscore is the delimiter between file name and revision and there are never more than one underscore. foxup - below is the code so far, this all works fine if there are only files with the same name in the folder. e.g. abc_1.doc...
  3. JMSBR

    Move Files to new folder

    Hi I need to create a VBScript to automatically move files from one folder location to another. Unfortunatley the source folder contains mulitple versions of the same file and I only need to move the latest. The versions are detemined by an underscore at the end of the file name. e.g...
  4. JMSBR

    Crystal Reports - Formulas and Null Values

    Hi Thanks for all your replies, I broke it down in to its parts as suggested and if I evaluated the null first it started working. However because of the complexity of the script I ultimately went with lbass' solution and created a formula field for each field.
  5. JMSBR

    Crystal Reports - Formulas and Null Values

    Thanks for the idea, but unfortunately I have tried it and still have the issue.
  6. JMSBR

    Crystal Reports - Formulas and Null Values

    Sorry its a bit difficult to explain the problem. Essentially we have 8 address fields which we need to combined into the first 3 lines of the address. What I am finding is that if the criteria are met for the first section of code ie where {Contact.contact_sub_building} = {@Address 2} it...
  7. JMSBR

    Crystal Reports - Formulas and Null Values

    Hi I am having a problem with a formula which is in a formula field on my report. The formula does what I need it to if I change the report options to "Convert Database NULL Values to Default" and evaluate the fields with <> "". However for other reasons I need to be able to evaluate Null...
  8. JMSBR

    OR Statement In Crystal Reports

    Hi lbass Thanks for your response, I was out of the office yesterday so couldn't get back to you. In answer to your question both parameters are multiple values. I think I have found the solution but I don't really know why it is working. Can you shed any light on it? I have basically added...
  9. JMSBR

    OR Statement In Crystal Reports

    Hi I am trying to write a formula to return results where the following conditions are true: x = True y = True x and y = True The formula below seems to only return: x = True x and y = True But not just y = True. // X (If ("Commercial Property" in {?Events and Mailings}) then...
  10. JMSBR

    MS Outlook Print and Send

    Hi We need to create a "Print and Send" button in Outlook which will send the email and then print it. It sounds easy but the crutial thing is that it needs to print after it has send so that it prints the Send Date etc. Has anybody got any ideas for a VBA solution or seen any software that...
  11. JMSBR

    Problem with Record Selection Formula in Subreport - AND / OR

    Thanks, you don't know how much that has helped. It would have take me ages to get there. Thanks again
  12. JMSBR

    Problem with Record Selection Formula in Subreport - AND / OR

    What I am trying to acheive is to return rows when {address_Cross_Referral.rd_A1_ReferredBy1} = {?Pm-fee_earner.fee_earner_name} and then any of the following are true: 1) {address_Cross_Referral.rd_A1_ReferralStatus1} = "Pending" 2) isnull ({address_Cross_Referral.rd_A1_ReferralStatus1}...
  13. JMSBR

    Problem with Record Selection Formula in Subreport - AND / OR

    Thanks for your speedy reply Unfortunatley neither idea worked, which I just don't understand. I added the formula fields to try and simplify the selection formula. I started off with: {address_Cross_Referral.rd_A1_ReferredBy1} = {?Pm-fee_earner.fee_earner_name} and ( (...
  14. JMSBR

    Problem with Record Selection Formula in Subreport - AND / OR

    Hi Please could you help this has been driving me crazy. I am trying to filter a subreport using the Record Selection Formula. I have created 4 formula fields which Return "Print" or "Don't Print" depending on the formula. What I want to do is set up the forumla so it only prints a record if...
See more

Part and Inventory Search

Back
Top