Search results for query: *

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

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

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

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

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

Hi, Access XP. I have a form with a txtbox and button on. In the txtbox goes a membership number. The button opens another form an order form with certain information alreday filled in about the customer. I have a subform on this order form for the number of tickets the customer bought...

Hi, Acc XP: I am sure this is simple, but I am simple too and thats the problem! I have a list of customers with a unique customer id. I want to open a 2nd separate form which will show only the orders of the customer selected in form 1. As there are multiple orders for the one customer i...

Hi, Access Xp I have searched the FAQ's and the forums but cant quite find exactly what i am looking for. I have a form open with a customer Ref number. I want a second form to open at the same customer (which I can do fairly easily) The code I have currently opens the second form with only...

Hi, Access XP I have a db that has the refresh instruction on the forms timer event. The problem is that if a user happens to be typing in a text box when the refresh happens, the whole of the text becomes highlighted and on the next keystroke, of course disappears. Any ideas as to:- 1)Why...

Hi, Access XP I have a DB which is in use by 10 people max. When they each have it open obviously it wont update with the other users inputs until it is closed and reopened. I need to fix this. Does any one have any ideas how to? I would like to be able to put it on the forms timer event...

Hi, I have a simple formula that i want to return either red or blue as the font colour. Here goes....(in normal speak first!) If offered calls <1000 and ASA <20 then blue else red If offered calls >=1000 and <2000 and ASA is <50 then blue else red If offered calls >2000 and ASA <80 then blue...

Hi, I am able to get access (XP) to send emails aplenty, but what would really really be good is if when the recipient receives the email and replies it replies to a different address (ie a group) rather than the individual who sent it. I want replies to go to a group as the individual that...

Hi, Access XP I have a very basic understanding of VBA and I know what I want it to do but have not really the first idea how to do it. I have a form with a subform on it. The subform is in Datasheet view. The parent form has a button on it that when it is clicked i need to add the date and...

Hi, Access XP I have a form with a tab control on it. I have a number of tabs, one of which has a post code field on. What need to be able to do is search on that field, but whenever i try i get a message from access saying "You Can't Use Find or Replace Now" Why is this? and how can I...

Hi, Access XP I have a table with tens of thousands of customer records in. I want a form with an empty text box that when I enter a phone number will check the table and show the records of the customer with that number. I am sure its simple, I have loooked in the forum but couldnt find...