Search results for query: *

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?

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

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

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

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

It has been an extremely long time since doing anything like this in Access.... I need to create 3 different tables or could be 2. Basically the end result is a form that shows two sections... one being advances and the other being reimbursements, therefore I thought the main form/table would...

There are two subforms: "Advances" and "Reimbursements" on each form there is a field named "RequestedAmt" as well as a field named "CalandarYear". What I need to do is have a field on the main form add all the amounts from the "RequestedAmt" fields from "Advances" and "Reimbursements" where...