Search results

You bet I will, and thanks again!

Don't kid yourself Rural, there is a simple way and you showed me. Private Sub Form_AfterUpdate() from.SetFocus Me!from.DefaultValue = from.Text Text2.SetFocus End Sub All I had to do was set focus to the control and then put it where I wanted it. I think I tried every possible combination of...

Gosh, it's close but.... Microsoft is statically assigning a value and hiding the text box, and using a module to do it. That is more work than setting the default value in properties. In VB it would be easy, why is VBA difficult? Isn't there a simple * on new record, text1.text = text1.text...

Wiz, I tried your code and it worked but there are two things a little off that will keep me from using it. 1. I don't want to change ALL the records at one time. 2. I don't want to be warned about changing records ( because I don't want to change them in bulk.) What I want to do is set it...

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...

You are correct, I was going crazy with code when I should of just used the bound controls and used the wizards Add Record button. Like my title says......... Thanks

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...

Wayne, thanks so much, that did the trick! take care ds

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...

Hey Pat, with that many post it's no suprise you came up with that. I tried the Union query but I did not have the right options included. Thanks a million, it works! ds

Hey Smart, that sure does help and Ill give it a shot. Thanks for your help and if it worked out Ill edit my post with a (RESOLVED) take care ds

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...