Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cosette00
  • Order by date
  1. cosette00

    External Data Import - Major problem

    Duane, Thanks. D.
  2. cosette00

    I would like to activate the visibility of a header depending on the null value of a cell inside it

    I haven't tested it yet, because the memo field became a huge problem and the headmaster had a panic attack. But the header is minimal at this point. I am sorry I should have clarified. D.
  3. cosette00

    External Data Import - Major problem

    Duane, For every subject (math, science, history etc...) there are long narratives in memo fields. Every header has at least two or three memo fields that are being cut off. The full memo field is in the table, I tested them all. So every header section has a few memo fields within it that...
  4. cosette00

    External Data Import - Major problem

    There is a further problem here. I just ran a simple report with two of the fields that are cut ff in my main report, and in a basic report, all the information displays. How can the same table generate a correct field in one report and a cut field in another?
  5. cosette00

    External Data Import - Major problem

    Hi All, I have read many posts about the external data imports. I am importing Excel spreadsheets into tables. I have created the tables in Access already, and have defined the columns as Memo fields when the excel cells contain paragraphs. Yet, when I run the reports, the cut at 255...
  6. cosette00

    I would like to activate the visibility of a header depending on the null value of a cell inside it

    Hi, I have GroupHeader2 which has inside it the textbox student. I would like all of groupheader2 to not show if student is null. So I selected the 'on format' event for GroupHeader2 and entered the following code: If student is null then groupheader2.visible is false else...
  7. cosette00

    Creating a master report from multiple full length reports

    Duane, I worked out everything regarding the sub reports. Thank you very, very much for all your help. David
  8. cosette00

    Creating a master report from multiple full length reports

    Thank you Duane, I implemented your recommendation, and after a while to build the huge query (220 fields I believe) I created a report with 9 headers. The problem I am encountering is that parts of the 220 fields for Student A are actually showing information for student B. I don't...
  9. cosette00

    Creating a master report from multiple full length reports

    Sorry for the delay in reply Duane. I am not sure I understand what you are inferring. I have five subjects, each 3 to 4 pages. I create an unbound master report, and create a sub report for each subject, correct? What do you mean by creating sections of the main report? Thanks for...
  10. cosette00

    Creating a master report from multiple full length reports

    Yes I am. Every subject has narrative sections (that require memo fields) plus specific fields. The math report alone is 3 pages long, and same for three of the four others. Per kid, each total report is approximately 15 pages. If I create a master report, and bound the other reports as sub...
  11. cosette00

    Creating a master report from multiple full length reports

    I have created reports for five academic subjects: math, humanities, physics, foreign languages etc...They each run more or less the maximum length of a report (22 inches or so). Is there anyway to group all these reports into a master report? In other word, with the student name as an...
  12. cosette00

    Memo fields are being truncated at random

    Good evening all, I have a very simple query with many field (38 text fields and 5 memo fields). For some reason, the memo fields in some records get truncated and not at other times! I have read about access truncating memo fields, but this is simple. Everything is made to grow, there are no...

Part and Inventory Search

Back
Top