Search results

omigod! thankyou - so now I realize I'm blind and dumb -- thank you getting glasses tomorrow :banghead:

Thank you so much. I could not get the DAO to work so I used ADODB and of course couldnt get it to work either. Thank you so much - Your code is concise, robust, simple and works perfectly. Thank you

Thank u so much and it worked beautifully Second question if at all possible - How would I update another table, lets say Employees with the new namephone variable. Namephone is the primary key in the employees table. This doesnt seem to be working . Thank you again for your help Private Sub...

I am opening a form to allow the user to change names contained in a child table (multiple records) and having the user enter the old name and the new name Code below fails. NamePhone in the table projects - says its not defined in context - and yet that is the name of the field in the table...

Slow load - I open a main form with a table and, with 1000 records, it loads in a few seconds over the network. Then I open a linked form selecting only some of the records in the child table (relational database) - and it runs a query on the child table with 17000 records but this takes a...