Search results

  1. pbaldy

    type error when trying to update a table field name query

    Happy to help!
  2. pbaldy

    type error when trying to update a table field name query

    Your arguments are out of order. Try UPDATE [IMPORT - EFF ORDERS] SET [IMPORT - EFF ORDERS].SKU = Left$([IMPORT - EFF ORDERS]![SKU],InStr(1, [IMPORT - EFF ORDERS]![SKU]," ")) WHERE ((([IMPORT - EFF ORDERS].SKU) Is Not Null));
  3. pbaldy

    The future of Access

    I haven't noticed this being posted: https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access
  4. pbaldy

    Find Record for Subform

    Is this what you're after? Dim lngPK As String 'change data type if yours is different 'set variable to current record ID lngPK = Me.RoomArea 'return form to original record With Forms!Maintenance.MaintenanceAddRecord.Form.RecordsetClone .FindFirst "ID = " & lngPK 'if your...
  5. pbaldy

    Find Record for Subform

    You don't need the requery for this, that's what the link was doing. All uses of Me need to be changed to the subform reference except the one setting the variable. The variable should be declared as String if the field is text.
  6. pbaldy

    Find Record for Subform

    I would use a bookmark. You can adapt this to use the subform reference instead of Me. http://www.baldyweb.com/Requery.htm
  7. pbaldy

    Dynamic Filter on Unbound Forms

    Happy to help!
  8. pbaldy

    Dynamic Filter on Unbound Forms

    No problem.
  9. pbaldy

    Dynamic Filter on Unbound Forms

    I believe it would be FilterOn rather than Filter.
  10. pbaldy

    Dynamic Filter on Unbound Forms

    Also, the filter should just include the field name: "StockItem LIKE '*" & filterText & "*'"
  11. pbaldy

    Form not reflecting (nor recognising) all the records in the table

    Happy to help!
  12. pbaldy

    Form not reflecting (nor recognising) all the records in the table

    Actually, I was just telling Peter where he would find the properties.
  13. pbaldy

    Form not reflecting (nor recognising) all the records in the table

    Yes, and the subform control on the main form is where you should find the master/child links.
  14. pbaldy

    From Excel to Access

    I'm not clear on what you're counting, but take a look at the DCount() function.
  15. pbaldy

    Form not reflecting (nor recognising) all the records in the table

    What I'm after to start is the record source property of the Clients form. It should just be the clients table, not a query that pulls in the meetings table.
  16. pbaldy

    Hello

    Welcome aboard!
  17. pbaldy

    From Excel to Access

    The Access equivalent of the IF() function is IIf(). I haven't used COUNTIFS so maybe if you describe the result you want to get we can come up with something. Generally you wouldn't save calculated data, but there is a calculated data type if your situation merits it...
  18. pbaldy

    Form not reflecting (nor recognising) all the records in the table

    Can you confirm the record source(s)? I would expect the main form to be bound only to the clients table, and a subform for meetings bound to the meetings table. Master/child links would keep them in sync with each other.
  19. pbaldy

    Label visible if one or more check boxes are checked

    Glad you got it sorted out!
  20. pbaldy

    Label visible if one or more check boxes are checked

    By the way, you might try the code in the section containing the data. The page header might be looking at a different record than you expect. I'm not sure offhand which it uses. You could use Debug.Print to test it.
Top Bottom