Search results

  1. R

    sql statement doesn't return all recs

    Oh thank you MarkK. Now I feel silly. I knew that but uh... oh, I don't know - long day already, I guess. Still, pretty weird that putting in twice seemed to populate it without the .MoveLast.
  2. R

    sql statement doesn't return all recs

    Hello - forgive me if this does not constitute a new thread. It's my first post. I am calling a subroutine from another sub, and creating a recordset from a simple select sql statement. What's completely baffling is why putting in the identical where condition twice works to get all 250...
  3. R

    Lock/Unlock Table

    Hi all, I've got the same problem deleting a temporary table. Could the problem have to do with it being in an if/then block? I create it with a SQL SELECT statement, delete it with a SQL DROP statement but the error says the table is 'in use'...my code snippet: dbs.Execute "SELECT tbltable1.*...
  4. R

    Cancel Exit Event with a Form Button

    I think I found a kind of solution... I added a MouseMove event with a msgbox to run the button code: Private Sub PanComplete_MouseMove( _ Button As Integer, Shift As Integer, X As Single, Y As Single) MsgBox "Run PanComplete Code?", vbYesNo If vbYes Then DoEvents PanComplete_Click 'calls my...
  5. R

    Cancel Exit Event with a Form Button

    Hello, This is my first post - forgive me if I get the etiquette wrong. I have a form with two controls that have exit events coded. Both Exit events move the focus based on some conditions to controls on next records. I added a public sub in a module to backup the database to 2 different...
Back
Top Bottom