Search results

im trying to apply conditional formatting the box with the date in is all one date eg. wednesday 2/04/06 and i cant get it to sormat the sundays even if i use is euqal to Sunday ( as i think it evaluating the whole content of the dtae box )

im trying to apply conditional formatting the box with the date in is all one date eg. wednesday 2/04/06 and i cant get it to sormat the sundays even if i use is euqal to Sunday ( as i think it evaluating the whole content of the date box )

In a report it lists all the days of the month ...i need to make each sunday bold . The formatting in the report is day date . any ideas ??

Simple invoice but i need it to auto increment the invoice number im using Private Sub Workbook_Open() MyInv = Sheets("Sheet1").Range("A1").Value MyInv = MyInv +1 Sheets("Sheet1").Range("A1") = MyInv End Sub it works if i run it from the vb window but not when the invoice is opened...

or would it be possible to bind all the dates held in the database to the month of the system clock ( as they will be overwriting the existing 30/31 records for each client ) . as acompromise to having to enter all the dates for all the clients every month and amend hrs for the days. at least...

it would be 30/31 days as required so i suppose they would have to delete the 31st entry on months with only 30 days .

i have had a look at datepart.....i cant see how i would use it to do this . ive attached a screendump.....where the dates are listed i just need to be able to forward all the dates for that client to the next month

Hi i have a form with a subform ( displayed as datatable) the subform has 2 fields date and hrs . currently there are dates for the whole month displayed . what i would like to do is be able to forward all of the months in the dates to the next month I.E 22/7/06 would become 22/8/06...

ok im going to throw this open as the more i think about it the more difficult this is getting http://gcommercial.co.uk/cymorth2003.zip if someone could have a go with it the form with the problems is clients1 here the hrs for the month will need to be entered but the report will need to...

kobogear what have you updated on the index php? i make line 19 as if ( ($category_depth == 'products') || (isset($HTTP_GET_VARS['manufacturers_id'])) ) {

maybee not duplicating the previous months data, but i am at a loss on how to clear the current months dates and insert the next months dates with least amount of input by the user but of course it would mean still going back through each client and entering their new hours per day at the...

i would have though that you would only have to change each months details if they have cancelled an appointment or increased their hours. the previous months totals would not have to be kept, as records will be kept on hard copy. I.E if joe bloggs gets a visit of an hour every other day and...

i did have my subform in datasheet view in version 1 this did work untill all the dates had to be cleared and new dates for each client entered the beggining of the month. I was trying to avoid that as it would be just as time consuming as the present 'by hand method ' if you have any...

raskew I must agree that usabilty has to be a fundamental feature of any solution designed . The problem i had was that they required to have all of the months dates listed , even if the patient was not visited . This in turn had its own problems with data input. So in my mind i thought that...

The majority of the patients either have the same amount of hours per day on the same days ( or day intervals) each month so apart from amendments or cancellation the reports would be the same just the month would be different .

they should yes but even then they would have to forward the dates to the next month ..this is why i tried the pull down idea ....... this data does not even have to be recalled ...it just needs to print out every month and be moved on one month ( this is why i thought it would be...

ok union and crosstab never been there....im totally in the dark here. i didnt think it would be so difficult ....hence my first version that you manually entered the date of the visit into, this worked untill the next month where the user had to change 30/31 dates for each patient . ;-)

wel i have given it a go and im going to have to admit defeat on this one if anyone knows how i can do this ( i have no knowledge of VB at all ) it would be greatly appreciated . The problem with adding up in the previous solution by raskew is that i have a field for each day and the query is...

cheers will give it a go many thanks

they are on the form they just appear as combos on the reports thats all