Search results

I am trying to open up a form depending on the expiration date. I was opening expired record and due date that was [expiration] <date(). What I need to do now is give the expiration a month early. Ex: If the due date is 07/01/04 then I want the record to show on 06/01/04 to prompt payment one...

I have two fields Complete Date and Status. If the status is changed to Complete then the Complete Date will fill in with today's date. Any Solutions?

Rich, Thats gonna do it. Thanks

It is in an unbound text box. The text box read #Error.

Im not storing it in a table it on my form. The Scores are calculated on the form. Do I add this statement to the control source? I tried it and it gave me an error.

I have a form for evaluating our cleaning service. If the services total score is below 90% then it only gets that percentage of payment. If it is any where in the 90% range then they get full price. Is there any way to write an if statement saying If <90% then ContPrice * Percent, If >= 90% Normal.

Is there a way to have two autonumber fields?

Tried to add a save record to the event and I still got the message. I also got an error message for the code

I was getting the error message even after the data was filled in. I was making an adjustment with 200+ records already in the db the ShipTo was already completed. Can there just be another way to do this?

I have searched and did not find an answer. Does anyone know how the switchboard manager works? I would like my switchboard to flow like the one that access makes. My swithboard has passwords and graphics and I cant figure how to incorporate them into the access made swithcboard.

Sue, That worked the best so far, but I am still getting the message window. I will attach and see if anyone can help, it would be greatly appreciated!

No that didnt work. I keep getting this pop up window. Im still working at it.

Ok here is the deal. I added this code to the afterupdate of the field Private Sub UrgentDate_AfterUpdate() DoCmd.OpenForm "Emergency", acNormal, "", "[RequisitionInfo]![ID]=[Forms]![RequisitionAdd]![ID]", , acNormal End Sub Then when the form is filled in I put this code in the close...

I tried and the db flipped out telling me it was an unrecognizable db format. When i repaired it deleted the record that I was testing and its gone.

Ok i got it to open the form afterupdate. However when I entered the information and closed the form. The information was not stored in the correct record. It stored it in the first record of the table. I made the form and set the form to open by the ID of the orignal form to try and match the...

First post so follow me on this one. I am working on my purchase order form. If the employee needs the supplies ASAP I have an "urgentdate" field (date&time). If this field is filled then they have to explain why in the "emergency" (memo) field. What I was attempting to do is when the employee...