Search results

  1. O

    filtering forms for more than 1 item

    I tried to do it with: Me![R heavy].Form.Filter = "[r] = " & Combo0 & ", [p] = " & Combo2 & ", flex=1" but the error said there were commas where there shouldn't be. does anyone know the right syntax?
  2. O

    Sub form requery, cache flush, etc etc.

    I have a main form that inserts data into a table. There's then a subform that should be re-populated based on the new info just inserted into the table from the main form. To avoid a "XXXX has put the database into a locked state so you can't modify the records" error, I 've split my database...
  3. O

    front end back end help

    I'm new at this, so appologies. This all started when I tried to avoid the: The database has been put in a state by .. that prevents it from being opened or locked. Private Sub plu_AfterUpdate() Dim cn As New ADODB.Connection Dim cmd As New ADODB.Command Dim rs As ADODB.Recordset Dim strSQL...
Back
Top Bottom