Recent content by Mindmaster

yes it works it works yes yes yes..... i needed to remove the ".Update" Now it works i'm so happy it does not display in the subform but i can fix this i am so happy thanks for you help it works yes yes yes... if by any chance you know why it may not be displayed in the subform...

i have changed the code to this and i now get the correct dates but with a gap inbetween each record the text is as follows: Private Sub Combo318_AfterUpdate() Dim db As DAO.Database, rst As DAO.Recordset Dim x As Integer, dtNewDate As Date Set db = CurrentDb Set rst =...

a bit of a break through i moved the .requery subform name again to before "end with" and i get the following 14/08/01 blank record 28/12/01 blank record 18/01/01 Blank record 15/02/01 Blank Record 22/03/01 Blank record i now its the smallest thing thats wrong any ideas thanks guys...

Kyle the requery between the .update and end with gives an error so had to take that out and but sadly still no joy

hi paul, still getting the same problem i understand the change buit still i get the weeks in blank records followed by the final date????? sorry i keep bothering you

Hi Kyle - your code works as did Paul's but the same problem but a little different one date flashes in the subform and if i go into the table after i have selected the number i get an interesting result and so far the best by far i have the number of weeks as blank records until the last date...

paul's code does work but it changes the date to the date specified in the combo box but it does not add records in the process so if i select 5 weeks it gives me the date as the first record- 5 weeks from todays if it is well write but i need it to added all the other dates into the before it...

No i have tried the other code but again i'm getting confused... The problem at hand is i have a main form containg customers details. on this main form i have a number of fielsds name address...etc and one for total balance the purpose is that we have a customer with a very outstanding...

thanks so much i'll give it a try. i have tried alsorts my last attempted included the largest if stament i have ever seen thanks so much i'll give it a try and let you know. thanks again

I am trying to right a piece of code for subform that will keep producing records in a sub until the date matches that which is in a box on the main form. The date however must be repeated in 7 day intervals from to days date for example: if todays date = 1/12/01 and the text box = 28/12/01...

Come on someone must have done this need to get it done before the weekends please help!!!!!!!!

okay specifics are combox- main form numbers 1-20 dates normal dd/mm/yy - default as 7 day intervals record number must = combox number thanks rob

thanks jim... specifics are i have a subform containing records of agreed payment dates. The dB is for repayment of o/s balance. The user needs to select the number of weeks then the function inputs sub records defaulted 7 days from to today and so on. example if user selects 10 weeks the...

Please Please take a look i am desperate for any input!!

Hi all Has any one got a function to their disposal to project dates into a subform. Needs to work weekly from date=(). And create records specific to value in combo box???? Thanks