Search results

Thanks Bob - you're a star

I guess that if this can't be resolved via this forum, then it can't be done. Ian

I am getting really bogged down with this now - The attached just contains some test data and I would really appreciate it if someone could have a look at this for me. If you open the Customers form and scroll until you get to customer Berry PCs then hit the Input New Order Button. What will...

Just when you think a plan is coming together - sort one problem out and then you see another. Ref first post - button opens form OK and displays the correct customer name etc, however, it is also showing the current order number and order date rather than being blank. The sub form is working...

Dohhh !!!!!!!!! Sorry, it's been a long day. Just went into the properties of the sub form and changed Data Entry to Yes and it seems now to be working OK. Perhaps this might help someone, you never know. Off now to drown my sorrows with a glass of red wine.

Hello I have a form called Input Orders which has a sub form called Orders Details sub form. The Input Orders form is opened via a button on my Customers form. The code for the button is shown below. Private Sub New_Order_btn_Click() On Error GoTo Err_New_Order_btn_Click Dim stDocName...

Yes - I know there are several responses to this on the forums and as such I have followed the advice given but am struggling. It's in respect of opening an email in Outlook from an email address in a field. The code below opens Outlook and populates the To: Field, however after the email...

I have just noticed that when the Orders form is opened via the command button, a filter is applied and shows just 3 records. Interestingly the customer to which it refers, has currently got 3 orders in my test data. The code which controls the command button is shown below. Private Sub...

Even having used the Command Button wizard, there is still something not right with the way the function of the Input New Oder button is operating. The button correctly opens the Input Orders form, but will only populate the customer header details for records where an order has been previously...

Thanks but I have as good as zero knowledge of VB and as such am trying to do this using Macros. This is what I have in the Where function of my macro on the Open Form action. [CustomerID]=[Forms]![Customers]![CustomerID] This returns no data in the target form.

Hi I have searched through the forums and can't find exactly what it is I am trying to do. Essentially, on my Customers form, I have a command button which 'on click' opens the Input Order form - so far so good - however, what I want it to do, is open the Input Order form so that it goes to...

Great stuff - Thanks Bob Seems to be working now - well at least it's generating a number. Many thanks Ian

I have found this thread where you have previously been involved Bob, and have made some changes as suggested, however, I get the error message: Microsoft Access cannot find the macro 'Me' http://www.access-programmers.co.uk/forums/showthread.php?t=145523&highlight=incremental+number+field...

Ah I see - Thanks Bob, What I am trying to do is to create a number which uniquely identifies an order, and which increments each time a new order is raised. I thought (incorrectly it seems) that the Autonumber was the way of doing this. Would it be possible to point me in the direction of...

Hi I have been working on a database structure for some time now and the test data I have been entering has generated Order Numbers using the Autonumber function. Once I get to the point where I am happy that I have got the database to a condition where I can start to use it in anger, I want...

Hurrah !!!! I have almost cracked it. By creating a new form called Input Order, I can now input new orders and still be able to show the calculated order details in a seperate form/sub form (Orders sub form / Order Details sub form), via the View Order Details button. A couple of small...

I was thinking about this last night with glass of red wine in hand, feeling sorry for myself, as we had just lost possession of the Ryder Cup - Ah well, there's always next time in Wales. Anyway - to summarize: We know that the calculation can be done to show the total order value, but by...

Dk - Thanks for that. I had actually got this far myself at one stage, however, because of the way the qry is formulated, in that grouping is applied, means that the Orders form is deactivated, i.e. the Orders form does not allow for a new record to be entered. It is so frustrating.

Thanks guys, I have stripped out as much as I can, leaving just some dummy data on both the customers and orders tables and forms. Hopefully someone will be able to solve this. Just to recap: The Order Value field needs to be to sum of the resale price for each order. For example, order...

I give up !!!!! Despite everybodys best efforts and having tried both everything I can think of and all the suggestions that have been made, I still can't get this to work. Ian