Search results

Hi all, Im going crazy! I have a sub form showing query results on my main form where the user can directly select a field which is then displayed in a text box back on the main form. I also have a combo box, which is completely unrelated to either the text box OR the combo box. this is...

ah yes - I see that now, thank you :) :)

Arnel - Where does the Excel spread sheet get saved? Or is it all essentially created "virtually" only whilst the DB is open? Many thanks Chris

Hi Arnel, Thanks very much! that works great. Thanks also Mike, but sadly as I have 2007 your version didn't work for me. thank you for your help though!

Hi Mike, Great stuff - Thank you very much - I will have a look :) Chris

Please find attached the DB. IT is FAR from finished and lots of functionality to perfect however, I have created qryStockITemCountforGraph which draws info from 3 other queries. There are 3 fields in the query, each with their own numeric value. These represent the number of items (parts) at...

Hi Mike, I will try - bear with me though, there are some company bits of info in there that I need to clear out first :)

Hi guys, Just a quick question for you today... can a pie chart be made from a query in Access 2007? The query has 3 fields in it but no matter what I do I just cant get the damn thing to show all of them on the chart - its only one or the other and its beginning to give me a complex! thank...

Sorted! :) thanks very much; I made the query and it works perfectly now. thank you! Out of interest - why would the calculated field I originally used work on SOME lines, but not the others?

Hi ArnelGP, Stock Difference is a calculated field on the report itself I will look at creating a new query to make this work :)

Re ran the report and its all good now - I took the screen shot from the wrong report (previous was a scrap report that I was using to practise on!) Thanks for the spot though :)

HA! VERY good spot... I shall see what has gone wrong!

Hi guys, Part of another DB I am making gives the user a report. Although they can obviously export this to Excel using the functions in the External Data tab, I want to make it as easy as a one click operation (less chance of confusion then!). I have added a button to the report but when it...

Thanks DBGuy :)

ah yes!! of course :) thank you as ever - for some reason it was showing 2 columns, not 3. Brilliant help as always! thanks again Chris

Hi DBGuy, many thanks for that! The combobox is generated from a select query and as you can see in the image, I do happen to have 3 columns. For some reason though I simply cant get that 3rd column to display. if I change the column number to 0 or 1, then the WHLocatID and PartID (as per the...

Hi everyone, Im 99% sure that I do NOT need DLookup up here, however... I have a subform that shows results of a query on my form. This query has two fields: WHLocatID and CurrentBalance. Subform is called "InventoryQuerysubformRECEIPT". I select one of the "WHLocatID" results from a combobox...

Thank you guys :) Definitely will not be calling him "Corona"!! :) Its an odd feeling not being able to show him properly to his grandparents etc. but we will all come through this in the end and beat the virus! Thank you for that CheekyBuddha, I think that has done the trick perfectly!! Chris

Hi all, my apologies for only just replying - happy to say that my Wife has just had our first baby, so have had other things on my mind lately :) However; here is the SQL.. qryCurrentStockLeveL: SELECT Inventory.WHLocatID, Inventory.PartID, Inventory.OpeningQty...

Really sorry to be a pest guys, is anyone able to give me further guidance on this one please? many thanks Chris