Search results

  1. O

    Field Required from other field.

    Wasnt sure were to put this, but here it goes. I have and two fields in my requisition table. One is EmergencyDate and the other is EmergencyUse. If EmergencyDate is filled in the EmergencyUse would be required. I searched the boards, but I guess I didnt know how to search it. Any suggestions?
  2. O

    Help at your liesure

    I am trying to create a db to keep track of my fantasy football stats. I have all my tables, I am stuck trying to find the right way to set up what I would like to do. I want to add all my players stats by play week so I can keep their stats along the season. I have 10 players but can only start...
  3. O

    Open Report Code

    After reading almost everywhere on this site to get rid of macros I am trying to write code for the simple stuff. Can anyone tell me what I am missing? I am trying to open the Building Info report based on the field "BuildingNo". Private Sub Command43_Click() On Error GoTo Err_Command43_Click...
  4. O

    What am I missing

    After reading almost everywhere on this site to get rid of macros I am trying to write code for the simple stuff. Can anyone tell me what I am missing? I am trying to open the Building Info report based on the field "BuildingNo". Private Sub Command43_Click() On Error GoTo Err_Command43_Click...
  5. O

    IF Statement

    I have been trying and searching for hours on this I cant find the answer. I think Im close, but cant get it to work. I have a two number fields. "A" and "B" and a result field "C". I am trying to write a statement that says If A is greater than B, C should equal the number 1. I am trying to...
  6. O

    Empty filed question

    I am creating a report with several fields that wil be empty. The problem is that most of these fileds are currency or numeric. When these fields are empty it shows a 0 in the numeric or $0.00 in the currency. Is it possible to keep this fields empty?
  7. O

    Multiple Criteria Report

    I have a form that runs a report using the dates entered (Begining Date and Ending Date). I also want to search by building. The user can select the building then by the dates desired. I know how to do them seperately, but I dont know how to do both.
  8. O

    Linking field from other table

    I have a number field from "table A" that gives a dollar amount. "Table B" needs to use that field as a starting amount to calculate the overall total. I can't find the correct expression to link a text box to that field from "table a". I can't connect the two using a query because when a new...
Back
Top Bottom