Recent content by pbaldy

  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.
Top Bottom