Recent content by mincher

Brilliant - solved in 60 seconds :D :) Many thanks Colin of Essex!

I have two tables: o Staff table with list of all staff o Job Position table with all positions held by staff and linked to former by unique staffID (this also has date of appointment for each position) How do i design a query to return a list of all staff with all their most current position?

Ken, Worked absoultely fine though no need to to recreate the relationship as they were tied in a 1-to-1 relationship already. My big lesson is never accept long questionaiires with large tables - it creates merry hell working out what you are trying to query! Thanks :D Paul

Not that many - around 170. Minch

I have been involved in a nightmare project for a while; databasing a very poorly designed questionairre... The database consists of many large tables linked in a 1-to-1 way. It works but i would have it done it better... However the problem is now querying across different fields with the...

the command button presently results in an enter parameter value dialogue box appearing (which will work if i manually typed in a correct value). On similiar working forms, this button picks up the values from an unbound combo box via running a macro which picks up the displayed value from the...

I am editing a activity tracking database designed by an old staff member - i cannot link the command button pick up the data from the combo boxes. The command button open macros which semi-automate this process. On other forms, the buttons work but these might not have been copied. Does...

I am trying to enable our outreach workers (children's sector) to carry an information database on the lightest possible computer/PDA. What is the cheapest/easisest solution? They do not have to edit just search and demonstrate... I know there is limited possibilities.... Cheers Paul

thanks for you time

Dear Missinglinq ...i think it should convert fairly correctly i am told by a voluntary group who produced it in seatle... my email is paul.mincher@britishlungfoundation.com if i can send it directly as it is just over the file limit size for posting... cheers Paul

sorry the zipped database is just a little 2 big to post...i can send it direct if you can help out...

Could anyone convert this database from 2000 to 97? I work for the British Lung Foundation in London and we have not upgraded yet... Many thanks in advance Regards Paul Mincher