Recent content by jasmin_m

I have a query, it return one value and I need to save that value in variable. How to do it ?

yea, can someone write this example with findfirst I am searching for a while.... and I also have problem with this also rs.Index = "ID" rs.Seek "=", 4 If rs.NoMatch Then MsgBox "No matches found.", vbInformation, "No records." Else ' error need EDIT how rs!Naziv = "asass"...

Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("table") ' if you need to add new record rs.Edit rs!Value= "new" rs.Update rs.Close ....... situation; I have a tabe called "tabel" and two fields in it: "ID" and "Value" And I want with above code to update field "value" for ID...

Is there a function to write to practicular field in table. For example wit DLookup function we read particular field from table, is there similar function for writing to field in table.

Is it posible to use DLookup with two table(domain) example; a = DLookup("[field]", "table1 & table2", "[field2] = " & x & " And [field3] = " & y)

Thanks guys :)

Dim x As Integer Dim y As Integer x = 1 y = 2 a = DLookup("[field]", "table", _ "[field2] = " & x And "[field3] = " & y) In above example criteia is incorect, how can I write it correct.

How to display memo fields on forms. How can we display memo filed, with his all huge content in textbox and in list box.