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

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

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

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

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