Recent content by oaishm

  1. O

    filtering forms for more than 1 item

    Yes, that's exactly the solution. In the filter field, access uses commas, but in vba you have to use "and". Classic. Thanks for your help, I can't imagine how you trial and errored your way through this.
  2. 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?
  3. O

    Sub form requery, cache flush, etc etc.

    Oh yes, so to be clear, DBEngine.Idle dbRefreshCache DoEvents DoEvents Me.[CustomerItem subform].Form.Requery Me.Requery DoCmd.RunCommand acCmdRefresh qty = 1 plu = "" plu.SetFocus didn't work and I wonder if setting the record source won't work either. alas. It doesn't
  4. O

    Sub form requery, cache flush, etc etc.

    You know. When I first looked at that underscore, I thought the same thing you did. Then I saw this And I just figured that Microsoft is different than every other language I've come across in that they purposely change spaces to underscore. So I did the same thing. This is a weird...
  5. O

    Sub form requery, cache flush, etc etc.

    http://www.scrapbookingsuppliesrus.com/images/product1/scrappink.zip My database is too big for upload, so I added it as a link. I originally didn't want to change the record source (which by the way worked) I just wanted to requery. I changed the record source to force it to refresh. Two...
  6. O

    Sub form requery, cache flush, etc etc.

    You know, I thought it should be a dot, not a bang, but as you can see on the web, people shorten Form!Parentname. to Me!. Anyway, it's easy to see both. Here's my properties screen capture: Maybe its because Microsoft defaults both the source and control name to the same exact name and I...
  7. O

    Sub form requery, cache flush, etc etc.

    Here's something else that doesn't work, resetting the record source and requerying: Me.CustomerItem_subform.Form.RecordSource = "Select * from CustomerItem where Customer ='" & [cardnum] & "'" Me.CustomerItem_subform.Form.Requery
  8. O

    Sub form requery, cache flush, etc etc.

    Alas that's another variation that didn't work: Me.CustomerItem_subform.Form.Requery Me!CustomerItem_subform.Form.Requery Me!CustomerItem_subform.Requery No clue why soem people us a ! and some a dot. Doesnt' matter, neither of them work. Also tried this...
  9. 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...
  10. 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...
See more
Top Bottom