Search results

Thank you Ranman, I'm clearly missing something. I have done this (thank you for the query information); but the list that appears in my combobox is either the full list of ALL warehouse locations or only those locations that have stock. I need the combobox to show locations that do not have...

Hi, the list of stock items IN the warehouse is qryCurrentStockLevel. Forgive my ignorance, where would I put your code for the outer join? many thanks chris

Hi Ranman, thanks for getting back so quickly! My warehouse locations table/query (your warehouse items) has only got one field - WHLocatID (it is literally just a list of storage locations) so I cant bring down the Stock Itm (my PartID) from them both... sorry to be a pain!

Hi Guys, After ArnelGP's helpful example last week I can now move forward with my project. This time... I have a subform that shows warehouse locations (WHLocat) and the current amount of stock that is in that area (CurrentBalance), based on the part number (PartID) that has been entered on the...

That is perfect, thank you. I will now go through it line by line to see why I couldn't get it to work :) Thank you as always! Chris

Hi both, thanks for your replies :) ArnelGP - I have tried your codes (thank you) however unfortunately I'm not getting any results appearing on the screen. When I try to run either of the queries, I get another error - "Circular Reference caused by 'qryTransLogTotal'. Is the idea that when the...

Hi everyone, I am playing around with my DB again and now have 2 tables: "Inventory" which has the following fields: PartID, WHLocatID and OpeningQty. PartID is unique, WHLocatID is the location of the item in our warehouse (not unique) and OpeningQty is simply the quantity we started with...

right - I have successfully joined two queries (thanks to all for the advice :)) CJ - thanks again; I will sit down and properly have a look at SQL soon. hopefully with understanding that, everything will become clear :) I will keep exploring and trialling and will give an update soon...

Hi ArnelGP Thanks I will look into that as well as the join. In laymans terms do you mean to basically make a query that joins my other two queries together; THEN do an unmatched query that compares this new query to the tblWarehouseLocations? Chris

Hi CJ, thanks for getting back to me. Forgive my continued ignorance - but im not sure what "Left Join" means. Also, when you say "the other two tables", I only have one other in this case... do I use the two queries instead? Thank you Chris

Hi everyone, Still making inroads on my DB and have now come against my next problem. I have 2 tables and 2 queries in this quesiton: tblWarehouseLocations - this is the master list of all storage locations in the warehouse tblInventory - this is a list of all items that have been put...

Hi everyone, Just to say firstly Sorry for taking so long to reply - time to work on my DB is "infrequent" to say the least! However, after a bit of playing around with it last night, I have come up with a solution based on Mikes example. So a huge thank you to all for your help (as...

as a quick update Mike, your system works IF the user first selects the part number on the sub form. For example they would need to select the part number from the initial combo box, then select it from the sub form, then select it from cboWarehouseLocat; this will then show the correct...

Hi Mike, Thanks very much for that. It helps... ish :D The txtQty box that you have added seems to only show the quantity from the first entry in the displayed subform. For example, if I select part number "S14170" I get a list 6 different locations, each with a different quantity "in...

Thanks Doc. You're of course correct - every day we learn something new. Whether that is how to make a DB work, or something as simple as learning to leave home 1 minute earlier in the mornings to avoid "that" person who always seems to hold you up in the morning ha ha.

Hi all, Firstly really sorry for not being able to get back to you Arnelgp, I have been away and without computer access for a couple of weeks. Thank you for your latest example however. Now I am trying to pick up where I left off and I must admit I am having trouble working out how I can...

Thanks DB Guy!

Hi ArnelGP, thanks for that example, that's just what I was looking for. I will be able to use that... i'll let you know how I get on. many thanks Chris

Oh right, ok - well I'm open and happy to any suggestions so any more info gratefully appreciated. You will have to excuse my ignorance on some parts as I am still very much learning Access. Thanks.

Oh I see, that makes sense. In my case then, I would imagine it would be "OK"? The opening stock will never change and the field value that I want calculated needs to be dynamic and ever changing. The information I need storing is stored in the transaction Log and will never be altered; only...