Search results

Thanks Pat, that worked great!

Yes both tables have a unique field to tie them together. I have one field that i want to update with the values from the other table. Because they have a common field that links them together there should be a way to do this.

Is it possible to use an update query to update existing blank fields with data from another table? If not how would you do this? I have a table that has 1000 records. I need to update one field in about 900 records. The value for the field is stored in another table, how can i get those values...

Update field Is it possible to use an update query to update existing blank fields with data from another table? If not how would you do this? I have a table that has 1000 records. I need to update one field in about 900 records. The value for the field is stored in another table, how can i...

Thanks Rich, Tried that, still didnot work. The subform is in a tab control, so i also tried set focus on that before the subform and still get same error. I have the code in the after update of the first field in the subform so doesn't the field already have the focus? Confused :(

Thanks John, i tried that also and got the same error message, i dont have a clue as to what is wrong. Any other suggestion? Here is the error message i get: The expression After Update you entered as the event property setting produced the following error: A problem occurred while Microsoft...

I have a main form with a subform. In the subform I want to add the number 1 to a field if the data in another field = "Primary" I wrote the following in the After Update event of the first field but it doesn't seem to work. Any help would be appreicated. Thanks Private Sub...

I did that and it gave me the table look without the subdatasheets. In the actual table the subdatasheets are viewable. I am not sure why it doesn't show up in the subform. I was able to do this before in another db i created with no problem. It was just there when i created the subform and...

I have made subforms before but i have also been able to do the form with subdatasheets in the past. I have a main form with several subforms and i thought it would look less busy if some of the subforms could come in as datasheet with the option to see the subdatasheets. I dont know what is...

I have a table that shows the subdatasheets but when i create a form based on the table the subdatasheets do not appear in the form. How can i get the subdatasheets to appear in the form same as in the table?

OK this is what worked for me. I added simple code to the button on the first form and nothing on the second form. I tried this in Access 97 and 2000 versions works fine. On the On Click event of the button DoCmd.OpenForm "SecondFormName",acNormal,"","",,acNormal DoCmd.GoToControl...

I don't think i want to assign the code to the load event because i use that form in other situations. I also am not using a combo box. What i have is a form with a subform. In the subform i want to put a button that will open a second form and go to the matching record. So i used your code...

Has anyone found an easy way to do this? Everything i have tried still gives me a filter instead of all records.

Thanks Pat for the file. Once i figured out what i was doing wrong i created two forms also. One that show contracts and list of persons associated and another one showing the People and list of contracts associated to them. I also added a button on the second form so as to jump to the first...

I played with the form and figured it out. Thanks anyway to all

Yes i need a form that will allow me to enter data about the contract and people associated with the contract. By creating the third table (Contract/People) i now have two one to many relationships which is what they say to do when confronted with a Many to Many relationship, however i can not...

Fizzio, thanks for replying and yes to all your questions. AChir, i will try the make table approach, that should work. I will let you know how things work out.

I have a db that is tracking contracts. Each contract has a primary person (or entity) and could also have several secondary persons attached to the contract. What makes it a many to many relationship is that for every person in the database they could be tied to more than one contract and for...

How do i get a Word Mail Merge document to recognize a field in a Access form as the criteria for the form letter. Example, i have a form with several records i want to print a contract for just the current record. I base my Word mail merge on a query so that it will look at the contract id on...

Is there a limit to the number of records/rows in a table in access?