jt196
Last Activity: Jun 14 '10, 03:40 PM
Joined: May 5 '10
Location:
-
Hmm well I'm not totally au fait with doing this myself but I'm learning a lot in the process. In terms of employing a developer, I certainly have entertained the thought of this - but then I'd miss out on all the fun, wouldn't I? Seriously though, learning Access through all this is going to give me so much more power and control of the bespoke system I'm setting up. It's a bit of a pain in the arse in the beginning, but I have to say, I'm a fast... -
I'm looking for a shortcut from orders --> delivery notes --> invoices
(I'll first preface this by saying that I'm about a month into Access - albeit a pretty frantic one)
OK so my setup at the moment is that I have three tables to manage the first two of the above.
T_Orders
T_DeliveryNotes
T_Transactions
An order goes on T_Orders, and its items go on T_Transactions (with a figure against Quantity_ordere d). A delivery note is raised and the items... -
Yeah like I said - did a bit of a work around so now instead of having a form with a list of the invoice numbers that need inputting, I have a form with the order details and a combo box based on the query that updates the information in the form. More or less the same - guess it's a little less quick entering the information but at the amount of orders we have on our system, it's not the end of the world... Hopefully by that time arrives, we'll...Leave a comment:
-
Hey there - no problems it's all sorted. I've made a form that uses a combo box to choose the information.
As for the need, well the system works like this:
INCOMING ORDER --> Items on TOrders + Items on TTransactions (including QuantityOrdered )
PART OR ALL ORDER GETS SHIPPED OUT --> New Delivery Note + New Items on TTransactions (the new transactions items have a delivery note ID and an order ID attached...Leave a comment:
-
NeoPa - was just following the instructions on here:
http://www.datawright.com.au/access_..._arguments.htm
The openform command is thus:
DoCmd.OpenForm FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs
So the empty space between the commas was just a default value for 'View'....Leave a comment:
-
So the QOrdersNotInvoi ced is the query with the GroupBy results in and that's the one that isn't editable. That query contains results from tables 'Orders' and 'Transactions' - summarising the results of transactions per order.
If use the command:
All that is presented to me is a list of ALL of the orders on the Orders table.Code:DoCmd.OpenForm FOrdersNotInvoiced, , QOrdersNotInvoiced
Leave a comment:
-
OK so I've tried this filter and it seems to just pull up all of the records rather than filtering out the ones on the query.
Is it possible I need to place a WHERE Condition in the next space, ie where [OrderID] = [QOrdersNotInvoi ced].[OrderID]. I've tried that and it just seems to come give me a box asking for the '[QOrdersNotInvoi ced].[OrderID]' number.
Any hints?...Leave a comment:
-
Hi NeoPa - well I probably should have said - I've only been a user of Access for a few weeks.
I've done the group by query and that's working fine, but I'm stuck at getting the form to be filtered by it. If I use the query as a data source, the records aren't updateable. How exactly do I use the query to filter the records in the form?...Leave a comment:
-
Hmm not sure if if I've explained myself correctly here. For an order to qualify as fulfilled, there needs to be a minimum of two items on the transaction table.
1 - the order coming in (and the quantity ordered)
2 - the delivery going out (and an equal quantity going out).
So I have one query that takes a summary of all of the same items on an order (order or delivery) and totals up the difference. I have a...Leave a comment:
-
How to create a form based on Summary Query
I'm trying to create an editable form of fulfilled orders on my system and am running into problems with creating a form based on this query. The field that I need to update (invoice number) is read-only. I DO understand the reasons for this:
The query takes information from an orders table and a transactions table which have a one to many relationship. I don't want to use any of the transaction fields, but I do need to use a query based...
No activity results to display
Leave a comment: