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 derfloh 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: *

  1. buckeye77

    Issues with records

    #1 solved.... after pulling what little remain hair I had out.... #2 still a mystery but will keep working... if anyone has suggestions or thoughts, I am wide open.
  2. buckeye77

    Issues with records

    2 issues that I need to fix #1) how do I write code to say that once leaving a field, if the field is null, make it 0. This is in the event the user deletes an amount instead of making it zero #2) I need a way to give a yes / no box to the user (yes = cancel record) if they leave the subform...
  3. buckeye77

    sort a combo box

    Tried everything I know how... sorted the main table, made a query and sorted the query / saved, but nothing seems to be working... Combo Box: Employee The list needs to be alphabetical by last name, even if the names are entered out of order on the main table. Any sugestions?
  4. buckeye77

    Run Report with several options

    Okay... I have got a combo for each [FullName], [year], [month]. Now how do I write a code that will allow any mixture of the three? I.E. John Doe / 2008 / August All / 2009 / September Jane Doe / 2008 All / 2008 etc..... From what I can find this would be done in the where clause, but how do...
  5. buckeye77

    Run Report with several options

    In a nutshell... Report "Advance" I need to be able to run this report either by [FullName] and/or [Year] and/or [Month]. (would be nice if each of these could be a drop down - there are fields on the tables that hold this information) Also, in the event one field is skiped in the selection...
  6. buckeye77

    Complex If statement

    Other than finding that I needed to take out the grade portion (found that the "grades" part just makes the "scheme" not work for what I need).. the formula works great! thanks!
  7. buckeye77

    Complex If statement

    The current if statment is in the form footer and works great... =Sum(IIf([CalandarYear]=2008,[AdvanceAmt],0)) However as with everything, someone has thrown in a wrench... The issue is that another field [RepaymentAmt] has been added in the event the entire advance is not cleared...
  8. buckeye77

    Don't save complete record -

    Thank you all! The "undo" takes care of the problem. When I corrected my original formula with Golom's help, I found that it was not "undoing". However, with the "undo", no records are being saved. Thanks again to all for the help! I have been away from access for a long time and it is like...
  9. buckeye77

    Don't save complete record -

    I have never been to good at the "public" items. Below is something that I have been playing with that may be a start... any suggestions? __________________________________________ Private Sub Command14_Click() If Me.txtFirstName = Null Then Select Case MsgBox("record incomplete need...
  10. buckeye77

    Don't save complete record -

    How do I tell a form that if field [txtfirstname] is not complete, then don't save that record on exit or closing of the form? Perferably a pop up box (yes / no) notifing the user the record would display. Yes = exit and not save record No = cancel the exit and go to the field txtfirstname I...
  11. buckeye77

    DSUM

    Thanks for the thought and warning that adding captions may not be very satisfactory, however at this time, I think it is my best option. Can you assist?
  12. buckeye77

    DSUM

    Slightly new question.... if the subforms are displayed in datasheet view, is there a way to change the column headings? Already tried changing the caption in the tables and already tried changing the "name" in the design portion of the form.
  13. buckeye77

    DSUM

    Works! But how? Something to do with null values? Regardless... Thanks again!
  14. buckeye77

    DSUM

    Sorry to keep posting but thought this may help someone help me.... The amount will show in the main form, only if both subforms have amounts.... but if only one or the other, the main form does not add.
  15. buckeye77

    DSUM

    Found an issue.... I added another subform that has the same formula, only this subform is "reimbursements". Now the main form 2008 =[frmAdvance].Form!Text23+[frmReimbursements].Form!Text23 The problem is that even with a "refresh" on the on exit of the subform of advances, the amount...
  16. buckeye77

    DSUM

    Thank you sooo much! Getting Goose bumps.... slowly working... Now to see if I can use this to work with the other subform.... Again, thanks!
  17. buckeye77

    DSUM

    Problem... In the subform, the feild is [curAdvance] and in the detail portion of the form there is also a field [calandaryear]. [2008] = =IIf([CalandarYear]=2008,[curAdvanceAmt],0) How would I sum [2008] for the form? It keeps showing #ERROR when I try.
  18. buckeye77

    DSUM

    Is there a way to have "DSUM" add all the numbers of a particular feild of a subform for the current record only? I.E. Person A in main form 2008 = 2000 in subform Person B in main form 2008 = 4000 in subform If I have a DSUM in an unbound in the main form = DSUM([2008]), regardless if...
  19. buckeye77

    creating tables that will be a subform

    Okay.... Here is what I have so far.... tblAdvance AdvanceID - PK - Autonumber intEmployeeID - FK - Number dtAdvance CalandarYear curAdvanceAmt txtCourses txtGrades txtCourseStudy comGraduated txtDegree txtComments tblEmployee EmployeeID - PK - AutoNumber txtFirstName txtLastName txtMiddleInt...
  20. buckeye77

    creating tables that will be a subform

    That was my next point... either in the table or in the form when entering data, I need a field to display how much total (advances and Reimbursements) were paid for 2008, 2009, etc. Therefore, I was going to add a field named "calandaryear" because even if requested on 12/15/08, it may be for...

Part and Inventory Search

Back
Top