Recent content by dragonsbb16

data sorry forgot to mention that......the recordset is filled from another Access Table. Also, both Table structures are the same.

I have a question.....i am uing Access as the back-end database of a VB6 Front end app. Basically i have a recordset with about 300K records....i currently Insert 1 row at a time....which takes ALOT of time.....is there a faster way to do the insert? i saw some things on the internet about a...

i have a access application that does a simple filter here is my code.. dim filter as a sting filter = "CenterName = '" & NameSel.Value & "'" DoCmd.OpenForm FormName DoCmd.ApplyFilter , filter DoCmd.close acForm, FormName2 This function works fine UNTIL NameSel.Value = "Adult's" And the...