Search results

  1. M

    Correct way to express filter in VBA

    Hi all. I struggle with this every time I try to do it and it seems that I can never find the solution online. I have an unbound combo in the header of a continuous form with a list of districts (text). I want to filter the form based on the text field [DistrictName]. I have the following...
  2. M

    Run-Time Error 91 trying to create recordset in VBA

    Hi all. Searched everywhere, but I don't seem to understand the meaning of this error. I'm trying to create a warning message box if the user tries to enter a duplicate record (but still allow it). My code is below. The error occurs when I try to set rcst equal to the recordset of rslt...
  3. M

    Runtime Error 2501 on acCmdImportAttachExcel

    Greetings, all. I personally am running 2007, but a customer of mine is using 2003 (trying to get exact version). I have a label on a simple form that opens an import from Excel window (ImportAttachExcel). On my 2007 Access and nearly all others it works fine. However, one customer of...
  4. M

    Unbound combobox in header not obeying 3058 error handling

    Hi all. I haven't posted here for a while, but visit regularly. I'm hoping you might have some ideas about an issue I'm having with a subform. I have a mainform and a continuous subform. The continuous subform has a header with two unbound comboboxes that are used to filter the results in...
  5. M

    Problems with filter in subforms

    Hi all. I've been struggling with this the last several days and just can't seem to get it straightened out. It's a DB for tracking HIV/AIDS health data at an NGO in Vietnam. I have a main form with four subforms all tied together with mother/child link field. All subforms are invisible...
Back
Top Bottom