Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. patljones

    Too few parameters - ADODB in VB6

    Thanks Mark and Zemp, ditched the parameters idea and reform the query every time I change the "parameters" - not very elegant but it works.
  2. patljones

    Too few parameters - ADODB in VB6

    Running the code below comes up with "Run-time error '-2147217904 (80040e10)': [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1." on the cmd.execute line. Private Sub Command1_Click() Const ConnectString = "DRIVER={Microsoft Access Driver (*.mdb)}...
  3. patljones

    Freeing up a linked list

    Cheers Chip - works fine now.
  4. patljones

    Freeing up a linked list

    I've set up a linked list of Class Modules and I'm trying to free them up but it doesn't seem to be working. The watch shows that currfield is pointing to the right thing but its still in the chain after I set currfield to Nothing. Do While Not currfield Is Nothing Set nextfield =...
  5. patljones

    Memory & Handle leak setting button.enabled property

    Oops, its NTs (or Excel's) memory management leading me down the wrong path. If you click enough times or leave it long enough then the memory and the handles get freed up again.
  6. patljones

    Memory & Handle leak setting button.enabled property

    Is it just me? In NT I add two buttons to an Excel 2000 spreadsheet and the VB Code below. Open up task manager and alternately click on the buttons and the memory usage increments by 8K when you click and another 4K when you move the pointer off the button. It also uses up 4 handles every...

Part and Inventory Search

Back
Top