Recent content by vipa2000

Hi Ken, I am using access 2000. Attachement will not open. Conditional formatting will not work if it is the inbuilt function. Maximum of 3 allowed and it does not work properly for some reason. Can you send a 2000 version if you have used code. I am basing this on multiple records. regards vipa

i have tried to piece together some code which will change the colour of a week number dependent on certain parameters. I am not a programmer, so please if it is poor,allow for the newbies on town. Here goes. I have two cells in a report one called 'year' and one called 'weekno'. i want the...

worked a treat thanks regards vipa

Am i thinking about this back to front. Should i use a combo box on a form, select the building no and then hit a command button to open the report which would then look at the query. On the query grid i would then set the criteria equal to the form? Only issue, how do i get my wildcards in...

Hi FoFa. I am slightly lost. Probably because i need this to be dynamic. In an ideal world i want to open a report which is based on a query and be asked to select a building no. Once this building no is selected which is only 6 digits long it goes away and finds for an example all tasks on...

I have a report that looks at a query. The base data contains a field called 'functlocation'. Now this data can vary in length and looks something like the following 12080026335PDPV5448-1 12080025507PUMP 12080004003BUILDINGS 12081925507PUMP 12081925507PUMP Now the first 6 digits represent a...

Access 2000 ThreeCow. Found a slight problem. I have used conditional formatting based on the week no and thought whow, but then realised once i get to year end we go back to 1. My format of Format(Now(),"ww")+1 goes to pot. Any ideas? Am i better creating another field with year or am i making...

thanks chaps, found a thread which had the right wording to allow me to further my search. Using Format(Now(),"ww") and conditional formatting regards vipa

Within a report i have a text box referenced 'Week'. The data from this comes from a query that references a cell called 'Week'. 'Week' gets it data from an adjacent cell called 'Lat#finish date'. It uses the code Week: Format([lat#finish date],"ww") to return the week number. I want for the...