Search results

if anyone does have this problem I have already solved it ! so here's the remedy. In VB stop the application and click on the module, then go tools references and remove the reference that is causing the problem. Matt

Hi Folks, I have recently just installed SP3 to Access 2000, since then I get errors when opening forms with auto-filled date fields. I get 'Can't find project or library' then when I open Vb to debug it stops at : Function AHSys2TxtDate() ' for this to work the host PC must be running UK...

:/ lol, jesus yeah !! thanks mate, I have to get more sleep :o

Hi Folks, You know when you have done something loads of times and then just forget how to do it !! thats what I have done. I have built my query, and I want the report page I have just created to use that query . How do I get the query box up when in report design view so I can drap and...

Hi Folks, As I think I have been going down the wrong route to find a solution to the following problem, I will tell you the scenario and see if anyone has any bright ideas ... I have a table which contains supplier id and customer Id fields, both of which are the same !! the reason being is...

AncientOne You're a star, worked great !! Thanks - Thx to everyone else who helped as well

Sorry about getting your name wrong (late night) I have tried doing what you suggested yet as I'm not sure how to combine these queries

Thanks Ancient- suspected this was the solution but I thought I was doing it wrong because of the join error. I'll have to learn how to nest these three queries then !! Unless you can give me a bit more info or point be to any good resources on the net !! Cheers

Hi All, Got a prob with my Query, I have 7 tables - three of which are tables which just break the many to many relation of the other four tables (as u can see from attached screen shot) Not many drawings have both project ID / Cad ID and spec ID data related to them - but the query is only...