Search results

Compile Error: Can’t Find project or library Date() function quit working. ACCESS97 It took me quite awhile to find all the information needed to solve this issue. So I am repeating (plagiarizing) it all here to help the next person. Got most of it from The_Doc_Man & Pat Hartman This is a...

Using Office 97 Computers were updated from Win98 or NT to XP and worked fine for several weeks but had date() issue again. Went into tools - references MSInfo MSIAV Category module was missing so fixed that Also had Microsoft DAO 3.5 Object Library so changed that to Microsoft DAO 3.6 Object...

Wayne, Thank you will try it. Am kind of a slow learner. Sure appreciate your help. Paul

Think I mixed report & subreport Wayne, What I meant to say was I need to grab a subtotal from each subreport and add to the report. Example. Report Subreport 1 Manager1 Cust expected order total Manager2 Cust expected order total Subreport 2 Manager1 Work...

Sorry not sure even what to search on in the discussion area for this. Figured out how to put three subreports on one report but now I need to add numbers from each report for a grand total at the bottom. Could you direct me in the right direction? Paul

Rewrote as solved part of it... We have a report that can be run between two input dates. Query gives data by customer by employee by manager Report summarizes data by employee by manager by total shop 1. Need query to ask Forecast hours for each of 10 employees and 3 managers (Managers...

Thank you Pat, Searching through help files sometimes is difficult. I spent over 2 hours today and almost gave up before finding out how to use the date input for use in the query automatically in the report. Will take your advice on naming and use your information. Paul

I have spent several hours looking for this answer in the Discussion group as well as Access help. Am sure its simple I just must be dense. 1. My query is leaving out items that do not have an "InsCode" in the Claims table. Not sure how to fix it. The field is not required in the Claims...

Thanks DOC MAN, There are only 5 files in References. 1. Visual Basic for Applications 2. Microsoft Access 8.0 Object Library 3. Microsoft DAO 3.51 Object Library 4. MSInfo MSIAV Category Module 5. Microsoft Calendar Control 8.0 So will try swapping them out. As noted before couldn't find...

At work I have inherited upkeep on a 97 access database and we plan to convert to office 2002 and want to "upgrade" the database. Thankfully in the "query" forum they helped me with references problems but it opened my eyes to another potential issue. One of the references was msiav.ocx which...

Lost reference after unclicking it? Thank you, I had read several dozen messages before asking. But don't have any modules set up, finally figured out I could CTRL+G get to reference area. On my machine where date worked fine but Calendar had started acting up it stated "Missing Microsoft...

Using Access97 the criteria is (Date()) And ([EDJC]) Database is multiuser setup on Server. Any computer using Win98 works perfectly. 2000, NT, and XP give error "Function isn't available in expressions in query expression "(((Schedules,SchDate)=(Date()) AND ..." If I change it to NOW() the...