Recent content by sps2

Thank you CJ.

This really did work. Thank you. I know your not a teacher but can you explain why that worked. I mean I had this database set up with the employee number as a number field for many years. Switching to short text cause all that because why? Thank you for any enlightenment.

The following shows me the results from a table with checkboxes that were checked or not. The ~ separates the different items, there are actually several other checkboxes not shown here. The user prefers to see text on report rather than checkboxes, so if check box wasn't checked then nothing...

Wow. Did anyone find a solustion to this problem? Beacuse for some reason that just happened here. We have several users at the server location that are not having a problem and all of our remote users that are getting this message. Everyone accesses the database from a network drive in this...

Sometimes I just feel stupid. I have a number field, "EmployeeClock", that is indexed in the table with "Yes (No Duplicates)" turned on. So in the form what I want is when someone tries to edit the "EmployeeClock" number and that number is already being used in that table in that field they...

Thank you both for responding. I will work on these and let you know. Thanks again.

Hello all, first time on the fourm. IIf(IsNull([forms]![DateSelectionWO]![OrganizationCombo]),"",[forms]![DateSelectionWO]![OrganizationCombo]) This is checking a form to see if a selection was made in a combo box "OrganizationCombo". If so then the report show the records matching the...