Recent content by crawfordfr

  1. C

    Solved The file operation was canceled. The filter would be too big!

    I know the question is solved but I wanna explain what I am doing since you say you don't understand. Basically, my account balances, arrears, interest balances and arrears are calculated on the fly. Its on a main screen where you search and find the client/file and then you see the balances...
  2. C

    Solved The file operation was canceled. The filter would be too big!

    I finally underestood what you were saying. I made a very complex query that basically achieved the same records I wanted in this report and then ran the report based on that. Made life so much easier not having to cycle through list nor build that file. Thanks. See I need someone too...
  3. C

    Solved The file operation was canceled. The filter would be too big!

    Not sure I understand BUT the string I am building is the filter for the report. The string is to identify the records! Remember each file can have many bills already generated so I must 1st identify the newest one! If I just open report without building this list it will simply print a...
  4. C

    Solved The file operation was canceled. The filter would be too big!

    Hi Not even sure this is the correct area but not sure where else to look. I did do a search in the forums for similar topics but didnt find any. Did google searches and found matches but no fixes that actually help me. I was thinking mayb the report area as well. Feel free to move if it...
  5. C

    Solved 2 reports on 1 page

    Awesome WOW that was easy BOTH answers pointed me to EXACTLY where I needed to be. Just by simply setting the colums to 2 it printed 2 reports to a page. Choose File » Page Setup and select the Columns page I should have joined this forum long time lol...Thanks again too both of you! FYI...
  6. C

    Solved 2 reports on 1 page

    I am not sure the heder is correct but basically I am cycling through a recodset and doing tons of calculation. At the end of the day I am printing an arrears report for every client id in the recordset that has either principal or interest arrears. the report is about half of a landscaped...
  7. C

    New Member

    My name is Francis Crawford. I hail from little country in Central America called BELIZE. I am 49 years old and last programmed in Access in Access '97. I have been tasked with updating to the new verswion and building new stuff in Access and am rusty and will have many questions. thanks for...
Top Bottom