Search results

I have rectangle object positioned 'behind' several fields on a report.... I wish to be able to hide these fields depending upon access rights.... In code am I able to bring the rectangle to the front and thus hide the fields in question... to save writing a routine to hide each control...

Right you are, thank you Brian.

=COUNTIFS(MONTH($B$6:$B$2057),"=2",$J$6:$J$2057,"=1") In a similar way I wish to count the occurences of February, where the 'J' column range contains a 1.... but Excel doesnt like this....any idea how I could that please..?

That is EXACTLY what I needed. Thank you very much:)!

Any chance of a sample showing the use of FORMAT over a range of cells please...?

I have a list of thousands of rows containing sets of daily records each with a datestamp... 1/1/2012 1/1/2012 1/1/2012 1/1/2012 2/1/2012 2/1/2012 3/1/2012 3/1/2012 3/1/2012 ......n I wish to deteremine the totals for each MONTH... so how would I create cells that contain totals for each month...

Thanks CJ, this put me on the right track. For the record, herewith the formula =INDEX($A$1:$A$151,H4+MATCH(F4,$A$1:$A$151 )) A1:A151 is my array, F4 is the value in the array that I am searching for and H4 is the offset I wish to apply.....

Hello All! I have an array of numbers represented in adjacent cells in a spreadsheet as so... 1,2,4,6,7,9,15,23,28,32 for example. I also have a pair of numbers. One number the array reference, the other the offset. I wish to be able to return the value in the array at (reference + offset)...

Mile-O Wow - thanks just what I needed! Cheers

Hi All I am trying to come up with a cell combo that will do the following .. When betting, sometimes it is necessary to consider a minimum stake. When the stakes are calculated automatically, it is necessary to round up the calculated stake in accordance and to the nearest unit stake...

Thanks, I have done it this way... theDate = DateSerial(!YearVal, 1, 1) FirstDayInWeek = theDate - Weekday(theDate, vbUseSystemDayOfWeek) + 1 newDate = DateAdd("ww", (!WeekVal - 1), FirstDayInWeek) Create the first day of the year, then calculate the actual first day of that week, then add 'x'...

Hi Having a mental block this morning....! Given a specific week no. for the current year... I need to return the first date of that week.... For example : week4 of this year (returns) 19/1/2015 Thanks G

Yes, because if I change the week value - the table is updated with this new value but the display shows that from the previous run....

I have a REPORT containing 7 ('columnar') subreports. Each subreport is to show showing a days worth of medical doses.... to visually represent a wall planner. When the report loads - user enters a week value # via Inputbox(). This value is written to a TEMP table. Each subreport accesses...

... need to use the Filter property for the MAIN form... on selection of the entry in the combo - set the ID for this selection to the filter property. Subform then refreshes as expected.

I have a form with a combo/dropdown on the MAIN form and a child subform. I have designated a Master /Child link of ID to FGId respectively linking the combobox with the subform. However, when a select an item from the combobox I expect to see the subform datasheet refresh accordingly. This is...

Hi I have been stumped by the following that I have attempted to solve with a SUMIF formula... I need to calculate the profit/loss for bets on Betfair. If you dont know - Betfair charges (nominally 5%) commission on the net profit only ie. the Betfair commission/fee is only charged after all...

Yeah thanks for the pointer, namliam. Done it now.

I have successfully used SUMIF to scan a column and using the 'criteria' parameter stipulated a date to sum values for each date entry in the dataset.... Now, I wish to do similar but I wish to count instances where a specific value has been exceeded...... So, consider several rows of data -...

Thanks for the input people - I have actually managed to accomplish most of what I wanted to do using the handy DoCmd.TransferText () method, the column and ordering criteria can be stipulated for the format of the output file.