Search results

Had a quick look at the changes you've made, and I'm not sure you're going the right way with it at the moment... leave it with me to have a better look!

sorry for jumping in, but I just thought I'd say: I just use me.LastEditedBy=currentuser() on the beforeupdate of my forms... and that seems to work ok, without using a separate function... don't know if there are any problems with this approach?

In your Orders form, you were including the customers table. So, when you add a new order... it thinks you are adding a new customer as well. You don't need the customers table in there - all you need is the customer id field in the orders table. What you would then need to do is to tell it...

I'm not sure I understand your question? What do you mean by 'load' them in the query? In the query design, you only need to include a table IF EITHER you want to show info from that table - for example, you want to build a query that shows a customer address, but the order table (which...

I can see why you would store a cost against a transaction rather than against the item in the inventory - as Rain said, the costs may change over time... what I don't see is why you've been 'told' to put it in a separate table... but maybe that's my own lack of knowledge showing through ;)...

I guess it could be different in 2010, I'm on 2007.... but in 2007 I would using a crosstab query in Access - is that what you're doing?

how do you mean, won't enter it? I added a new order on your form, and the detail was entered? oh, and you are missing the default value on text62... it should be =[Forms]![frmNewCustomer]![ID]

Quick question: why do you have the item cost in a separate table from the transactions?

yes, put it into a query as a calculated field... and it should work! It works in mine.... (Access 2007)

in qryorders REMOVE tblCustomer.... and on the orders form, change the data source of Text62 to be CustomerID, with a default value of =[Forms]![frmNewCustomer]![ID] then all should be ok

I'd just use something like thedate: DateValue([yourdate]) and then use that... not sure if there's a better way?

try this? basically I've unlinked the main form and subform so you get everything in the subform, changed the main form to data entry and changed the Event on the button so it goes to a new record after submitting the one you're on

PS - your sig = one of my favourite poems... W H Davies if I remember correctly :)

Brian - I wasn't saying anything different, I just posted the code you suggested, in case the op hadn't understood what you meant... cos I couldn't understand why that wouldn't have worked ;)

try =iif((Format([date received],"mm/yyyy"))=(Format([date of reject],"mm/yyyy")),1,0)

If you open your frmNewCustomer, and then click the 'new order' button, your frmOrders opens without a problem. As JHB said - your problem is the control source for Text62 and Organization - they're set to look at frmNewCustomer, so will only work if that form is already open/loaded.

Ok, if by 'moving over' you mean you imported them, then you'll need to go into your database options and change the form that's displayed on startup

For the other part: you have a couple of options, but possibly the easiest is to set up a form which opens automatically when the database opens, which displays the message you want... and from which you can then load the form which you currently load automatically. if you see what I mean...

An other option would be, that you could automatically set the 'status' based on comparing the qty available to the qty ordered.... something like: Private Sub Quantity_BeforeUpdate(Cancel as Integer) Dim qtyavail As Integer qtyavail = Me.Combo20.Column(2) If Me.Quantity.Value > qtyavail...

< not a man :P