Search results for query: *

Help! Help! Help... Please? For some entirely inexplicable reason the excel 2000 spreadsheet which contains all the work I need for a presentation has become corrupt and is throwing up a Dr Watson error (access violation?)... is there any way to recover any of the workbooks without having to...

Thanks, it probably would have taken me a while to work that out. Followed your directions and everything is working fine.

Thanks, This looks like it should get the result that I need without the need for writting to much VB. I'll look up UNC Path, thanks for the tip. Look out for my follow up post "Using UNC Path to recognise network diretories"

Hi, Can anyone help me with the following problem, I'm trying to link documents to an Access97 table using the following piece of code and I need stop files from being seen if they have already been loaded. Any suggestions on how I can do this, VBA's not a language that I've used much so...

Hi, I would like to store a lot of scand documents in an Access97 table. I've used the following code in the onclick event for my load documents button and it works fine, but I would like to amend it to stop files that have already been loaded from being loaded again. I know I could just...

Hi Trendsetter, Thanks for the help, it's very much appreciated, I've tried running with this and I'm still geting the same error. I think that this is because the underlying sub reports return an error value in their Sum total fields if they dont find any records matching the required...

Hi Trendsetter, At the moment if I run the report and there are no records in either of the sub reports I get the message "#Error" in both fields. I assume that this is because as you state, Text11 is returning a null value so the following calculation is failing. I assume that you...

Hi, At the moment if I run the report and there are no records in either of the reports I get the message "#Error" in both fields. I assume that this is because as you state, Text11 is returning a null value so the following calculation is failing. I assume that you meen the...

Hi, I have compiled a report based on two sub reports which allows me to count the number of records in each sub report and return the following values: 1. Total No of records Control source =([rptDeadlines Met].[Report]![Total Day's Active Grand Total Sum]+[rptDeadline not...

Thanks Nevets, Thought that was the formula I wanted, but wasn't sure. Re-checked and turns out I had made a typo on one of the fields. (school boy error) Thanks again, Roal

Thanks, I've tried using DateDiff, but I'm not sure how I can get it to look up dates in a table rather than prompting the user to enter a date. Other than that it worked fine... Roal

Hi, I am trying to find out how many days fall between two dates stored in a table so that I can show on a report whether deadlines have been met. I.e DateReceived and DateReplySent. I need to look these dates up from a table (tblCorrespondence), in order to generate a report and was hoping...