Search results for query: *

Arr I got it now. I wasn't binding the combo box properly. Once I'd set the record source correctly it's updating into the table properly and saving how I want it too Thanks for your help kjv

The calendar control's source is blank. I'm not sure I know how to change that! It's so frustrating. I change the combo box to a text box and it again seems to work fine and brings the date through properly but when I try to bring it through in the query I get nothing As soon as I overtype...

Hi Kjv thanks for your reply I've not considered a text box but could give it a go. On Mouse down I have set the value of the combo box to equal the value of the calendar control. As I say the date appears to update properly as puts a revised date in the combo box The problem could be record...

Ok I have a relatively simple problem I think! I am using the Calendar feature in Ms Access and a combo box to input dates into my form (The form is called Main) I have got it all working so when I select a date from the calendar it updates the combo box. But I simply wish to save the date so...

Apologies.... Yes the Cap / Rev field contains only Cap or Rev. I'm not quite sure I understand your next point but never the less the code you gave me worked and thanks very much. I've combined it with an AND command on my other report and it's all working great So thanks Again.

Ok the the report is sorted by Area and then Cap/Rev So I have North Area Cap projects grouped together Then North Area Rev Projects grouped together etc In the footers of "CAP/REV" and "Area" I have inserted a sum command so this then gives me a total for Cap and Rev and then a total each...

Ok bear with me I'm not great with Access! Basically I have a report which has the following headings Project, Area, Cap/Rev, Actual, Budget, Forecast The report is sorted via Area. (North, Central and South). I then have the report subtotalling using footers to bring through North Cap, North...