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!

Register Log in
  • Congratulations Chriss Miller 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: cantech2
  • Order by date
  1. cantech2

    How to convert Numbers to Words

    Dear M8KWR, I am VERY VERY VERY happy !!!! You have made my day. I discovered my error, I was to put the spellnumber in CONTROLSOURCE and not NAME field. I am in Nigeria and was able to edit the code so that my figures are now translated to Naira and Kobo. God bless you, Cantech2 (Humphrey)
  2. cantech2

    How to convert Numbers to Words

    Dear M8KWR, I am not out of the woods yet ! 1. I have succesfully create the module. Thx. 2. In the module, OBJECT reads General, while PROCEDURE reads SpellNumber. Are these alright or do they need to be changed. 3. In the properties box of the field in question, the tab called other has...
  3. cantech2

    How to convert Numbers to Words

    Thanks but I am still lost. I am a user and not a programmer and I would deeply appreciate your patience. Assume I am in the design view of my report, how do create a new module. Thanks
  4. cantech2

    How to convert Numbers to Words

    I have a field called GROSS in a report which is based on a mathematical calculation of other values. The value of GROSS therefore changes. I want GROSS to display word and not numbers. Eg if GROSS is 10200, I want it to be displated as Ten Thousand Two Hundred. I am a novice and need a clear...
  5. cantech2

    Commiting form field data to database

    Hello, I have a form called BILLS with a field called LABILL I also have a subform called LABTEST with a calculation field called TOTAL. I have set the value of LABBILL to be euqal to the calculated value in TOTAL. The above works well on the form but does not show up on displayed on the form...
  6. cantech2

    Modifying a field in a report

    Dear Jesse, thanks for your response I was hoping I would avoid creating a new field since the current field is part of a summation formula elsewhere in the report. Is it possible to apply a formula on the existing field. Thanks, Cantech2
  7. cantech2

    Modifying a field in a report

    I have created a report that works ok. I saved the report with a new name hoping to modift some fields eg. OLD REPORT has a field called [SALARY] In NEW REPORT, I want to multiply the value of {SALARY] by 2 or by 50%. What do I do Thanks, Cantech2
  8. cantech2

    Assigning Positions to Students per subject

    Dear Duane, thanks for your assistance so far. I have a tricky headache. Now, the ranking works on the whole table, which is fine. But if I put a criteria to give me the result for the boys only, it still gives me their positions in the whole class whereas I want to see the new position of a...
  9. cantech2

    Calculated data shows in form, but not in table

    I have a table called STUDENTS, some of the fields are SCORE1, SCORE2 AND SUM. On the form generated from the table, the control source for SUM is =[SCORE1]+[SCORE2]. This works nicely on the form but the calculated figure does not show up on the table. What should I do ? Humphrey.
  10. cantech2

    Assigning Positions to Students per subject

    Dear Duane, thanks so far. When I try to execute, I get the following error message: "You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one...
  11. cantech2

    Summation of report

    Next question: Now, on the same report, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page break after each...
  12. cantech2

    Grading

    Next question: Now, on the same report, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page break after each...
  13. cantech2

    Assigning Positions to Students per subject

    Dear Dhookom, thanks for your response but I am not clear on your solution. Please see additional information: 1. My table is SS1 2. My the score field on the report is English 3. The position field on the report is Position 4. If 2 people have the same score, they should have the same...
  14. cantech2

    Assigning Positions to Students per subject

    I have a class database from which I have created a report. Now, assume Jack, Jill and Bill are in a class and they all take Chemistry. Jack has 70% with grade A, Jill has 45% with grade D and Bill has 65% with grade B. Each of them has their reports on a separate page because I asked for a page...
  15. cantech2

    Summation of report

    Jim, thanks. I checked my table and they were text fields. I changed them to number fields and my report is. Ok. God bless you, Cantech2
  16. cantech2

    Summation of report

    I have 2 fields on a report, one is TESTSCORE (50) and the other is EXAMSCORE (80). When I create a text field on the report to add both fields ie =[TESTSCORE]+[EXAMSCORE], I get 5080 instead of 130. How do I resolve this ?
  17. cantech2

    Grading

    Thanks CajunCenturion, the switch function you gave was simple and perfect for my purpose. God bless you, Cantech2
  18. cantech2

    Linking combo boxes

    Dear Bluekestrel, your solution was wonderful. I implemented the combo box relationships and it worked. I was able to do this for upto 4 subcategory levels. Thanks and God bless you, Cantech2
  19. cantech2

    Grading

    Dear Jrbarnett, thanks for your last response. Was wonderful. Next issue: I could implement the event on the form. However, the grades do not show up on a report and I dont see the option to build an event there. How can I get the grades to function in a report. Thanks, Cantech2
  20. cantech2

    Grading

    In Microsoft Access, on a form where there is a score field and a grade field, how do I program the grade field to automatically display A, B, C, D, E or F depending on the value in the grade field

Part and Inventory Search

Back
Top