 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007my database stopped working after the 200th record, why
the table I created won't record a calculated field after the 200th record. Can anybody tell me how to fix this? > the table I created won't record a calculated field after the 200th record. > Can anybody tell me how to fix this? Tables shouldnt really have calculated fields ... keep the basic data in the tables and use queries to calculate on these fields. As to why it is stopping you after 200 records is a little weird. Could you provide some more details on what you are doing? I have a form set up that takes the students tuition for the year and separates it into billing for the semester. The formula is in the form. After the 200th record the table stopped filling in the price per semester. Can you help me with this? I would be greatly appreciatative. Tracy > > the table I created won't record a calculated field after the 200th record. > > Can anybody tell me how to fix this? [quoted text clipped - 4 lines] > As to why it is stopping you after 200 records is a little weird. > Could you provide some more details on what you are doing? > I have a form set up that takes the students tuition for the year and > separates it into billing for the semester. The formula is in the form. [quoted text clipped - 13 lines] > > - Show quoted text - Is the calculation VBA in the form? No it isn't. I am afraid I don't know VB. I am learning as I go. If you have any suggtions I would be grateful. I would love to learn VB is there a book you can recommend? Tracy > > I have a form set up that takes the students tuition for the year and > > separates it into billing for the semester. The formula is in the form. [quoted text clipped - 15 lines] > > Is the calculation VBA in the form? > > the table I created won't record a calculated field after the 200th record. > > Can anybody tell me how to fix this? [quoted text clipped - 4 lines] > As to why it is stopping you after 200 records is a little weird. > Could you provide some more details on what you are doing? > > the table I created won't record a calculated field after the 200th record. > > Can anybody tell me how to fix this? [quoted text clipped - 4 lines] > As to why it is stopping you after 200 records is a little weird. > Could you provide some more details on what you are doing? Hi Matt, I set up the formulas on a form. The formula was working until the 200th record. The price is showing on the form but it isn't populating the table after the 200th record. > I set up the formulas on a form. The formula was working until the 200th > record. The price is showing on the form but it isn't populating the > table > after the 200th record. Tracey, you can see your formulas, you know the structure of your tables, you know how your form is set up. We do not. Please post the expression or code that is doing the calculation, and describe the structure of your table. Remember: we are not at your computer; we're volunteers donating our time to help, not telepathic magicians! John W. Vinson [MVP] I'm sorry, this is new to me. My table is set up with the full tution cost in colume A, first semester cost in colume B and second semester cost in colume C. My formula is in the form and is as follows: [TUITION]/2+50 and [TUITION]/2-50. I hope this helps you to help me. Thank you, Tracy > > I set up the formulas on a form. The formula was working until the 200th > > record. The price is showing on the form but it isn't populating the [quoted text clipped - 9 lines] > > John W. Vinson [MVP] >I'm sorry, this is new to me. My table is set up with the full tution cost >in colume A, first semester cost in colume B and second semester cost in >colume C. My formula is in the form and is as follows: [TUITION]/2+50 and >[TUITION]/2-50. I hope this helps you to help me. You're thinking in spreadsheet terms. Will you never have a student who attends only one semester? Will Column A always be the sum of columns B and C? If so, it SHOULD NOT EXIST in your table, it should be calculated on demand! I'd suggest a quite different design: a one to many relationship from a table of Students to a table of TuitionCosts: Students StudentID <primary key> LastName FirstName <other biographical data> TuitionCosts StudentID <part of primary key, link to Students> Semester <rest of Primary Key, maybe a date field, maybe text such as "Spring 2007"> Cost <maybe other fields, e.g. reason for discount or waiver of fees> You'ld put two records in TuitionCosts for the two semesters, and calculate your expressions dynamically on a Form by setting the control source of an unbound textbox to your expression. John W. Vinson [MVP] Thank you for the information. I am going to try it and see what happens. I will let you know. Tracy > >I'm sorry, this is new to me. My table is set up with the full tution cost > >in colume A, first semester cost in colume B and second semester cost in [quoted text clipped - 28 lines] > > John W. Vinson [MVP] I tried what you suggested and it works! Thank you so much, Tracy > Thank you for the information. I am going to try it and see what happens. I > will let you know. [quoted text clipped - 33 lines] > > > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.