Search results

Hi all, I am battling to get this right, if someone could help me, I'd hugely appreciate it. Basically, I have 3 queries running from seperate tables. The first query gives me order value per month; the second query gives me amount paid per month and the 3rd query shows me budget per month (as...

Hi all! I have a database with a table record inventory movements. The columns are as follows: ID Date Entered By Item ID Transaction Detail Order Number CR Number Warehouse Location UnitsOpening UnitsReceived Units Dispatched UnitsDisposedOf Remarks I have everything running perfectly except...

Afternoon all, I've been battling with this, and can't seem to find a solution on the net. I have a form called "WHDispatch", on this form I have a list box ("NewOrders") based on a query listing outstanding orders, with the following fields: "Order Number", "Item ID", "Quantity", "Order Date"...

Hi all, I am running a database which records pricing errors for items. I have run a query on the main table to show all pending price corrections and have also built a form to allow the user to scroll through these pending price issues. However, I am unable to change/update any fields in the...

Good morning all, I have still been unable to find a way to do this: I have a list box "Item List"on a form "Order Form"with these columns/fields : Item ID, Item Name, Item Category, Item Description, Item Photo and WH Stock taken from a query "Stock In Store/WH". The Item Photo is a...

I have two tables, one for inventory movements and the other for orders. The orders table has columns Order Number, Item ID, Quantity, Order Date, Date Required and Order Completed (Yes or No Checkbox). I have created a query to show outstanding orders, and have included all the information...

Hi all, Seems I have a lot of questions today! I have a list box on a form with four columns/fields : Item Name, Item Category, Item Description and Item Photo. The Item Photo is a hyperlink to a file for that specific item's photo on a networked PC. Is it possible to: on double clicking...

Good morning, I am having a bit of an issue with a MS Access Database that I have created. I have a table with the following fields: ID (Primary Key), Date, Entered By, Item ID,Transaction Detail, Warehouse Location, Units Received, Units Dispatched, Units Disposed Of. To track inventory...