Recent content by outlaw318

The field is only going to be required based upon another field. If someone puts in the emergency date then they must fill out the emergency use.

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?

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

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

Its telling me there is a data type mismatch in the criteria expression.

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

Thanks worked great. I kept trying to add = "1" at the end. All I have to do now is figure how to keep a running total. For a "Win-Loss" Record. Thanks

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

It didnt work when I tried it the first time, I used the other code and it worked. Thanks

It worked for the currency, but what about the numeric field?

THat worked perfectly, thanks

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?

It keeps telling me that there is an error.

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.

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