Search results

thanks for the info regarding declaration of variables ive tried the code (took out the email option cos it only confuses the issue) but all it seems to do is print out the same letter for the number of oustanding accounts -- all with the first record details ( i placed a text box in the last 2...

i tried the code but it just prints out 3 of the first letter to the fiirst account

can anyone else help me with this

this is the program i hope you can make sense of it

oops didnt see the difference lol i tried your but it only prints out the first record - i tried putting the loop back in but then it goes back to printing all one report for all records

you mean not use Else ?

i cant use one report cos they are all worded differently depending on the number of days oustanding . the code is supposed to check howe many days is outstanding and print a report worded for that timeset unforunately it seems to skip this and just print the first report for all the records i...

i have a from that shows records split into 3 catergories namely 7, 14 and 21 days overdue and i have 3 differnt reports to match. these are catergorised seperately with tick boxes when i click the command button a report is printed - 3 different reports to suit the 3 different catergories...

this is he code my query pulls out all the outstanding accounts from my main form the code also splits accouns to those with and without emails Function BatchPrint() Email.SetFocus 'Stop error if email isnt sent On Error GoTo Error 'Check for over 21 days If Date > StartDate + 20 Then...

i have a form that contains three types of records i.e. 7, 14 and 21 days overdue accounts. i click a button to batch print all overdue with the appropriate report but instead of printing the right letter to the correct overdue stage it prints all records with the first report

so are you telling me that i was barking up the wrong tree right from the beginning cos as gemma -- or dave says this system really causes problems if i need to correct something in a previous record -- should i be looking at deducting totals to get the appropriate number -- im presuming this...

but if you delete any other than the last record you will still have a gap? if you delete the first record then your next sequence for a new record will still be six?

but if you deleted the first number out of 5 -- wont that still leave a gap cos the sequence will start at 2?

whats the difference between a sequential number and an autonumber - arent autonumbers unherently sequential by nature -- tell me if im being a pain at this stage lol

damn - id already anticipated gemma's point about duplicate dates and decided to go the autonumber route - now you tell me thats not safe either lol - well at least i got an answer and i learnt something thanks for your help

thanks scooter that works perfectly - so just to recap - i was originally going to use DLookup but after reading post on here regarding that function it seemed that everyone said that DMax was a better option - would it have been simpler to use DLast? my assumption was that on a new record the...

here is the actual part ive been having problems with -- not the same names as i mentioned in my first post but it shows the problem i have - only entries to CashBank seems to work --and then only when it is a poistive number

ok ill try and answer all questions together -- the calculation is EndBalance=StartBalance+Payment - -so that if the payment was actually a deduction i would just put it in as a minus figure. Atomic does mention something that rings true since this is just a simplified version of the whole...

Consider the following -- a table with StartBalance, Payment and EndBalance. for the next record i want the end balance of the previous record to become the start balance of the next -- i use DMax("PrevousBalance","tblFloat") this works fine until i put a minus number in the payment box -- why...

just what i wanted -- works great - but i think ill adjust it somewhere so that i only have to give the opening date and let it work out 7 days from there itself either at the query level or the report vb - thanks for setting me up on the right track oh you mentioned setting the form up as...