Recent content by cheberdy

it is a numeric field. Is this a problem?

It was not wrong in the first place, I just mistranslated it

Here is a sample of the query

for the error.

Its in a query

i know , but that is not the reason

I did this Type of change: If(Goods movement.[Type of change]=1, "Putaway", "Pickup"). Then I get the error the expression you entered is syntactically incorrect

There is a query Goodsmovement with the column [Type of change]. For a row with 1,putaway should be used. Type of change: If(Goodsmovement.[Type of change]=1,Putaway,Pickup). I get an error that says the expression you entered contains an invalid number. How to fix this?

I have a table goods movement. This has the attributes item number, storage bin, quantity change and type of quantity change, which are 1(putaway),2(stock removal) and 3(inventory).To calculate the total quantity of an item I make a query for the table, which adds up the quantity change...

when i select in the combo box with the name process stocktransfer, i compare process.value = "3" or 3 or "stocktransfer". The error that comes is It cannot find the field 'I1' mentioned in your expression.

I have for a combobox as dataset origin this 1;putaway;2;stock removal;3;stock transfer. I would like to check the entry of the combo box then however I do not know how to read the values as variables. I have already tried 3, "3", "stock transfer". But it does not work

I have three comboxes that should be linked to each other as you can see in the picture. I have made it so that the record origin is the same for each and all have a bound column on the EAN. This also works. However in the combox Artiklename the name is not shown, although when I select a name...

I have these checkboxes on my form see picture. However, I cannot check and uncheck them they remain checked all the time. What can I do?

I have this code: Unit = DLookup("Unit", "Article", "Article number=" & Article & "OR EAN=" & Standard). I get an error syntax error(missing operator). But I do not know why. Standard and Article are strings.

Select * from query