Search results for query: *

I have a spreadsheet that uses the following formula to search for some text contained in a colum in a particular range and highlight the cell where the the criteria is met. =SEARCH(H$1,$C3) To improve this I only want it to highlight the cell if it is not empty. I have played about with...

I have used the following code to apply conditional formatting in a spreadsheet. Private Sub Worksheet_Change(ByVal Target As Range) Dim myCell As Range For Each myCell In Target Select Case myCell.Value Case Is = "Match" Range(myCell, myCell.Offset(...

Hi can anyone help? I work in a school where we have just adopted sharepoint and I am trying to keep up with user requests! I need to produce a survey type document, which will allow students to branch to a question a number of times i.e. which university have you applied to ....and following...

Is it possible to generate a start date for a task in a customised form? I am using the DateAdd() function, in the text box properties, with the following code DateAdd( "m" , -2 , [Start Date] ) but it just shows the same date as the start date instead of two months before. Any ideas...

I have a spreadsheet about holiday bookings. If the word 'Hot' is entered I want the whole row in a range of cells to turn green. If the word 'Warm' is entered I want the whole row in a range of cells to turn orange. I have created individual macros to change the range to the specific...

I have a query in which I have used DatePart to separate the day and the month from a person's date of birth. I am trying to create a report that will sort the birthdays into Months. I have tried using Date of birth - month but it still sorts into the different years e.g. jan 1990 Feb 1990 . ...

I have set up a simple mailmerge from Excel into Word. For some reason the date field is shifting e.g. In the spreadsheet DOB 1/12/1958 - in Word 12/1/1958 I have checked the formatting and regional settings - all are correct and in English format. I have solved the problem using the \@...

I have a spreadsheet that shows Effort and Achievement grades for a group of students Effort goes from A - D Achievement goes from A* - U the spreadsheet is set out ART - ACH - BIO - ACH I want to be able to count separately the number of grades each pupil has for their effort or...

I am using a 2003 MS Access database to store information from employees regarding health and safety issues. I am currently sending out a paper form, this is returned and I am filling in the data. As all employees I need to contact are using Outlook, (2003), is there a way to send out the form...

I want to compare a date with today's date and if the month is greater to put a Yes in a text box, if not no. I have tried the Iff function and DateDiff but I don't seem to be getting the syntax correct. Any help gratefully received. Cath

I have a form that is being used as a survey. I have a set the properties of one of the combo boxes to .enabled = false. I want the If an option button is selected the corresponding combobox should be enabled. It works the first time the form is opened but will not update if a different...

I have placed a button on a subform that goes to the next record. This works well, but you then have to click in the textbox (tabstop1) before you can enter the data. Is there a way to automatically have the first tab stop selected. Many thanks Cath

I need to open a form in datasheet view from the switchboard. I have set all the properties correctly and followed the advice given in thread thread702-823199 the only problem is that the default switchboard opens a password form for two sets of user Admin and Pupils. From there the...

I have built a database that keeps a record of the skills a student has used in a particular piece of coursework. The coursework_skills table has a primary key made up of SkillID and CourseworkIDNumber. Is there any way to create a query that will add all the possible skills automatically? I...

I have set up a database to keep track of the specific ICT skills pupils use in their coursework. All was going well until I tried to use an unmatched query to find any skills an individual pupil has not used. It keeps telling me I have ambiguous joins tables used pupil (1-m) coursework(1...

I have inherited a very old database that died, but I have managed to retrieve the data. Only one problem The date field is stores as a number (from 1/1/1970) I need to find out which date each particular number refers to. I have tried the obvious converting it to a date field. I also tried...

I have a simple form that lists training sessions someone has attended. Some have been paid for (shown with a tick box, some haven't. I ant to be able to toal the 2 separately so that I can take the paid total from the unpaid total. I know it must be simple, but I just can't think. The two...

Hi I have asked this question before, got a reply but I couldn't get the code to work. I have produced a very simple library database that I want to put on the school network. I don't want the pupils to be able to print reams of data about the books, just view them on screen. I know they can...

I have created a simple spreadsheet for a colleague that adds up all the data in 3 different columns. I am using =SUM(C2:C39,D2:D39,F2:F39) The total is displayed in a merged cell. All was working well, but suddenly it won't update when the data is altered. If you double click to enter the...

I have set up an electronic markbook in Excel, that will automatically produce reward cards for students that have achieved the correct number of A grades. Is there a way I can format the grades that have been 'used' so they are not counted the next time? Many thanks