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!

Search results for query: *

  • Users: Roal
  • Order by date
  1. Roal

    retreiving data from corrupt Excel bk

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

    File Manipulation

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

    File Manipulation

    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"
  4. Roal

    File Manipulation

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

    Loading Multiple OLE objects

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

    Access97- Report returning error as value

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

    Access97- Report returning error as value

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

    Access97- Report returning error as value

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

    Access97- Report returning error as value

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

    Access97 calculate how many days fall between two dates

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

    Access97 calculate how many days fall between two dates

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

    Access97 calculate how many days fall between two dates

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

Part and Inventory Search

Back
Top