Search results

  1. I

    Selecting last date from multiple rows

    I apologize up front for the length of this post, I need the clarity in question formulation for my own sake :) I'm having some trouble, and having searched through the listing have not found a complete answer to my problem. The environment is as such: We are responsible for testing Out Of...
  2. I

    AARRRGH! Need help w/ Yes/no control

    I'm having trouble finding the problem with the code below. It is in a subform, and I am trying to disable and lock fields based on the [Printed] check box (if yes (or checked) then lock fields). It seems that no matter what I do, the fields are either locked or unlocked, for both checked and...
  3. I

    Need help, not sure if this is correct...

    I am not sure that this is the right subforum for this topic. I am having some trouble with code. In the following, I am trying to eliminate the lengthy "if-then-else" statement (which does what I need, but needs coding everytime employees change) by comparing the logon name to the names in...
  4. I

    Filtering by logon

    I have a report that lists current contacts for a sales rep. I want it to filter this report by the logon name of the individual, so that they only see thier contacts. Any thoughts on how to perform this? Thanks, Ian
  5. I

    Form Filtering

    I have two forms. One for Customer information, including a subform for activity history. The second form is to allow AE's to filter the record set by RecordNumber, CustomerName, or AEName. Here is the code I have so far... Private Sub RtrvFormCmnd_Click() On Error GoTo...
  6. I

    Changing Field Requirement

    Is it possible, with the selection of a entry in a drop list, to change the requirement of another field. What I'm trying to do is, in a "Probability of Close" combo list, if 100% is selected from the choices, to make the "Install Date" field required. Otherwise, this field isn't even visible...
  7. I

    Problem with Subform Population

    I am creating a CRM Database, and have embedded an Activity History subform in the main customer entry form. My problem is this: when populating activity history in the first Main Customer entry form, the same information in the activity history populates through all Main Entry forms'...
Back
Top Bottom