Recent content by mleinss

I redid the record set based on the query behind the form, but got the same error. I found out that the query is linked to another table and that was not allowed. I then created a new query without the table link. now my problem is the syntax to use a field in the form to filter the query. I...

so all I have to do is change the code from recordsetclone to recordset? or do I actually have to go back to the query behind the form.. I have not used recordsets before

I am working on a database for order quoting. There are times I need to insert a new line between two other lines. The line numbers need to be resequences when I do as in the original quote has line 1,2,3 I need to add a line between lines 2 and 3 making the new line 2 and the old line 2...

That was it, the old version did not need a requery statement after the execute statement thanks

Hi I am working on converting a Access 2000 database to Access 2007..I was able to solve most of the problems, I have one left I have a form (QuoteDetFrm03) with a tab control (tabCtl259) with 7 tabs One of the tabs( Tab Page 261)has a subform (QuoteDetBankFrm01) where the user has the option of...