Search results

my mistake there was no period and there were no spaces

so the solution would be article.articlenumber

why did it work before

That is all

it had no spaces, that is not the reason

Hello, so I have built a table trace log with the attributes modification date, item name and item number. I have a table article which has the attributes article name,quantity and article number. To create a new article there is a form for the article table. I now wanted to track the quantity...

And then in the transaction table I swap the storage bins. How would one do that?

I think here is a problem. The LocationID and the Location in the ItemLocationOnHandQ and LastInventoryDateQ and LastinevotryQtyQ forms are not updated.

Can you explain what you are doing?

But here is more information: I have a table article: ID / Item Name / Storage Bin / Stock --------------------------------------------------------- 1 __ red cable________2____________1 2 __ blue cable_______4____________1 I have a table storage bins Storage Bin(ID) / Warehouse...

Could you explain the VBA code( SELECT tblBin.BinID, tblBin.CreatedDate, Nz([NumberOfItems],0) AS Amount, IIf(IsNull([binID_FK]), "Free", "Occupied") AS Status FROM tblBin LEFT JOIN qryItemCount ON tblBin.BinID = qryItemCount.BinID_FK). What exactly does Nz([NumberOfItems],0). Why is...

I have a table of item. Each item has a name, a number and a bin location. I want to have a form where I enter two item names/numbers and swap the bin locations of the two. How would this be done?

Here is some more information. It is planned that a storage bin has one or more items. But one item has only one bin. Yes the item is literally a bunch of identical objects all with the same ID.

Thank you. How would you solve my second question. Would you create a table with data and just store it there?

Yes, that makes sense. But that's not really my problem. It's more about the implementation. For example, how do I use the bin ID in one table to find the bin in the other table. I'm sure there's a simple solution for that, I just don't have a clue.

How exactly do you check if something has been assigned? Sorry, I am new to Access

Hello, first question: I have the two tables Storage bin and Item. Item has the attributes bin location and Storage bin has attribute ID, date, amount and status(free or occupied). Through the attributes ID and bin both are in a relationship. I want to achieve, if someone creates an item in...