Search results

any examples? :confused: Tnx!

I have two tables (table1,table2) with one-to-many relathionship between them. Form1 has table1 as Record source and form2 has table2 as record source. I connect these two forms with a command button. How can i get to form2 only the records that related to form1 record? Thank you in advance:)

Tnx! That works :)

I have this code: If Me.XIII3 = True Then Me.XIII3Notes = "" End If where XIII3 is a checkbox and i want it when it is checked to get an empty string at XIII3Notes, but it doesn't work... any suggestions? (I call the code on Current event)

I have this statement that doesn't work... UPDATE table1 SET table1.val1 = [table2].[val2]+[table2].[val3]; How can i add two columns of the same table and update my query? Thank you in advance!

that exactly was the problem.... diffrent references.... thank you :)

I created an application in Access 2000 and it works fine at the development pc but when i'm trying to run the program to another machine i get this error... Run time error 3320 Function is Not available in expressions in table-level validation expression" Any suggestions? Thank you in advance!

ok that works! Thank you so much:)

do u mean something like that? SELECT table1.ID, SUM(table1.Val1) AS VAL1 FROM table1 WHERE (((table1.Val1) Is Not Null)) GROUP BY table1.ID UNION SELECT table1.ID, Sum(table1.Val2) AS VAL2 FROM table1 WHERE (((table1.Val2) Is Not Null) AND ((table1.Year)="2005")) GROUP BY table1.ID UNION...

I have a table1 with fields ID(primary key-number),Val1-number,Val2-number,Val3-number, year-number I created 3 diffrent queries: query1 returns ID and SUM(val1) if val1 not null query2 returns ID and SUM(val2) if val2 not null and year=2005 query3 returns ID and SUM(val3) if val3 not null and...

thanks a lot!:)

Is it possible to make the popup messages of a query (update and append queries) disappear? Because i have 4 diffrent queries that i call through an event of a form and i don' t want the users getting 7-8 popups in every records without knowing why! Thank you in advance :)

I want to do these through a form (the record source of the form is table1): 1. Open the table called table2 2. Find all records with table2.ID= table3.ID AND table3.ID=table1.ID 3. do the summation of table2.val for the records with table2.ID=table1.ID 4. insert this value (of summation) in...

I get error on debugger here... strSQL = "UPDATE " & _ strTable & _ "SET " & _ strField " = '" & varValue & "';" :confused:

what i want to do is to take some fields from diffrent tables, apply a mathematical formula and return a number. The returned number should be inserted in a field of a table. and i want this procedure applied to all records at once. Is it possible? :confused: I thought of an Update Query but...

How can i create a module that updates a particular field of all records in a table? Thank you in advance! :)

Thank you guyz! I finally made it work! The problem wasn't to the iff syntax but to iff logic :)

I have an update query and i want to have this: if something<>NULL F1= "T" else if something1 <> NULL F1="X" else F1="XT" end if end if At the update query i have Field:F1 and Update to:IIf(TABLE1!something Is Not Null;"T";IIf(TABLE1!something1 Is Not Null;"X";"XT")) but it never...

Modest: i know that Code Builder is for VB, but i was looking something to run a query through a module, without have to create the "UPDATE..." part in VB. I think meboz's solution will do what i want. Thank you both for answering my question and try to help me :)

How can i call a query in MS Access through a module in Code Builder? Thank you!