Search results

I have a main form called frmCustomer and a button that opens a second form called frmOutstanding3. While the second form is open over the first I have a button that prints a report (rptLetter3) for all records in the second form. However the code seems to be choosing records from the...

thanks for the reference - i can see how that would work but for me it is too long winded- my html programming knowledge is not great and would take me a while to create the page however its good to know it can be done and how - -thanks again for the info

but once that email was sent - how would outlook keep the text format for the next time? can it be saved somewhere? thanks for replying

im looking at doing something simillar cos people dont seem to want to open an attachment. is there a way to change font size and colour in the body to make it look more like a headed letter? thanks in anticipation

the program has decided to revert to just printing the first record for each pass again without me changing any of the code so its 1 step forward and 2 steps back it seems thanks for all your help with this sorry to have wasted your time

can anyone spot why its doing this??

the plot thickens - it works ok now except that i end up with twice the printing - it prints all the records in order - and then repeats - i cant se anything in the code that might make it do that

i did change from preview to print for that very reason - to see in black and white what the results were and it prints only the first record for each pass of the loop. maybe i should try loopng the two seperately after all ive had both procedures working at some stage -- just not together. i...

i thought i was there - seemed to be working fine and i changed the view to normal rather than preview -- turned out that all printing was for the first record - but it ticked all the boxes - i guess thats what you meant - if you have a better way of approaching this id be glad to listen - you...

thanks for your help with this matter - i think the main problem is the missing MoveNext statement as your explanation does point to the problem im experiencing but after inserting it before the WEND i get a compile error stating "Sub or Function not defined" as for your fifth suggestion im...

can anyone else help me with this problem?

i changed a few minor things to get the code to run for me but it stops at the line in red saying "item not found in this collection" i dont know if its significant but the actual name of the box has a lower case c but when i change it vb automatically gives it an upper case. i tried removing...

i have a form that contains records regarding overdue payments and a button that prints a letter to all records on that form - this works fine. i want to add another command after the printing command to tick a box indicating that a letter has been sent but when i add the command (straight after...

so if id taken out the "days" and left it as a number that would have fixed it too? when i wrote the query i set the criteria in one line with an - and - statement but it always ended up seperated into the other columns the idea of having both criteria was supposed to stop letter2 being sent...

thanks thats fixed it perfectly although im still not sure what you did -- i see the small module thats added - cold you please explain? also will i be able to place an if statement that will decide which case is being processed in order to tick the appropriate box automatically thamks very...

even when i change the dates to suit different catergories it still prints letter1 for all cases

yes and that does the same - prints the first report for all records regardless of date

the letter is based on due dates - i used the code to tick the boxes as the letters are printed so they wont be mistakenly sent again but again to stop confusion ive taken that line out what seems to be happening is that once its decided which if stateement to use for the first record - it...

i have no idea what you mean about deleting posts -- i wrote that post about 5 times and every time i reloaded the screen it seemed to have dissappeared - if i was that clever i wouldnt be on the receiving end of this forum lol anyway ive found my major fault with what was happening - the source...

thanks for the advice on declaring variables i tried the code but cant get it to do what i want - it still just prints the same report for the first record and not the chosen ones no matter what stage the date is at (i took out the email option to simplify the problem and placed a textbox with...