Search results for query: *

Some years ago using Access 2007 I built a database and when it was finished I hid the Navigation tools (form, queries etc) and the ribbon bar. Having re-established the link between the frontend database and data after repairing the machine due to virus problems I need to hide the ribbon so...

Thank you dhookom that is exactly what I meant. It does not take long to forget when you haven't done it for a while. Thanks again.

Some time ago I built a database with the front end providing forms queries and tables etc and a second database with the data. We had a Virus problem with the network and this was fixed but at the expense of losing the connection between the two databases. We got error messages “not a valid...

There is an attachment to my post with a simple example (Not the full spreadsheet)of what I am trying to do. It is called Annual_Uplift. If this is not accessible or seen please advise.

Thanks SkipVought and byundt for you inputs but I don't think I can be explaining myself properly. Putting either of the above 2 ideas into the spreadsheet is like hard coding the answers. What I want is something that is dynamic so that I only update the one relevant field in the income column...

Thanks for the idea and I agree it is one way of doing it. However, the next year it is not going to be 935 it will be 956. DOn't forget that the cells here are picking up whatever is in the cell on the income sheet so lets say when I get to next year and I want to enter the new figure for the...

I have a workbook that allows me to calculate the balances needed to fund my mother's care home fees. In basic terms there is a worksheet that shows her income for different sources and her expenses. Her income is usually uplifted by inflation each April. My problem is that if I change the...

Thank you for your help. I have found a way of excluding the heading cell by using the ISNUMERIC function [e.g. AND(H1 < Today(), ISNUMBER(H1) )]. Anyway I appreciate your help so many thanks for your patience.

No I am sorry I have clearly not explained myself well. This is a very straightforward worksheet where a task is assigned to someone and a review date for the completion of the task is agreed. So that it is easy to see whether a task is coming up for review or has past the review date etc. The...

Hi Andy Yes I accept that conditional formatting is an easier way of doing things and I have managed to get the colours to change based on the date. However, as I want the conditions to apply to the whole column (i.e. I have no idea at this stage how many rows will be used) I have found that...

Hi Andy Many thanks for your help so far. I really appreciate it. Right I have had a new look at the problem. The first thing I noticed was that I gave you some wrong information as the first row for dates should have been 3 not 2 so I have changed that. However, when I open the spreadsheet...

Thank you Andy I have done exactly as you said. I started a new macro, then stopped it. I went to the VBA window and in module1 this code was there 'Sub Macro1() ' ' Macro1 Macro ' ' End Sub' I replaced this with your code so it looked like this: Sub Macro1() Dim i As Integer i = 2 Do...

To PHV and Andrzejek thank you both for your inputs. PHV I would like to have used conditional formatting but I could see now way of doing it with date formats. Perhaps PHV you could help or point me to a good tutorial. Andrzejek Having said that I would dearly like to learn how to...

I am using Excel 2010. I have a column with dates and I want the dates (or the background cell color)to change based on whether the date is greater than today, less than today or today. I have had a feeble attempt at changing the color using this formula...

I am trying to develop a questionnaire on a web page that returns an email from the respondent back to me. I have a basic structure that seems ok but when I load it via ftp onto my site I get this error message: Parse error: syntax error, unexpected $end in...

Thank you all for your contributions. I have now used the solution =$A$40+A40)which seems to work. I am still tryng to develop my spreadsheet so no doubt will have other questions in due course. Thank you for your hel and interest.

In cell (say A40) I have a calculated figure of Fee plus VAT. This has to be taken away from an income figure but accululates each month. So for example the figure in January is say £126. What I want is in February this to be the January figure plus the same again in February and then in March...

OK - take the point - thank you anyway

Thank you - stupid me. Didn't realise about the quote marks.

Hi and thanks. Yes I did actually try this and for reason it did not work. I also realise that it is not strictly php but I wondered if because the file is a php file this had anything to do why it wasn't working. So for example amongst others I tried: <td> width="###">".$row['EventName']."</td>