PEB,
I can't thank you enough, it worked like a charm! I am discovering that in order to customize Access you need to know VB, which I need to learn. I do understand the over all concept of programing but I do not understand the ME! that preceeded the field names.
Thank you very much!
Robert
Pavkovich
Last Activity: Sep 27 '06, 06:47 PM
Joined: Sep 20 '06
Location:
-
setting a date field in a form when clicking a yes/no box
I have tried to set a date field when I put a checkmark in a yes/no field. In the date fields control source I put the following: IIf([SetDate]=0," ",Date())
Unfortunately using Date() simply changes the date each time the day changes. I want to store a date telling my when I put the checkmark in the yes/no field and I don't want that date to change. Using Date() changes it each day. How do I set the date field to todays date when... -
Thank You worked like a charm. I tried the IIf command but must not have had the format correct.
Now I have another problem, the form is only showing me 3 of the 10 records I have in the table. It was seeing all 10 before but I don't know why it is only seeing 3 now. I veiwed the table and all 10 records do exist. Any thoughts?...Leave a comment:
-
Display text based on a field value
I am setting a yes/no field to identify if the record is open or closed. A yes/no field is either 0 or -1. How do I print the words OPEN or CLOSED on a form based on the yes/no value of the current record? I simply want to place the word OPEn or CLOSED at the top of the forms so I can scroll through them quickly and see their status. I would also like to list open ones versus closed ones.
Thank you for any help!
Rob...
No activity results to display
Leave a comment: