Search results

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...

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.

Can you do a select command for a query?

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...

I have a hard problem with the following data model: I have a Warehouse entity and a Bin entity. They are connected by a 1 : n relationship. Warehouse has as key attribute a warehouse number and bin has 30 bin numbers, because there are 30 bins, and a warehouse number, which is the foreign key...

If I have a master table where I have "Autotypes" as primary key and I have a second table with the primary key colors "Colors". I want that an autotype never has a duplicate color, but two different autotypes can have the same color. How do I get this to work?

I want to find a record in a form. To do this, you enter a number and press a button. I have this filter code, but it does not seem to work. I already debugged it and the values are correct Private Sub Befehl18_Click() Dim number As String number = Textfield1.Value If Not IsNull(number) Then...

I have a menu with which I can navigate between forms. When I open one of the forms I would like to have it in the foreground and not in the background. How to do this?

I have a form and wanted to make it possible for the user to select the records at will and then submit them to a report. However, I do not know how to make this possible for the user. The best would be like checkboxes on each record. Does anyone have an idea? Thanks

Is there a way to create a query ,that does the following. There is a table with column name, identification number and a quantity. The query should represent the name and identifiaction number. Both should be representet quantity times.

I have these two text fields Quantity1 and Textstore. When someone clicks the button I want to feed the Storage function with the values entered in the text fields. With this function I access two tables. However, there is a problem with the Insert into statement. It does not recognize the...

Is there a function to delete all records in a query without deleting the query in VBA ?

I have this code that is used to select queries using a combo box(Timecombo), and in turn select data from the queries using another combo box(Itemcombo). This data is used to find a value of a form. Until now there is only one case statement. This all works except that the value is not found in...

How to set source for a combobox using another combobox?

If I have a query and I want to feed a combobox with these values to sort a form. How do you do this?