Search results

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

maybe in a Query?

Sorry I forgot, it should then produce all possible records

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?

Its always one user

how to check if the box has been ticked?

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

Maybe something like Declare i as Integer Select mytable.Quantity from mytable while mytable.Quantity < i Begin Select mytable.Id, mytable.name from mytable Set i = i+1 End

Is it possible to do the same with a loop

How do I create a tally table in access

It is for creating labels

How do I create this tally tabel

quantity is a number and it gives the number of records

This is my table name ________id_________quantity car____________1__________5 The query should do this name ________id car____________1 car____________1 car____________1 car____________1 car____________1

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.

oh, yes of course

It seems to be an integer

When I go over it gives like itemnumber= 1