Search results

Hi DCrake, Thanks for your quick response, I have already tried this, and with no links or when linking warehouse, I get the same results as per attached picture. If I link the date by month fields from each query, I am given no results at all. Yet they are displayed by month in each query...

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, thanks for your help with this, I've managed to work it out, I now have a form with a subform which automatically includes all details from the main form and then creates a second transaction. So the user basically selects an item and where it's going to and the database records two...

Hi CEH, I like the concept of a Q in Q out, however in this situation we would have the same situation where if we make an internal movement we would require one record from a location and one to a location. The problem is not being able to record two locations on one record, putting in a...

CEH, back to your query on table structure, all of the fields in this table directly relate to item movements, there are seperate tables for Collection Requests, Orders, Item Details, as well as list tables used for list boxes in forms for employees, transaction types, item categories. The...

Thanks for your reply That's pretty much what I'm trying to get, however, I don't want the user to have to manually enter a transaction for dispatching from one location and receiving to another. It reduces the space for error if they simply enter the information as I've detailed above. A...

Hi all! Thanks for your replies! CEH, you're right, this project has become a monster but is completely functional now with order requests, collection requests and everything else you could possibly imagine! I am still just stuck with this issue. I am running two tables, one for inventory...

Any movement out or into the warehouse is recorded against a warehouse location. When moving items into our out of the warehouse they are recorded against a specific warehouse location so that they are added or deducted to that location. My problem with internal transfers comes into play because...

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

Thanks all for your suggestions, DCrake's suggestion worked after some fiddling around.

Hi PaulJR, Tables are as follows: Inventory Movement Table Fields: ID(Autonumber); Date; Entered By; ItemID; Transaction Detail; Order Number; CR Number; Warehouse Location; UnitsOpening; UnitsReceived; UnitsDispatched; UnitsDisposedOf; Remarks Second Table Is For Purchase Order Detail...

Hi PaulJR, Thanks for your feedback, how exactly would I go about doing that, I'm clueless when it comes to VBA... Thanks again.

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

Hi maxmangion, Thanks for your reply. Can't seem to find anything when I search for that? Do you by any chance know where this thread/post would be? I am getting quite desperate to get this working, starting to drive me up the wall. Thanks very much.

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

Hi, I can't seem to get this to work. On double clicking the sunset record, it comes up with the following errors as per the attached picture. Thanks very much for your help.

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

Thanks so much! Up and running, it was just changing the relationship that had been messing up my results, working perfectly now. Thanks again!