Search results

Hi everyone, I hope you are all keeping safe out there! For an unknown (to me) reason, the following VBA code has stopped working as it should. Private Sub txtNewQty_AfterUpdate() If Me.txtNewQty < Me.txtLocatStock Then Me.txtTransactionInfo.Value = "You are deleting " & Me.txtLocatStock -...

Hello everyone, I have the following query: SELECT tblPurchaseOrders.PartNumber, Sum(tblPurchaseOrders.OrderedQty) AS SumOfOrderedQty, tblPurchaseOrders.OrderDate FROM tblPurchaseOrders GROUP BY tblPurchaseOrders.PartNumber, tblPurchaseOrders.OrderDate HAVING...

Hello everyone! As the title says... is it possible to sort a report by its conditional formatting? I have formatted the field to be either RED, Orange or Green and I would like to be able to sort the report with Red on top, then Orange and finally green. Ability to then sort by other fields...

Just when I think im finished, something else utterly confounds me! I have 2 queries; one of which shows a list of all parts, the opening stock, how many have been issued, how many have been receipted and finally the current balance. In this query I am happy for the Current Balance to show...

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

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

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

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

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

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

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

Good afternoon all, I am working on my DB and have 2 tables that I want to work with but I just cant work out the correct syntax for an expression… Table1: TransactionLogISSUE – this contains the following fields (Amongst others that are not relevant for this question): · PartID ·...

Hi everyone, I'm gradually getting to grips with my database but now I need to display the results of the second column of a subform in a combobox on the main form. Basically, users enter a PartID in a text box on the main form. The subform then displays the corresponding PartID, WHLocatID...

Ok, so I have now got a working image database that works a charm. I have successfully added various check boxes and search (filter) criteria using what I learnt so far from help on this forum so I'm very happy! My next task is to have a button appear if a check box on a row is checked; there...

Morning all, OK, my searchable image database is coming along thanks to advice and a sample database from this forum, and I have worked out how to show an image path on my computer for each part in the table. What I want to be able to do next, in my search results form, is to be able to...

Hi all, First post but I am trying to muddle my way through Access and getting stuck on the first hurdles – so after a bit of advice. All I want to do at the moment is have a VERY simple image database, where I have a table of parts (PartID, Description, Imagepath) and a form that people...

Hi everyone, greetings from a soggy Devon! I want to use Access for a few work related projects and although I know my way around a PC and typical MS programs, the majority of my Access knowledge disappeared years ago, and what is left is so rusty that a slight breeze or even someone blinking...