Search results for query: *

#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 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...

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?

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...

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...

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!

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...

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...

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...

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...

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?

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.

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

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.

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...

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!

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.

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...

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...

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...