Search results for query: *

Hi....thanks for your responses. The table has a client id as primary key. It then lists all the teams they have been assigned to. This row comprises client id, team id, start date and end date. So it will have all teams in one table. I need to say in effect....show me the first team the...

Frederico - that seems to have worked!! Thank you! To help me learn from my sistake - what did I do wrong? Steven

Hi Frederico, Thank you for your time. As requested. . . select * from o_persons where per_id = '520980' and rownum < 10; returns. . . PER_ID PER_SURNAME PER_BIRTH_DATE PER_BIRTH_DATE_EST_IND PER_CLIENT_IND PER_EMPLOYEE_IND PER_FILE_REF PER_FIRST_NAMES PER_GENDER PER_INITIALS...

Hi, I have sql written which will brings me back all the current members of team ABC. In addition what I need is the team they originated in before moving to ABC. This may have been the team directly before or many team moves before. What I have so far is: -- Selects Non Employees from the...

Thanks, guys, I know that I am getting duplicates because I know that client 520980 has only 11 assessments. The results are:- p.per_id Full_Name ass.asm_subject_id Assessment Type 520980 FIRST TEST 520980 B.I.C.A. - FACE v6 520980 FIRST TEST 520980 B.I.C.A. - FACE v6 520980 FIRST...

Hi, I am fairly new to Oracle SQL and beg your patience with me. I have 3 tables joined, I believe, appropriately, but clearly not as I get far too many results. Here is the sql. . . SELECT p.per_id, p.per_first_names || ' ' || p.per_surname asFull_Name, ass.asm_subject_id...

Does anyone know how to fix the error in the database?? It saves all the 'events' to January. if this worked - it would be perfect for me. MAny thanks in advance. Steven

Hi, I stumbled across the link to referee assistant Calcontrol - and it is BRILLIANT just what I am looking for. However - 1 slight problem - when ever I click on a date the input box that opens has the wrong date at the top of it. It opens with right day but wrong month and day number. Is...

Remou - that is PERFECT! Just what I want. I will now tailor that and make it fit my requirements Thankyou so much. Steven

Hi, I have a simple database with contact information in it. The field that is relevant is LastName. I want to create a button (well 26 of them!) that will jump to the first contact whose LastName matches the letter M for example. If there are no Contacts with the LastName starting M then a...

Zameer, That worked a treat - thank you so much!! Cheers Steven

Zameer, Thanks for your prompt response. I have tried changing the default format and it still does not allow me to select the Make MDE File option - i have tried both formats - but neither works. Any other suggestions? Many thanks, Steven

Hi, Access 2002. I have created a DB that i have split - I want to make the front end an MDE - but when i go to select the option it is grayed out - ie not selectable - why might this be??? Cheers Steven

Hi, Acc XP I have a number of images on a form which look like buttons - but have better images. Their special effect is raised and to look at them they look very good. The on click code in them works great. But just 1 small thing i would like to add. When you click a 'proper' button it...

ACEMAn youre FANTASTIC! That worke dgreat. Thank you somuch. Its odd how something so little can drive you insane - and the answer is so simple! Thanks again.

Hi, Ac xp I have a form bound to a table. The form has a list of shows along with the date of the show I have an unbound check box in the header of the form that when it is ticked I want to just show the shows that have a 'show date' greater than todays date and when not ticked shows all...

Hi, Access XP I have a Continous form which lists all the different theatre bookings a customer has made. What I want to be able to do is sum the number of tickets by show. For example, if they have booked 3 tickets to see Cats on one day, 2 tickets to see Joseph another day and 1 further...

Hi, How can I resize the image I want to display on a button? I have the .bmp file saved, but when I attach it to my button the button changes size to suit the image. Then when I change the button size the image stays the same size thus losing most of the image. How do I change what is in a...

Hi, Access XP I have a form with a tab control on it. There are 7 tabs each of which is related to the main parent form. I have 6 users using the DB. Occassionally and with no noticeable cause it just locks the tabs and will not allow any further editing for 5 maybe 10 minutes - when it...

Hi, Access XP I have a button that emails a report using the SendObject action. However, our boys in IT have removed printing privileges from the team using the DB which causes errors when the email button is clicked. Even though the report is only email and not printed. Any suggestions as...