Search results for query: *

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

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

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

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.

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

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

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

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

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

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

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

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

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

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