Recent content by xyba

  1. X

    Update Table from IIf Calculated Form Field

    OK, thanks guys.
  2. X

    Update Table from IIf Calculated Form Field

    I have a form (fmERA) which is bound to tblData. In the form I have textbox (txtCentreCalc) which contains an IIf statement. What I am trying to do is update the calculated value of txtCentreCalc into a field (Centre) of tblData but I'm unsure how to do this. Any help appreciated.
  3. X

    Combo Box - Wrong Column in Table

    Thanks, I tried that but it didn't work for some reason. Anyway, I've sort of solved it by deleting the ID field as it wasn't required anyway.
  4. X

    Combo Box - Wrong Column in Table

    Hi I have a form with a combo box relating to a table of two columns (autonumberID, Name). The combo box properties are set to col count 2, bound column 2 and column width 0;2. However, column 1 (autonumberID) is written to my main data table instead of column 2 (Name). Can anyone please...
  5. X

    Search and open form

    Yes, I have another subform. I'll give this a go, thank you but, does that code go in the OnClick event? I have subform Search and subform Result so how would that affect the code?
  6. X

    Search and open form

    Ah, okay, thanks Colin.
  7. X

    Search and open form

    Maybe I've not explained very well what I'm looking to achieve. As an example, a navform has 2 subforms named Search and Result. In subform Search I want to enter the search value in a text box and, if the record exists, when the button is clicked the user is taken to subform Result, showing...
  8. X

    Search and open form

    Thanks for the reply. The first link shows how to open the result in another form. I want to open another subform within the navigation form not outside of it. If I used the code mentioned in that thread wouldn't it open a separate form outside the navigation form? The second link gives a...
  9. X

    Search and open form

    Hi In a nav form's default subform I want to add a search facility (text box and button). In the button OnClick event I want another subform to open with the searched record. I have the below code for my search button but I don't know what to add to get it to open the result in another...
  10. X

    Compile Error Help

    Thanks both. I did have Microsoft ActiveX Data Objects 6.1 Library checked but it had mysteriously been unchecked. It must have been the latest Microsoft Windows update that caused it as I've had lots of issues (non-Access related too) today, after updating last night. Thanks again.
  11. X

    DLookup Alternative

    Thanks all. I took the choice of adding an extra field to my table and that works much better. Thanks again for the help.
  12. X

    Compile Error Help

    Not my day today! I'm getting a "Compile Error: User Defined Type Not Defined" error in a module when debug/compiling and the debugger is highlighting the line in red. It worked fine until today so I'm wondering what could cause it. The code is: Sub AuditChanges(IDField As String, UserAction...
  13. X

    DLookup Alternative

    Hi With some help from this forum earlier today, I have managed to get the below DLookup expression working to in the Control Source of a textbox. =IIf([Text63]="Live","Row " & DLookUp("[Row]","[qryLocate]","[Box] = " & [txtBox]),"") However, it is extremely slow, sometimes up to 15 seconds...
  14. X

    Graph Data Label Format

    Either method, I don't mind.
  15. X

    DLookup Help

    Yes, in a form. Thanks for your help.
Top Bottom