Search results

just make a shortcut to the db and set it up to use the runtime environment, that way they can do nothing.

Hi Guys, I need to let a user put a value in a cell. If that value = anything other than say X then they need to be forced to put a value in the cell next to it. I want to enforce this so that they can not continue until they have but the comment in. Any ideas ? Thanks for you help

Not an issue as I am only adding to the 1st date of the month to begin each page with the first of the month. Then each page has its own constraints which deals with days in a month. For example I could use =DATE(YEAR('1'!$C$6),(MONTH('1'!$C$6)+1),DAY('1'!$C$6)) with $c$6 being a set start...

Hi Guys, I am using excel and I need to do something that should be simple but seems to be hard grrrrrrrr.. Ok I want to take a date and simple add a month to it ?? Any ideas ??? I am sure this is easy but need help ..:cool:

make sure whatever form you are using to set your first vaiable stays open. For example if you have a main menu which is where the select their compnay then it needs to stay open so you can reffer to the variable. Then simply set the criteria in the query.

Are you using a query to generate your report data ? If so then simply count the records before you group them and set colour to work on count. ie is count is 1 then black, if >1 then blue.

Cheers that worked a treat.. Yeah I forget about version info .. will make sure I include it next time . Thanks heaps for your help, it is often the simpl things that make all the difference.

Hi Andrew, You would think so but ... this is access 97 and there is no conditional format option in teh format menu, any other ideas ?

I have a report and in the report I add two cells togeather. I want to make the result chnage to red if negative and stay black if positive, any ideas on how I do this ? Cheers,

thanks for that, worked a treat

Hi Guys, I am trying to make a report in access which gives me results in a table. Basically I have a table : TABLE1(ID_Num, Area, Colour, Num_Of_Doors) and what I am trying to get is a report that says: Number of Doors .............Green....Red...Blue...