Search results

Done it! :) Thanks.

The blanks are from testing. I've got a query to show all the ProdID in relation to the GoodsOutID, which is good, all I need to do now is sort it to a specific JobID only, do I do this with 'filter' or 'sort'? Where should I be looking? Thanks, Nick.

Anybody? :(

Cheers, I should of asked a while back, would of saved me a lot of time recreating them. :)

Is it possible to change the width of columns in a combobox after it has been created? If so, how? Thanks, Nick.

I have 2 tables that are related to each other. When a user logs out products that go to a customer, the form stores the Date it goes out on, and the customer ID (shown as 'JobID' below), then another table, logs which products went and what quantity. The tables are below: The 'ID' field...

It's from 'Commander Keen': :)

Thanks a lot Bob, that's a very helpful sample, I've got it going now. :)

I can't figure this out. I have a field that grabs my price from the products: =DLookUp('[Price]','Products','[Products]![ID]=[ProdID]') Then a 'price' field in my GoodsOut table, how do I transfer the price to this in a form? If in my 'price' field on the form I do...

I've this setup now but have run into a problem, How do I take the 'price' from the 'products' field and insert it into the 'price' in the new Goodsout table when I add the new products?

Ahhhh I understand, sorry. So the products table still stores the price but it duplicates the data into a customers transaction table, so if the products price does change, the customers transaction stays intact. :) Thanks a lot guys, very fast response!

Sounds like a good idea however would that mean me entering the data in each time?

I have a simple Goods in Goods out Database, it has a list of products, and then you can set which goods have come in, and which goods have gone out to a customer. I want to keep the data for the customers, so I can look at a certain customer and see what goods they have had in the past and the...

Is it possible to use Conditional formatting to compare 2 fields? If FieldA < FieldB? This way each row is unique, and not all fixed at the same value (which in my scenario wouldn't be suitable). I don't see this option though under Conditional Formatting. :( EDIT: Sorry, just seen I can add...

Is it possible to format the font colour depending on the field value? For example if FieldA < '10' it appears red, if it's greater it appears green? I'm guessing this requires VBA. Thanks in advance.

Thanks a lot Bob much appreciated, I've used that but altered it a little to this (so if one field is blank it doesn't revert it all to 0): =Nz(DSum('[Qty]','GoodsIn','[ProdID]=[IDa]'),0)-Nz(DSum('[Qty]','GoodsOut','[ProdID]=[IDa]'),0) Works a treat now. :)

Ah thanks for the tip, although it still doesn't work. It's fine if a number is there but if I leave it blank the formula just doesn't show anything. Thanks Bob, Nick.

Thanks guys, I don't think that worked though, fields are still appearing blank where a figure should be, here's my Dsum: =DSum(Nz('[Qty]',0),'GoodsIn','[GoodsIn]![ProdID]=[IDa]')-DSum(Nz('[Qty]',0),'GoodsOut','[GoodsOut]![ProdID]=[IDa]')

I have a DSum that does a simple subtraction. As an example: ('FieldA' - 'FieldB') where FieldC = '123' If FieldB is blank, no data there, but there is for FieldA, it doesn't show any result, it is blank. Surely if FieldA = 300, then FieldB is blank, the result should be 300? As It's...

When I do no values appear in the Combobox, it just shows as blank.