Search results

  1. D

    Error running code

    Hi, I get this error when trying to rung a piece of code: The expression On Load you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives. I have the EXACT same code working on other forms using...
  2. D

    Find Record

    I have navigation between forms and when a user navigations from the main form(candidate) to another form(1) and then back there is only 1 record displayed on the candidate form as it is only bringing back the record tied in by the application number. So if you then want to search for another...
  3. D

    Received Dates Query

    Hi, I want to run a query that returns only records where we haven't received 2 items for them from a possible 4. I can't seem to get my head around it! At the moment I have:- Recd Date 1 Recd Date 2 Recd Date 3 Recd Date 4 Is Null Is Null Is Null Is...
  4. D

    Invalid Use of Null

    Hi, I have some code that runs on Form_Load() It basically uses a case statement to say if a value in a combo box equals one set of values then make somethings visible and invisible, and for all other values make some other things visible and invisible. The problem I have is that I have defined...
  5. D

    Timestamping changed records

    Hi, I'm trying to populate a read-only field on a form with the time and date the record was last changed. This is to acheive seeing a list of records that have been updated this week for example. I have this at the moment:- Private Sub Form_AfterUpdate() Last_Updated.Value = Now() End Sub...
Back
Top Bottom