Search results

OK, I've scoured the forums and read all the help in access I can read but I can't quiet come up with my solution. I simply want to statically assign a field in my table from a text box after I go to a new record. In other words, my form opens... I type text in a box that is bound to a field...

OK, I have a table Im moving data from into another table via SQL INSERT INTO ...... FROM ..... VALUES on a mouse click. I want to "tag" that record so as not to use it again in a different table. I do not want to delete it. I added another field called select and made it a yes/no. How can...

This is probably an age old question but after a search I could not find the answer. I have a table with 3 fields..... last, first, ssn I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the...

I have this code that works fine exept for one thing. If I have two names that are the same it deletes them both. currentdb.execute "insert into charmer91 (last,first) values ('"me.list0 & "','" & me.list0.column(1) & "')" currentdb.execute "delete table1 (last, first) from table1 where last...

First post guys, hope you can help me out. OK, I have 10 tables in a database, all 10 have the same fields, 'last' and 'first' each table has a different amount of records "names" in those fields I want to print a report that has all 10 tables worth of names grouped by table. Thats where it...