Search results

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

Can you do a select command for a query?

It is unfortunately in German, but Artikelnummer is the primary key and has the autovalue data type. It is the only bound value, but it does not show a number. How to change this?

I meant Insert Statement

I have a form where I can create a new record in a table. I do this with a simple select. However, there is a problem. The primary key of the table is an auto value. How can I display the next higher primary key in the textbox for the primary key in the form. Otherwise there is always the error...

I have a textbox Datum in the form Bestandsübersicht where I enter a date. Then I have a query Artikelmenge that takes that date and compares it only to records from the table Warenbewegung. The query sums up the sets of records whose date <= than the textboxDate. However, the query does not...