Recent content by Red6

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