Search results

Hi all and ty for your precious support. I have an issue: I have a data entry form where i put all things about a client purchase (like Name, Cost, and so on...). There is a COMBOBOX used to find the client name. The combobox use a query (based on Client table) that merge NAME and SURNAME. If...

select estimate.id, estimate.client_name, estimate.result, results.id, results.result from results inner join estimate on results.id = estimate.result;

ok, but the search made a strange behavior... If i try to perform a search with the "001 select": it shows me the record with the corrected field selected, but with another field with: "#Name?" Next trying to perform the serch with "001 select": not showing the results asking me [Field] value...

The problem is: From 3 combobox criteria, query two connected tables and show the results in a subform. The combobox are: 1- CLIENT_NAME (char) (default value: Null) 2- TYPE (char) () (default value: "EMPTY") 3- RESULT (char) (default value: "EMPTY") Tables are: name: ESTIMATE fields: ID...

I am testing that code: i found DOUBLE IF in each "select generator" and the END IF missed. But many things not working.... I think i need to rethink about it.

Understood. TY

...sorry but i can't understand what are you talking about.... Anyway.... A suggestion?

Problem creating the query string select: typeSearch = "select * from mainTable where ([Status] = '" & Me.NewComboBox & "')" Me!Submask_mainTable.Form.RecordSource = typeSearch Me!Sottomaschera_mainTable.Form.Requery The newcombobox, contain a text. When i execute the select, it ask me...

I got on the line: typeSearch = "select * from Documents where [code] = " & Chr(34) & Me.cliCode & Chr(34) & _ " And [typedoc] = " & Chr(34) & Me.docType & Chr(34) & _ " And [ID] = Me.newCombo & ";" ERROR: End instruction required ";" But i still can't understand the code..... why use...

TY but 2 things: 1) why the SELECT are always on DOCUMENTS TABLE and never on RESULT TABLE? 2) I have a "compilation error" at the end, before Me!....

Hi all, and ty for your suggestions that's my issue: I have a form used to show in a subform the results from the selection of two comboboxes. These are the combobox name and the relative query on the main table "Documents": Dim typeSearch As String If Me.docType.Value = "EMPTY" Then...

Now calculations are in VBA, inside the form. That's why i wnat to know what "event" can fire the code. ...i could think about move from vba to calculated filed table... Other suggestions?

This is the example: in a data entry form, i have 2 numbers fields (A and B) and a calculated field C (A+B). I need to store all the values in a table. I need to show the result only if A and B are not missing. Which "event" can i connect to the "calculus"? TY

Thanks for the great support, i solved with IIf([CanCost]=True,Fix(1),[AntRealCalc]) But don't know really why..... Seems the problem was "1" and not [AntRealCalc] I think putting "1", the 1 is a TEXT (but the field is a double int) and gave me error. Putting fix(1), the 1 is a number. Is it...

That's correct. But now i can't do the rest With: IIf([CanCost]=True,1,[AntRealCalc]) i got this error: Syntax error, operand without an operator. With: IIf([CanCost]=True,"1",[AntRealCalc]) I got this error: "THE EXPRESSION COULD NOT BE SAVED BECAUSE ITS RESULT TYPE, SUCH AS BINARY OR NULL...

I need this: IIf([CanCost]="True",1,[AntRealCalc]) if [CanCost] is ticcked, the value must be 1. if not ticched the value must be equal to [AntRealCalc] [CanCost] is a type "true/false" [AntRealCalc] is a "Double" The type of this "formula-field" is "Double". I think there is a syntax error...

Wow, ty for all your suggestion. I'll study mine case and your answers, so I can explain better what i need.

Ty but still the error IIf([CanCost],1,iif([AntPerc]=0,(([AntVal]/[Prezzo imponibile])*100),[AntPerc])) The error says: "you may have entered an operand without an operator"

Hi all and always ty to your important help! I have an issue with a calculated table field: (i know about use or use not calculated fields, but i need it) If radiobutton is true: the field value is 1. Else if: another value is 0, made a calculus else put a value field. The calculus is...

Hi all, ty for all the help! My question is simple: is it possible run subroutines or functions, without a specified event? Or i need to recognize the MOMENT IN WHICH the code is executed? Francesco