Search results

well the problem is, im using the calendar to update the records shown in a subform- this works perfectly, but only when i make all of the options (text boxes, combos etc) in the original form unbound. if they are bound to the values in the list then it doesnt work. what i want to be able to do...

what code do i need to use to copy the info in an unbound combo box, to a record from the click of a button? i ant to keep these field unbound by the way. thanks Adam

ah, ok this poses a new approach to the question then. i want to do 2 things with the calendar. 1- i want it when selected to update the current record (containing a date field amongst other fields) to that date (this has been no problem, when i "add the record"). 2- i want it to display all...

oh wait just noticed, i did what you said in OnUpdate, is that the same as AfterUpdate? i can't find AfterUpdate anyhow.

yeh i tried that and it does seem to work. i put forms!RedsForm.RedsFormSub.requery into AfterUpdate and it doesnt seem to change the subform. by the way - if i set the date on the calendar to a different date, then close and then open the form again the records in the subform DO change to...

I need to update a subform each time a differen date is clicked, but there is no onClick in the prefrences of Calendar Contol, so i can't work out how to do this. Could someone please help. Its driving me mad. thanks adam

its the calendar control 11 thats built into access by the way if that helps

no luck, any ideas?

thanks, but there is no onclick event on the calendar control? there is onEnter and onUpdated, i'll try those and let u know if any luck. thanks

i've managed to make it display by date selected, but when i change the date on the calendar it stay on the original date selected- i remember something from a while ago when i had to do something similar, and i had to use some code i think to make the subform change when i change the selection...

how do you do a requery?

is it possible to use calendar control 11 to select records in a subform that are from the date selected (there is a field in the recordsource table with the dates for each record). so when you click on 1 date in the calendar records from that date automatically appear in the subform from that...

ok i'm really confused by normalization, but i am very tired so i may try reading about it again another time. but... if i created a table with fields child date card code then used the right queries, would that be alright for what i want to do? orwould that cause problems? also...

i will try and have another look at normalisation, i had a look a while back and didn't get too far. thats kinda why i was hoping someone might be able to make a suggestion on how to structure this. then maybe it will help me with the normalisation. see i was never sure if i was doing the right...

ok - i've made a couple of databases for my workplace (a secure unit for 11-14 year olds), and they have really helped out. I hadn't really used acccess before but thought i would give it a go. anyhow, these databases took me hours and hours, because i was learning how to use access whilst...

ok, well stupidly enought it is a report not a form, sorry my bad. but i sorted it kind of anyway. i worked out it was the grouping on the report, but it had the date grouped by month, so i changed it, to by each yeare, which kinda solves the problem for up2 a year, at which point it shouldnt...

I have a form that has a running sum on it of a value. each value has a date attached to it. so for example Childs name 1 week start points total points -relevant values for that child- Childs name 2 week start points total points etc etc etc...... so anyhow it appeared...

Ooops! Ok that bit was my bad. I had a bit f code i was trying to do earlier, to fix the problem, and i forgot about it. Just deleted it and it all works fine. Thankyou for your help:D

I hear i am to put it in the control source, but i am getting an error "#Name?"

yes this looks like what i need- thankyou. but where would i put this code on the form? how would i implement it?