Search results for query: *

Have now found the file, having worked through all the like user folders (there are several) - your locatio was spot on thanks. Can't explain why searching including system and hidden files would not find it however. Now back to the apps code to see why it should object to the file in the...

Thanks Tony, Excel opens showing personal.xls, that's why I assume there is one. No I can't think what might cause the problem either. personal.xls certainly shouldn't be a problem even if it is present, so there must be something in the opening script of the application that's doing...

Thank you both. I think both your answers were contained in my original post.

I have an excel vba application which has worked OK until someone created a personal.xls file. Now the application will not open with the message "runtime error 1004 method of object '_worksheet'failed". My first thought, delete personal.xls. But I cannot find it. It is NOT in the excel...

TheAceman1, sorry down the wrong track there. DOH! I had wondered if a simple 'Forms!Cases.recordsource="alternative query" in the first part of the code would do the trick, but it doesn't do anything. Thanks again.

Many thanks for the suggestions - I'll try them out and report back. TheAceMan1, there is only one form, that I want to open based on either the 'qclosed' query (as in the supoplied code), or another query. Not sure how your solution does this. The form is based on qclosed, but sometimes I want...

Hello, I have one form, and would like it be opened with a different recordsource according to a selection by users via another form. This code works fine to open the form, with the form recordsource being the query "qclosed": ' openforms_allclosedadult Function openforms_allclosedadult() On...

Thanks, but that would only count those that have been opened (i.e have a start date) and does not account for closed or re-opened dates in the other tables. They are in other tables becuase there can be more than one closed or reopened date for each case. If a case opened on Jan 1st, closed on...

I have a database structured as follows: tblcases (caseid, name, date) where date is the date the 'case' was first opened tblclosed (closedid, caseid, closedate) where closedate is the date the 'case' was closed tblreopen (reopenid, caseid, reopendate) where reopendate is the date the 'case'...

Thanks Zemp, The database is in A2K, I'm working on it in 2K2 and have not converted it as the user still uses 2K. I've got around the problem by using assigning macros to perform the button functions (opening reports) but clearly I would rather use code if possible. Thanks for the quick response.

Having recently upgraded to A2K2 I have had to revisit a database built with A2K. Everything works as before but, new buttons for (opening reports) added using the wizard in A2K2 don't work when the database is run in A2K (the customer is not upgrading). Any suggestions please as this is going...