Search results

hi, i found the solution using UPDATE in the query. tks for ur interest

thank you so much!!!!

Hi! I posted a thread titled "beginner in vba - select query" some days ago. I tried another way but there is another problem. This is my problem. I would like to show 'field1' and 'field2' on form2, but 'field1' and 'field2' are saved in table1. moreover, I would like to save 'field1' and...

don't forget me, please!

thank you so much!!!! I attach you some file, so the post is as short as required.

thank you so much but it doesn't work. I used the Example#2, as you advised but there is a problem. the values are saved in the next record, and not in the record where I'm introducing the other values which are showed in mask 2. I don't know if it sufficently clear, but please, help me again.

But I don't want to do a subform. i dont' like it in access because it is very awkward when i've to insert some data each month. could you correct my code, or indicate me a useful guide for learning to write vba select code? thank you so much.

i post the structure, as requested.

I want to copy the values from a table to a mask such as a sort of check. the second table is connected to the first table. I try to explain it using an example. in table 1, I insert name and surname of a student. in table 2, I insert the student's laboratory test values. the test are effectued...

thank you so much for your replay. but I can't understand what to do. maybe, it is better to describe you my problem. I've mask2 where I want to show field1 and field2 I've inserted using mask1. I want to show them when i click a buttom. so, I thought to write a vba code and to run it after...

Hi, may anyone help me? there is two masks and two tables. I want to click on a buttom in mask2 and run the following code: Dim query1 As String Dim query2 As String Dim objDB As Database Set objDB = CurrentDb query1 = "SELECT mask1.field1, mask1.field2 FROM mask1" _ & "WHERE...